Database Design
I. Fundamentals
1. What is Database Design
2. Why Database Design is Important
3. OLTP vs OLAP Systems
4. Types of Databases
5. Data vs Information
6. Entities and Attributes
7. Keys in Database Design
8. Introduction to Relationships
II. Conceptual Design (ER)
9. Conceptual vs Logical vs Physical Design
10. Entity Relationship Model
11. ER Diagram Symbols
12. One-to-One Relationships
13. One-to-Many Relationships
14. Many-to-Many Relationships
15. Weak Entities
16. Cardinality & Participation
17. ER Diagram Case Study
III. Normalization & Logical
18. What is Normalization
19. First Normal Form (1NF)
20. Second Normal Form (2NF)
21. Third Normal Form (3NF)
22. Boyce–Codd Normal Form (BCNF)
23. Denormalization
24. Surrogate vs Natural Keys
25. Handling NULLs in Design
26. Referential Integrity
27. Logical Schema Design
IV. Physical & Enterprise