Uploaded February 2026 | Updated September 2026, 1 hour ago

---

Power your data pipelines with SerpApi 👉 serpapi.link/luke
🏆 Supporter Access: Problems, Certificate, & More 👉 lukeb.co/sql-de

My FREE Crash Course to be a Data Analyst 👉 lukebarousse.com/5daycourse

𝗖𝗼𝘂𝗿𝘀𝗲 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
▔▔▔▔▔▔▔▔
GitHub Repo 👉 lukeb.co/sql-de-github
Project #1 👉 lukeb.co/sql-de-project1
Project #2 👉 lukeb.co/sql-de-project2
MotherDuck Signup 👉 lukeb.co/motherduck
DuckDB Install (Don't use DuckDB.org) 👉 lukeb.co/duckdb

Attach the data_jobs database based on your region by running ONE of the following:
-- us-east-1 or eu-central-1
ATTACH 'md:_share/data_jobs/87603155-cdc7-4c80-85ad-3a6b0d760d93' AS data_jobs;
-- us-west-2
ATTACH 'md:_share/data_jobs/a94f9b8a-2b8a-473f-bb86-de09552f052d' AS data_jobs;
-- eu-west-1
ATTACH 'md:_share/data_jobs/058ad1f4-939b-4998-95e1-0df8f8644f3c' AS data_jobs;
-- ap-northeast-1
ATTACH 'md:_share/data_jobs/bfebcfd1-016a-4f13-87b1-e6cb852eda98' AS data_jobs;
-- ap-southeast-2
ATTACH 'md:_share/data_jobs/dddd85e6-ba93-40d0-8649-bc91194f0afe' AS data_jobs;

⚠️ MotherDuck free trial expired?
No worries — just go to Settings → Plans in the UI and select the Lite plan (still 100% free, no credit card needed)

0️⃣ 𝗖𝗼𝘂𝗿𝘀𝗲 𝗜𝗻𝘁𝗿𝗼
00:00:00 Course Intro
00:06:11 What is SQL?
00:12:15 Data & Pipeline Intro

1️⃣ 𝗦𝗤𝗟 𝗙𝗼𝘂𝗻𝗱𝗮𝘁𝗶𝗼𝗻𝘀
00:18:39 SQL & Dataset Setup
00:32:39 Basic Keywords
00:52:06 Comparison & Logical Operators
01:14:52 Wildcards & Aliases
01:26:10 Arithmetic Operators
01:38:10 Aggregate Functions
01:55:01 Terminal Intro
02:28:32 Local DuckDB Intro
03:06:24 VS Code Intro
03:28:56 Data Modeling Pt.1
03:49:10 JOINs
04:11:34 Order of Execution

📊 𝗘𝘅𝗽𝗹𝗼𝗿𝗮𝘁𝗼𝗿𝘆 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝘄/ 𝗦𝗤𝗟 — 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 #1
04:30:51 Project #1 Intro
04:38:54 EDA #1 In-Demand Skills
04:47:27 EDA #2 Highest Paying Skills
04:56:02 EDA #3 Most Optimal Skills
05:10:58 README.md Build
05:27:27 Git & GitHub Pt.1
06:03:49 Share Project #1

2️⃣ 𝗣𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝗼𝗻 𝗦𝗤𝗟
06:10:27 Data Types
06:27:17 DDL & DML Pt.1
07:04:57 DDL & DML Pt.2
07:30:28 Subqueries and CTEs
08:06:07 DDL & DML Pt.3
08:44:55 Data Modeling Pt.2
09:08:07 CASE Expressions
09:28:54 Date Functions
09:51:19 SET Operators
10:08:04 Text & NULL Functions
10:26:16 Window Functions
11:00:04 Nested Functions
11:50:17 Git & GitHub Pt.2

🏗️ 𝗗𝗮𝘁𝗮 𝗪𝗮𝗿𝗲𝗵𝗼𝘂𝘀𝗲 & 𝗘𝗧𝗟 𝗣𝗶𝗽𝗲𝗹𝗶𝗻𝗲 — 𝗣𝗿𝗼𝗷𝗲𝗰𝘁 #2
12:32:36 Project #2 Intro
12:43:08 Build Data Warehouse
13:21:00 Build Flat Table Mart
13:40:03 Build Skills Mart
14:07:45 Build Priority Mart
14:29:40 README.md Build
14:40:58 Share Project #2

𝗠𝘆 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗡𝗲𝗿𝗱𝘀
▔▔▔▔▔▔▔▔▔▔▔▔
💽 SQL for Data Analytics 👉🏼 youtu.be/7mz73uXD9DA
❎ Excel for Data Analytics 👉🏼 youtu.be/pCJ15nGFgVg
📊 Power BI for Data Analytics 👉🏼 youtu.be/FwjaHCVNBWA
🐍 Python for Data Analytics 👉🏼 youtu.be/wUSDVGivd-8
⚛️ ChatGPT for Data Analytics 👉🏼 youtu.be/uhyMqbZI6rM
🙌 Support my FREE Courses 👉🏼 lukeb.co/courses

𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮
▔▔▔▔▔▔
📫 Newsletter: lukebarousse.com/5daycourse
👨🏼‍💼 LinkedIn: linkedin.com/in/luke-b
👾 GitHub: github.com/lukebarousse
🅧 X/Twitter: twitter.com/LukeBarousse
🌄 Instagram: instagram.com/lukebarousse
⏰ TikTok: tiktok.com/@lukebarousse

𝗧𝗲𝗮𝗺’𝘀 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮
▔▔▔▔▔▔▔▔▔
🎬 Course Producer: Kelly Adams 👉 linkedin.com/in/kellyjianadams
💻 Content Developer: Rikki Singh 👉 linkedin.com/in/rikkisingh
📺 Video Editor: Brannon Linder 👉 linkedin.com/in/brannonlinder

#datanerd #dataengineering #sql