Intermediate SQL
for Data Analytics
My full tutorial to level up
your SQL analytic skills
Support my free content and unlock the full course experience with premium resources and community access
Unlock Full Access
Pricing
FREE OPTION
Free
Features:
✅ 6+ Hour YouTube Course
✅ Complete Portfolio Project
✅ Links to Required Materials & Resources
👇 Scroll Down for Material Links 👇
SUPPORTERS
$30
Everything in free option and:
✅ 80+ Interview-Level Problems
✅ Playlist-Style Lesson Videos
✅ Community Access
✅ Course Notes
✅ Certificate of Completion
Free Resources
1️⃣ Run Queries Remotely
We'll use this environment for the first half of the course.
Contoso Dataset - Blank SQL Notebook
Run this Google Colab SQL environment in any internet browser. The dataset loaded here comes from Contoso, a fictional retail company used by Microsoft to simulate real-world business scenarios.
2️⃣ Run Queries Locally
We'll cover this installation in the second half of the course.
Contoso Dataset - Download
Get the dataset used in the course to practice SQL queries with real-world business data.
PostgreSQL - Download
Install the world's most popular open-source SQL database engine; we'll use PostgreSQL 17 for the course.
DBeaver - Download
Get the most popular multi-database query tool for seamlessly exploring and managing SQL queries.
3️⃣ Final Project
Luke's Final SQL Analysis
This is the GitHub repository I built for this course's final project; It details all of my analysis along with the insights I gained along the way; This is meant as a guide for students to follow and not to just copy
Supporter Resources
📝 Practice Problems
🧩 80+ SQL Interview-Level Problems: Practice with real-world scenarios and challenges modeled after what you'd face in actual interviews
🔍 Detailed Solutions and Results: Every problem is accompanied by a comprehensive solution and your expected query results
📺 Structured Video Lessons
🚢 Navigate with Ease: Jump instantly to any lesson or specific topic within the course – no more wasting time scrubbing through hours of video to find what you need
🧠 Focused Learning: Master concepts more effectively with dedicated, bite-sized videos for each distinct lesson, allowing for better concentration and easier review
🗒️ Notes & SQL Queries
📖 Detailed Lesson Breakdown: Every aspect of the course content is meticulously detailed, ensuring you grasp the full curriculum
🔍 In-Depth SQL Query Analysis: SQL queries are broken down with precision, enhancing your understanding and application skills
✨ Certificate of Completion
🎖️ Certificate of Completion: Receive a certificate to validate your new skills and enhance your LinkedIn profile
🧑💻 Showcase Experience: Share how you used real-world data to help solve a problem for data professionals
About the Instructors
Luke Barousse - Course Instructor
🌎 Real-world Experience with SQL
Spearheaded innovative projects in collaboration with MrBeast's team, integrating popular tools like SQL & Python.
💡🤖 Sharing Knowledge about Data & AI
Guides a community of +500,000 data nerds in harnessing analytical tools to revolutionize their professional workflows.
🎓 Trusted Course Developer
Imparted wisdom to +30,000 learners on DataCamp in leveraging analytical tools to elevate their career efficiency.
Kelly Adams - Course Producer
🕹️ Hands on Experience with SQL
Driving strategic decisions within the social gaming industry at Golden Hearts Games, using popular tools like Google BigQuery and Looker.
📝 LinkedIn Content Creator
Documenting the day-to-day life of a full-time data analyst and teaching SQL to over 50,000 data professionals.
📹 Course Producer for Data Analytics Content
Educating an audience of analysts about the latest data analytical tools to improve their professional skill sets.
100% Satisfaction Guarantee or Your Money Back
⏱️ If you don’t feel the course problems and notes help you learn this tool as it has for countless others, I’ll refund your money!
📫 Email me within 30 days of purchasing the course on why you are unsatisfied, and I’ll return the full purchase price to you ASAP.
