Relational Database Design – Full Course
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 Entities 3:38:05 First Normal Form - Primary Keys and Atomic Values 3:50:21 Second Normal Form - Partial Keys and Functional Dependencies 4:04:37 Third Normal Form - Transitive Dependencies 4:18:58 The Untold Story of BCNF 4:26:18 Primary Key vs Unique Constraints 4:40:15 Foreign Key Constraints - ON DELETE & ON UPDATE 4:50:31 Other Constraints: NOT NULL, DEFAULT, and CHECK 5:08:59 Access Control, Hashing & Encryption 5:29:47 B-Tree vs Full-Text Indexes 5:41:46 Denormalization ❤️ Support for this channel comes from our friends at Scrimba – the coding platform that's reinvented interactive learning: https://scrimba.com/freecodecamp 🎉 Thanks to our Champion and Sponsor supporters: 👾 @omerhattapoglu1158 👾 @goddardtan 👾 @akihayashi6629 👾 @kikilogsin 👾 @anthonycampbell2148 👾 @tobymiller7790 👾 @rajibdassharma497 👾 @CloudVirtualizationEnthusiast 👾 @adilsoncarlosvianacarlos 👾 @martinmacchia1564 👾 @ulisesmoralez4160 👾 @_Oscar_ 👾 @jedi-or-sith2728 👾 @justinhual1290 -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news
