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/grokk.... 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