Programming Academy
Database Design
Design robust databases from scratch — ERDs, normalisation, relationships, keys and real-world case studies.
K
Taught by
Kofi Mensah
Kofi Mensah
About this course
Great software starts with great data design. This course teaches you to design databases properly: entities, relationships, entity-relationship diagrams, normalisation, keys and common design patterns — before you write a single line of SQL.\n\nYou will design databases for a school, a shop and an LMS from scratch, and learn to avoid the mistakes that plague real-world projects.
What you'll learn
Model real-world things as entities and attributes\n- Map relationships: one-to-one, one-to-many, many-to-many\n- Draw entity-relationship diagrams\n- Apply normalisation up to 3NF\n- Choose primary keys, foreign keys and indexes\n- Design for performance and growth\n- Avoid classic design mistakes\n- Work through real case studies end to end\n- Download a PDF guide with every lesson
Course curriculum
3 modules · 9 lessons · around 80 min of video
The Fundamentals
- From Requirements to Data Preview 8 min
- Entities & Attributes Preview 9 min
- Relationships Preview 10 min
Modelling & Normalisation
- Entity-Relationship Diagrams Preview 9 min
- Normalisation Preview 10 min
- Keys & Referential Integrity 8 min
Real-World Design
- Design Patterns Preview 9 min
- Common Mistakes 8 min
- Case Study: An LMS 9 min
Requirements
Basic database concepts (see the MySQL Databases course)\n- SQL fundamentals are helpful but not required
Instructor
K
Kofi Mensah
Instructor