Completed
Strong vs Weak Entities
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Relational Database Design - Full Course
Automatically move to the next video in the Classroom when playback concludes
- 1 Relational Databases for Beginners — Tables, Entities, Keys & SQL
- 2 SQL Filtering & Aggregation
- 3 SQL Table Commands
- 4 Foreign Keys in SQL
- 5 How SQL JOINs Work
- 6 How to learn SQL on your own
- 7 Database Design Goals
- 8 Database Design Lifecycle
- 9 From Real-World Ideas to Tables
- 10 Primary Key, Candidate Key, and Super Key
- 11 Don't Use the Wrong SQL String Type
- 12 The FLOAT Mistake That Crashed a Stock Exchange
- 13 SQL Date and Time Types Explained
- 14 Connecting Entities in an ER Diagram
- 15 One-to-One Relationships
- 16 One-to-Many Relationships
- 17 Many-to-Many Relationships
- 18 Strong vs Weak Entities
- 19 First Normal Form - Primary Keys and Atomic Values
- 20 Second Normal Form - Partial Keys and Functional Dependencies
- 21 Third Normal Form - Transitive Dependencies
- 22 The Untold Story of BCNF
- 23 Primary Key vs Unique Constraints
- 24 Foreign Key Constraints - ON DELETE & ON UPDATE
- 25 Other Constraints: NOT NULL, DEFAULT, and CHECK
- 26 Access Control, Hashing & Encryption
- 27 B-Tree vs Full-Text Indexes
- 28 Denormalization
