๐ Course Problems & Certificate ๐ https://lukeb.co/int-sql
๐ Course Resources & Links ๐ https://www.lukebarousse.com/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 - 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 ๐๐ผ https://youtu.be/7mz73uXD9DA
โ Excel for Data Analytics ๐๐ผ https://youtu.be/pCJ15nGFgVg
๐ Python for Data Analytics ๐๐ผ https://youtu.be/wUSDVGivd-8
โ๏ธ ChatGPT for Data Analytics ๐๐ผ https://youtu.be/uhyMqbZI6rM
๐ Support my FREE Courses ๐๐ผ https://lukeb.co/courses
๐ฆ๐ผ๐ฐ๐ถ๐ฎ๐น ๐ ๐ฒ๐ฑ๐ถ๐ฎ
โโโโโโ
๐ซ Newsletter: https://lukebarousse.com/5daycourse
๐จ๐ผโ๐ผ 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
๐๐ฒ๐น๐น๐'๐ ๐ฆ๐ผ๐ฐ๐ถ๐ฎ๐น ๐ ๐ฒ๐ฑ๐ถ๐ฎ
โโโโโโโโโ
Kellyโs LinkedIn: https://www.linkedin.com/in/kellyjianadams/
Kellyโs Website: https://www.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