Relational Database Design – Full Course

From the creator

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 https://github.com/StructuredCS/grokking-relational-database-design. 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): https://mng.bz/PRER. 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 En

Published 2026-01-27 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.