Course Problems & Certificate 👉 https://lukeb.co/sql
Course Databases & Links 👉 https://lukebarousse.com/sql
⚠️ Fix Database Load Issue in Ch 2 👉 https://lukeb.co/sql_error
IMPORTANT: Drop the database & reload tables before following!!! (Instructions in pinned comment)
Thanks to Kelly Adams for her work in producing this course 🎉🙌
👩🏻💼 Kelly's LinkedIn: https://www.linkedin.com/in/kellyjianadams/
🌐 Kelly's Website: https://www.kellyjadams.com/
Ch 1️⃣ - Basics
==============
0:00:00 - Welcome
0:03:43 - What is SQL
0:10:44 - Intro to Course
0:16:51 - The Basics
0:33:59 - Comparisons
0:41:18 - Practice Problem 1
0:45:23 - Wildcards
0:48:49 - Alias: AS
0:51:06 - Practice Problem 2
0:54:01 - Operations
0:59:37 - Aggregation
1:06:28 - Practice Problem 3
1:08:45 - NULL Values
Skipped - Practice Problem 4
1:10:07 - JOINS
1:20:15 - Order of Execution
1:22:35 - Practice Problem 5
Ch 2️⃣ - Advanced
==============
1:26:18 - Setup PostgreSQL
1:32:48 - IDE Install: VS Code
1:44:08 - Data Types
1:47:35 - Manipulate Tables
2:00:00 - Database Load
2:10:02 - Date Functions
2:20:26 - Problem Problem 6
2:25:02 - CASE Expression
2:30:24 - SubQueries and CTEs
2:42:21 - Practice Problem 7
2:50:11 - UNION Operators
2:54:28 - Practice Problem 8
Ch 3️⃣ - Project
==============
2:58:11 - About the Project
3:02:17 - Create the Repository
3:14:50 - Query 1 - Top Paying Jobs
3:20:42 - Query 2 - Top Paying Job's Skills
3:28:10 - Query 3 - In-Demand Skills
3:34:14 - Query 4 - Top Paying Skills
3:41:37 - Query 5 - Most Optimal Skills
3:53:14 - Share on GitHub
4:05:16 - Share on LinkedIn
Social Media / Contact Me
======================
📫Newsletter: https://www.lukebarousse.com/
👨🏼💼 Linkedin: https://www.linkedin.com/in/luke-b/
🅧 X/Twitter: https://twitter.com/LukeBarousse
🌄 Instagram: https://www.instagram.com/lukebarousse/
⏰ TikTok: https://www.tiktok.com/@lukebarousse
#sql #postgresql #sqlite