Intermediate SQL
for Data Analytics

My full tutorial to level up
your SQL analytic skills

 
Support my free video content by
purchasing the course problems and certificate
📝 Purchase Problems & Certificate
Video Poster Image

Pricing

FREE OPTION

Free

Features:

✅ Full Video Course

✅ Complete Portfolio Project

✅ All Required Course Materials

👇 All Resources Linked Below 👇

 

SUPPORTERS

$30

Everything in free option and:

✅ 80+ Interview-Level Problems

✅ Community Access 

✅ Course Notes

✅ Certificate of Completion

Purchase Supporter Resources

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

 

 

📝 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

 

✨ Purchase Supporter Resources

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.

FAQ

✨ Purchase Supporter Resources