Design
youtube
Learn relational database design from the ground up in this comprehensive course. This 8-week curriculum covers SQL fundamentals, entity-relationship modeling, normalization (1NF through BCNF), data types and constraints, indexing strategies, and query optimization.
You can get the complete learning experience with weekly schedules, quizzes and hands-on assignments at All materials are freely available.
This course is based on the book Grokking Relational Database Design by Dr. Qiang Hao and Dr. Michael Tsikerdekis (Manning Publications, 2025): The book provides additional depth and context with extended examples and a cohesive narrative that follows a single complex design throughout.
⭐️ Contents ⭐️
0:00:00 Relational Databases for Beginners — Tables, Entities, Keys & SQL
0:16:32 SQL Filtering & Aggregation
0:33:23 SQL Table Commands
0:45:57 Foreign Keys in SQL
1:01:54 How SQL JOINs Work
1:17:03 How to learn SQL on your own
1:31:48 Database Design Goals
1:39:25 Database Design Lifecycle
1:51:17 From Real-World Ideas to Tables
2:01:24 Primary Key, Candidate Key, and Super Key
2:14:25 Don't Use the Wrong SQL String Type
2:24:08 The FLOAT Mistake That Crashed a Stock Exchange
2:33:31 SQL Date and Time Types Explained
2:38:48 Connecting Entities in an ER Diagram
2:47:36 One-to-One Relationships
3:03:19 One-to-Many Relationships
3:14:18 Many-to-Many Relationships
3:24:54 Strong vs Weak Entities
3:38:05 First Normal Form - Primary Keys and Atomic Values
3:50:21 Second Normal
|
2026/01/27
youtube
