Curriculum for the course 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/newsWatch Online Full Course: Relational Database Design – Full Course
Click Here to watch on Youtube: Relational Database Design – Full Course
This video is first published on youtube via freecodecamp. If Video does not appear here, you can watch this on Youtube always.
Udemy Relational Database Design – Full Course courses free download, Plurasight Relational Database Design – Full Course courses free download, Linda Relational Database Design – Full Course courses free download, Coursera Relational Database Design – Full Course course download free, Brad Hussey udemy course free, free programming full course download, full course with project files, Download full project free, College major project download, CS major project idea, EC major project idea, clone projects download free