SQL for Data Analytics – Intermediate Course + Project

🌟 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