SQL Joins with SQLite
An overview of SQL joins. We explain the concept of joins, and then see examples including inner joins, left joins, and [sort of] right joins. Once we have established the purpose of joins, we begin to apply them to data analysis, including SQL functions to do some simple statistical analysis.
-- Contents --
00:00 - Overview
00:28 - Example Data Set
02:58 - Munge the Data
03:41 - Data Normalization
04:16 - Data Anomalies
04:52 - Surrogate Keys
05:39 - Primary Key / Foreign Key Relationships
06:36 - Set Up Example Data
09:44 - Create Tables With Relationship
10:18 - Primary & Foreign Keys
10:51 - Inner Joins
13:39 - Filtering Results By Criteria
15:10 - Referential Integrity
15:36 - Left Joins
16:44 - Find Any Missing References
19:00 - NULL Values in Left Joins
20:54 - Outer Joins
22:52 - Right Joins
23:35 - Joins Recap
30:21 - Left vs Right Joins
35:41 - Quiz Question
![[Top 20] wpopoff challenge by EatingBabies First Victor](https://images.videosashka.com/watch/Eakw3QsOJps)
