This super long crash course will teach you raw SQL.

GitHub Repo:
https://github.com/harblaith7/sql-cc

Postgres Download:
https://www.postgresql.org/download/

Postico:
https://eggerapps.at/postico/

PopSQL:
https://popsql.com/

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

#sql #database #developer