Completed
) Outer Join Across 3 Tables
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Database Design Course - Learn how to design and plan a database for beginners
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) What is a Database?
- 3 ) What is a Relational Database?
- 4 ) RDBMS
- 5 ) Introduction to SQL
- 6 ) Naming Conventions
- 7 ) What is Database Design?
- 8 ) Data Integrity
- 9 ) Database Terms
- 10 ) More Database Terms
- 11 ) Atomic Values
- 12 ) Relationships
- 13 ) One-to-One Relationships
- 14 ) One-to-Many Relationships
- 15 ) Many-to-Many Relationships
- 16 ) Designing One-to-One Relationships
- 17 ) Designing One-to-Many Relationships
- 18 ) Parent Tables and Child Tables
- 19 ) Designing Many-to-Many Relationships
- 20 ) Summary of Relationships
- 21 ) Introduction to Keys
- 22 ) Primary Key Index
- 23 ) Look up Table
- 24 ) Superkey and Candidate Key
- 25 ) Primary Key and Alternate Key
- 26 ) Surrogate Key and Natural Key
- 27 ) Should I use Surrogate Keys or Natural Keys?
- 28 ) Foreign Key
- 29 ) NOT NULL Foreign Key
- 30 ) Foreign Key Constraints
- 31 ) Simple Key, Composite Key, Compound Key
- 32 ) Review and Key Points....HA GET IT? KEY points!
- 33 ) Introduction to Entity Relationship Modeling
- 34 ) Cardinality
- 35 ) Modality
- 36 ) Introduction to Database Normalization
- 37 ) 1NF (First Normal Form of Database Normalization)
- 38 ) 2NF (Second Normal Form of Database Normalization)
- 39 ) 3NF (Third Normal Form of Database Normalization)
- 40 ) Indexes (Clustered, Nonclustered, Composite Index)
- 41 ) Data Types
- 42 ) Introduction to Joins
- 43 ) Inner Join
- 44 ) Inner Join on 3 Tables
- 45 ) Inner Join on 3 Tables (Example)
- 46 ) Introduction to Outer Joins
- 47 ) Right Outer Join
- 48 ) JOIN with NOT NULL Columns
- 49 ) Outer Join Across 3 Tables
- 50 ) Alias
- 51 ) Self Join
