Introduction
  • Course Introduction
  • Courses Bonuses (Database Design Cheatsheet & Database Terminology)
Database Basics
  • What is a database?
  • How do a databases work and why are they important?
  • Different Types of Databases
  • What is a Relational Database?
Database Modeling and Design
  • What is Database Design?
  • What are the three types of Database Design?
  • Database Modeling and Design tools
  • Setup MySQL Workbench and prepare the work environment
Database Design Phase 1 - Normalization
  • Define Conceptual and Logical Design for an Online Store
  • What is Database Normalization?
  • First Normal Form
  • Second Normal Form
  • Third Normal Form
  • Third Normal Form Clarifications on Zip Codes - Street relation
Database Design Phase 2 - Relationships
  • Database Relationships. Identifying vs Non-Identifying. Cardinality.
  • One to One Relationship
  • One to Many Relationship
  • Many to Many Relationship
Finalizing the e-commerce DB
  • Finalize Database Model
  • Generate the Physical Database Schema
Database Design Interview Practice - Quiz Test - 35 Questions
  • 35 Popular Database Design Interview Questions
  • 35 Popular Database Design Interview Questions - Answers
Course Conclusions
  • Conclusion