Database Design Course Index – Dataplexa
Database Design

Database Design Course Index

Master database design from fundamentals to enterprise-level architecture. Learn ER modeling, normalization, logical and physical design, performance, scalability, and real-world database design practices.

Open Database Design Course Back to Learning Hub

I. Fundamentals (8 Lessons)

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 Modeling)

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 Design

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 Design

28. Physical Database Design 29. Indexing Strategy 30. Partitioning Concepts 31. Designing for Performance 32. Designing for Scalability 33. Designing for Security 34. Database Design for Microservices 35. Mini Project