Luke Barousse
๐ 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
Complete understanding of the topic
Hands-on practical knowledge
Real-world examples and use cases
Industry best practices
Take your learning to the next level with premium features