Uploaded March 2025 | Updated September 2026, 10 hours ago

---

📁 FREE Course Files & Resources 👉 lukebarousse.com/int-sql
🏆 Supporter Access: Problems, Certificate, & More 👉 lukeb.co/int-sql
🗒️ Blank SQL Notebook 👉 lukeb.co/int-sql-colab

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

𝗖𝗼𝘂𝗿𝘀𝗲 𝗢𝘂𝘁𝗹𝗶𝗻𝗲
▔▔▔▔▔▔▔
0️⃣ Intro
00:00 - About Course: Welcome
04:41 - About Course: Q&A
08:34 - Colab Notebooks
19:19 - Database Overview
`net_revenue` Calculation Correction 👉 youtu.be/B9HJGN07FrQ

1️⃣ Pivot With Case Statements
37:44 - Basic Aggregation
52:24 - Statistical Aggregations
1:04:47 - Advanced Segmentation

2️⃣ Date Time
1:25:28 - Date Format
1:33:13 - Date Filtering
1:42:19 - Date Differences

3️⃣ Window Functions
1:53:36 - Syntax
2:11:59 - Aggregation
2:32:36 - Ranking
2:47:16 - Lag Lead
3:01:28 - Frame Clause

4️⃣ Local DB Setup
3:14:21 - Install PostgreSQL
3:25:38 - Install DBeaver

5️⃣ Views
3:45:59 - View Intro
4:06:27 - Project Cohort Revenue
4:16:17 - Install VSCode

6️⃣ Data Cleaning
4:36:22 - Conditional Handle Nulls
4:49:05 - String Formatting
4:55:52 - Project Customer Segmentation

7️⃣ Query Optimization
5:10:55 - Explain Intro
5:26:29 - Optimization Techniques
5:42:10 - Project Customer Retention

8️⃣ Share Project
6:04:16 - Create GitHub Repo
6:22:27 - Share on LinkedIn

𝗠𝘆 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗳𝗼𝗿 𝗗𝗮𝘁𝗮 𝗡𝗲𝗿𝗱𝘀
▔▔▔▔▔▔▔▔▔▔▔▔
💽 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
🅧 X/Twitter: twitter.com/LukeBarousse
🌄 Instagram: instagram.com/lukebarousse
⏰ TikTok: tiktok.com/@lukebarousse

𝗞𝗲𝗹𝗹𝘆'𝘀 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮
▔▔▔▔▔▔▔▔▔
Kelly’s LinkedIn: linkedin.com/in/kellyjianadams
Kelly’s Website: kellyjadams.com

As an Amazon, Coursera, and Parallels Affiliate Program member, I earn a commission from qualifying purchases on the links above. This does not cost you anything but helps support making more content.

#datanerd #dataanalyst #dataanalytics