Here's a structured learning path with entirely free resources, organized by skill level.
Foundation
Kaggle: Intro to SQL - kaggle.com/learn/intro-to-sql
Free interactive course using real-world datasets. Perfect for data analysts, teaches SQL fundamentals through hands-on exercises with actual data.
ThoughtSpot (formerly Mode Analytics): SQL Tutorial - thoughtspot.com/sql-tutorial/introduction-to-sql
Interactive tutorial, one of the best free resources. Teaches to answer typical data analysis questions using a real-world dataset.
Skillup: SQL for Data Analysis - simplilearn.com/free-sql-for-data-analysis-course-skillup
A bit too "light", but provides structured video format if you prefer lectures over interactive tutorials. Optional - only if you need more structure.
Building Practical Skills
DataLemur: SQL Tutorial for Data Scientists & Data Analysts - datalemur.com/sql-tutorial
Great modern "textbook" for analysts that teaches business logic.
Luke Barousse: SQL for Data Analytics - Learn SQL in 4 Hours - youtube.com/watch?v=7mz73uXD9DA
Released in 2024, it's a video that teaches SQL needed for reporting and dashboards, skipping SQL for software engineers.
Real-World Application
Udacity: SQL for Data Analysis - udacity.com/course/sql-for-data-analysis--ud198
Hidden gem, focuses on data cleaning and aggregation which is 80% of data analyst's actual job.
Alex The Analyst: Data Analyst Portfolio Projects - youtube.com/playlist?list=PLUaB-1hjhk8H48Pj32z4GZgGWyylqv85f
Created in 2021, uses a raw dataset and shows how to explore it.
Comprehensive Mastery
Skillup: SQL for Data Science (2-hour version) - simplilearn.com/sql-for-data-science-free-course-skillup
Despite saying "Data science", it's actually a pure data analysis course. (Choose 2-hour version, not 1-hour "Data Analysis" one.)
Alex The Analyst: Data Analyst Bootcamp - youtube.com/playlist?list=PLUaB-1hjhk8FE_XZ87vPPSfHqb6OcM0cF
Comprehensive bootcamp covering the full data analyst skill set.
Udemy: SQL for Real-World Data Analysis - udemy.com/course/sql-for-real-world-data-analysis
Comprehensive course focused on practical, real-world scenarios.
Foundational Knowledge (Reference, not sequential)
Udacity: Intro to Relational Databases - udacity.com/course/intro-to-relational-databases--ud197
Not for data analysis specifically, but provides deep understanding of how databases work. Useful reference.
For a complete curated list of free SQL resources including courses for beginners, interactive games, and more, check out the GitHub repository: github.com/zezere/best-resources-to-learn-sql. The list is organized by learning path and updated regularly.
Top comments (0)