SQL Crash Course - Learn Raw SQL for Beginners

This super long crash course will teach you raw SQL. GitHub Repo: Postgres Download: Postico: PopSQL: Timeline: 0:00 - Intro to SQL 8:12 - Download Postgres 15:22 - Data Structure 29:00 - Inserting Data 37:11 - Selecting Data 43:18 - Deleting Data 44:45 - Primary Key Constraint 57:25 - Filtering Data 1:10:56 - AND, OR, NOT 1:18:39 - Ordering/Sorting Data 1:31:05 - Challenge 1 1:48:13 - Relationships 2:02:36 - Foreign Keys 2:13:02 - Bridge/Join Table 2:22:15 - Inner Joins 2:31:27 - Right, Left, Outer Joins 2:42:08 - Many to Many Joins 2:48:37 - Group By 2:57:20 - Unions 3:03:12 - Challenge 2 3:26:40 - Subqueries 3:48:23 - Datatypes 4:02:05 - Altering a Table