SQL for Data Analytics – Intermediate Course + Project

???? FREE Course Files & Resources ???? https://www.lukebarousse.com/int-sql
???? Supporter Access: Problems, Certificate, & More ???? https://lukeb.co/int-sql
????️ Blank SQL Notebook ???? https://lukeb.co/int-sql-colab

My FREE Course to be a Data Analyst ???? https://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 ???? https://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 -...