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
