SQL for Data Analytics
My full tutorial to help you
analyze data with SQL
Support my free video content by
purchasing the course problems and certificate
📝 Purchase Problems & Certificate
Pricing
FREE OPTION
Free
Features:
✅ Full Video Course
✅ All Required Course Resources
✅ SQL Query Environment
✅ Guided GitHub Project
✅ Full Dataset Access (linked below 👇)
SUPPORTERS
$25
Everything in free option and:
✅ 60+ Practice Problems
✅ Course Notes & Examples
✅ SQL Query Breakdowns
✅ Certificate of Completion
Free Resources
1️⃣ Basics Chapter - Datasets
Jobs Dataset - SQL Environment
This is the main SQL enviornment for the ‘Basics’ chapter; This dataset is of real-world data science job postings from 2023 and is hosted freely via sqliteviz
Invoices Dataset - SQL Environment
This is the secondary SQL enviornment for the ‘Operations’ section; This is a fictious dataset on data science job invoices and is hosted freely via sqliteviz
2️⃣ Advanced Chapter - Files
Advanced & Project Dataset Files
This is a larger dataset of real-world data science job postings from 2023; This is a Google Drive link to download the CSV and SQL files to load the dataset into your PostgreSQL database
Download PostgreSQL
A link for you to install PostgreSQL
Download VS Code
A link for you to install Visual Studio Code
3️⃣ Project Chapter - 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
🧩 60+ Tailored Exercises: Learn SQL faster with meticulously designed exercises spanning a range from easy to challenging
🔍 Detailed Solutions and Results: Every problem is accompanied by a comprehensive solution and your expected query results
📝 Notes & SQL Queries
📖 Detailed Course Breakdown: Every aspect of the course content is meticulously detailed, ensuring you grasp the full curriculum
🔍 In-Depth SQL Query Analysis: Break down SQL queries with precision, enhancing your understanding and application skills
🌐 Notion Integration: Access and incorporate these valuable notes into your own Notion workspace, allowing for easy reference and future review
✨ 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
Who Is This For?
Perfect for absolute beginners 👶 eager to analyze their first dataset
Also for hard-core data nerds 🤓 seeking to streamline their analysis
🚫 Zero Experience Needed:
If you can handle high school math, you're set
🚫 Absolutely No Prerequisites:
Repetition for reassurance 😬
✅ I'll Cover the Rest in the Course:
From foundational concepts to advanced analytics
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 +400,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 40,000 data professionals.
📹 Course Producer for Data Analytics Content
Educating an audience of +400,000 analysts about the latest data analytical tools to improve their professional skill sets.
100% Satisfaction Guarantee or Your Money Back