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…
Watch on YouTube ↗
(saves to browser)
Chapters (28)
Relational Databases for Beginners — Tables, Entities, Keys & SQL
16:32
SQL Filtering & Aggregation
33:23
SQL Table Commands
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
Playlist
Uploads from freeCodeCamp.org · freeCodeCamp.org · 0 of 60
← Previous
Next →
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
![Python Automation Tutorial – How to Automate Tasks for Beginners [Full Course]](https://i.ytimg.com/vi/s8XjEuplx_U/mqdefault.jpg)
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Deploy 12 apps to AWS, Azure, & Google Cloud
freeCodeCamp.org
Reinforcement Learning Course: Intro to Advanced Actor Critic Methods
freeCodeCamp.org
How does the internet work? (Full Course)
freeCodeCamp.org
Code a Dictionary with React and Material UI - Tutorial
freeCodeCamp.org
Graph Algorithms for Technical Interviews - Full Course
freeCodeCamp.org
HTML Tutorial - Website Crash Course for Beginners
freeCodeCamp.org
Google Cloud Digital Leader Certification Course - Pass the Exam!
freeCodeCamp.org
Advanced OpenGL - Crash Course
freeCodeCamp.org
FastAPI Course for Beginners
freeCodeCamp.org
Google Sheets - Full Course
freeCodeCamp.org
Python Django and Google APIs - Project Tutorial
freeCodeCamp.org
Java Native Interface (28-Hour Course)
freeCodeCamp.org
Learn How to Code - Programming for Beginners Tutorial with Python and C#
freeCodeCamp.org
Android Programming Course - Kotlin, Jetpack Compose UI, Graph Data Structures & Algorithms
freeCodeCamp.org
Code a Discord Chat Bot That Talks Like Your Favorite Character - Tutorial
freeCodeCamp.org
Machine Learning Course for Beginners
freeCodeCamp.org
Selenium Course for Beginners - Web Scraping Bots, Browser Automation, Testing (Tutorial)
freeCodeCamp.org
Figma Course - Web Design Tutorial for Beginners
freeCodeCamp.org
Vue.js Course for Beginners
freeCodeCamp.org
Data Structures and Algorithms in Python - Full Course for Beginners
freeCodeCamp.org
Solidity, Blockchain, and Smart Contract Course – Beginner to Expert Python Tutorial
freeCodeCamp.org
Linux Essentials for Ethical Hackers - Full InfoSec Course
freeCodeCamp.org
Gatsby Static Site Generator Tutorial
freeCodeCamp.org
Django For Everybody - Full Python University Course
freeCodeCamp.org
Python Automation Tutorial – How to Automate Tasks for Beginners [Full Course]
freeCodeCamp.org
R Shiny for Data Science Tutorial – Build Interactive Data-Driven Web Apps
freeCodeCamp.org
Natural Language Processing with spaCy & Python - Course for Beginners
freeCodeCamp.org
HTML & CSS Project Tutorial - Build a Recipes Website
freeCodeCamp.org
Git for Professionals Tutorial - Tools & Concepts for Mastering Version Control with Git
freeCodeCamp.org
TensorFlow for Computer Vision Course - Full Python Tutorial for Beginners
freeCodeCamp.org
HashiCorp Terraform Associate Certification Course - Pass the Exam!
freeCodeCamp.org
AWS VPC Beginner to Pro - Virtual Private Cloud Tutorial
freeCodeCamp.org
Object Oriented Programming with Python - Full Course for Beginners
freeCodeCamp.org
Node.js / Express Course - Build 4 Projects
freeCodeCamp.org
Binary Tree Algorithms for Technical Interviews - Full Course
freeCodeCamp.org
TensorFlow Lite for Edge Devices - Tutorial
freeCodeCamp.org
Angular Tutorial for Beginners - Web Framework with Typescript Course
freeCodeCamp.org
Unreal Engine & C++ Tutorial - Endless Runner Game 🏃🏽♀️
freeCodeCamp.org
Android App Development Tutorial for Beginners - Your First App
freeCodeCamp.org
Django Tutorial - Create a Digital Resume with a Python Backend
freeCodeCamp.org
Learn React by Building an eCommerce Site - Tutorial
freeCodeCamp.org
JavaScript Tutorial - PuzzleCam Game
freeCodeCamp.org
Python API Development - Comprehensive Course for Beginners
freeCodeCamp.org
The 50 Most Popular Linux & Terminal Commands - Full Course for Beginners
freeCodeCamp.org
Web Applications for Everybody Course - Dr. Chuck Teaches HTML, PHP, SQL, CSS, JavaScript, and more!
freeCodeCamp.org
Code a Squid Game JavaScript Game Using Three.js - Tutorial for Beginners
freeCodeCamp.org
Micro-Frontends Course - Beginner to Expert
freeCodeCamp.org
Unreal Engine & C++ Tutorial - 1st Person Shooter Game
freeCodeCamp.org
C++ Programming Tutorial - Build a 3-Band Compressor Audio Plugin (w/ JUCE Framework)
freeCodeCamp.org
Infrastructure as Code - Crash Course
freeCodeCamp.org
AWS Certified Cloud Practitioner Certification Course (CLF-C01) - Pass the Exam!
freeCodeCamp.org
Advanced Git Tutorial - Interactive Rebase, Cherry-Picking, Reflog, Submodules and more
freeCodeCamp.org
Learn ASP.NET Core MVC (.NET 6) - Full Course
freeCodeCamp.org
Feature Toggles - Why and How to Add to Your Software
freeCodeCamp.org
Data Analysis with Python for Excel Users - Full Course
freeCodeCamp.org
NoSQL Database Tutorial – Full Course for Beginners
freeCodeCamp.org
Rust Programming Course for Beginners - Tutorial
freeCodeCamp.org
Razor Pages for ASP.NET Core - Full Course (.NET 6)
freeCodeCamp.org
The Business of Building Apps - App Product Management Course for Developers
freeCodeCamp.org
Bootstrap CSS Framework - Full Course for Beginners
freeCodeCamp.org
DeepCamp AI