SQL for Data Analytics - Full Beginner and Intermediate Course - SQL for Data Analytics – Intermediate Course + Project

5.0 (2)

15 learners

What you'll learn

This course includes

10.5 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

data viz by luke business intelligence data science bi computer science data nerd data analyst data scientist how to data project data analytics portfolio project

Full Transcript

📁 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 - 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 📊 Power BI for Data Analytics 👉🏼 https://youtu.be/FwjaHCVNBWA 🐍 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

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

Mastering the New SAT: Tips and Strategies from Khan Academy

Master the New SAT: Expert Tips & Strategies by Khan Academy - Boost Your Skills in Reading, Writing, & Math

⭐ 5.0

26 ratings

0 min

30-Day Beginner Guitar Challenge for New Players

Master the Guitar in 30 Days: Your Ultimate Beginner Challenge! Unleash your inner guitarist with step-by-step lessons designed to transform you from novice to confident player. Join Your Guitar Academy and kickstart your musical journey today!

⭐ 4.3

36 ratings

7 hours