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