DataBase Design Lesson 33 – Designing for Security | Dataplexa

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
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
← Previous Course Index Next →