Microsoft Sql Server

TOPIC DAY 1

Sql for SA & BA
  • ER-DIAGRAM
  • SQL SYNTAX
  • DATABASE
    • Master Table
    • Detail Table
    • Primary Kay
    • Foreign key
    • 1 to 1
    • 1 to Many
    • Many to Many
  • UNION , INTERSECT, MIN, MAX ,ORDER BY AND ETC.

TOPIC DAY 2

Sql for SA & BA
  • Database normalization
    • First normal form (1NF) – Redundancy
    • Second normal form (2NF) – Duplicate
    • Third normal form (3NF) - Nothing but the key
    • Fourth normal form (4NF) - Multivalued dependencies
    • Fifth normal form (5NF) - Project-Join normal form (PJ/NF)
  • Join, Left Join, Right Join, Sql Function
  • Crosstab Query Report


สอบถามราคาและข้อมูลเพิ่มเติม

ให้บริการ จ.-ศ. 9:30 น. ถึง 18:30 น.