This list brings together the best free resources for learning SQL. This list is constantly being updated, so please add an issue or pull request if you have anything to add.
A lot of beginners learning SQL aren't sure where to start learning SQL or even where to look for content. This is a quick list of places to start that I believe will give them the best chance at success in getting their first job in the data world. However, this compilation of resources should still have something valuable for those who are more advanced as well.
To add to this repository, feel free to either open a pull request or an issue, both are great ways to help build this resource.
Each resource may be tagged with a LinkedIn link in addition to the original link. The LinkedIn link is a link to the affiliated LinkedIn page post about the particular resource on the "Learning SQL" publication page.
- SQL for Data Analytics — Beginners Guide by Standford University [LinkedIn]
- SQL Server Execution Plans
- Use the Index, Luke [LinkedIn]
- Learning SQL Stack Overflow eBook
- SQL Blog - KDNuggets [LinkedIn]
- SQL Topic Blogs - Medium [LinkedIn]
- Learning SQL Blog - Medium
- Alex The Analyst - YouTube [LinkedIn]
- Ankit Bansal - YouTube [LinkedIn]
- TechTFQ - YouTube [LinkedIn]
- Kudvenkat - YouTube
SQL Join Cheatsheets
- SQL Joins — Venn Diagram - C.L. Moffat [LinkedIn]
- SQL Joins — Venn Diagram Alternate
- SQL Joins — Checkered Flag Diagram - Hadley Wickham/Andreas Martinson [LinkedIn]
- SQL Joins — Join Diagram - Google [LinkedIn]
- SQL Joins - Join Diagram Highlighted Rows [Source] [LinkedIn]
SQL Order of Execution Cheatsheets
SQL Commands Cheatsheets
- SQL Mind Map - Data Engineering LATAM
- SQL Commands Cheatsheet - yosracodes
- Data Prep with SQL Quick Reference
- The Big 6 of SQL Query Cheatsheet - Maven Analytics
- Row Number, Rank, and Dense Rank - Jess Ramos [LinkedIn]
- SQL Commands Categories - GeeksforGeeks [LinkedIn]
General SQL Cheatsheets
SQL Joins
SQL Interview Cheatsheets
- SQL Interview Questions & Answers [LinkedIn]
- SQL Interview Questions - Atul Kumar [LinkedIn]
- MySQL Interview Questions - Stratascratch [LinkedIn]
SQL Commands Cheatsheets
- Basic Statistics Using SQL [LinkedIn]
- 3 Page SQL Commands Cheatsheet from SQL Tutorial [LinkedIn]
- SQL Visuals for SQL Sprinters Cheatsheet - Thom Ives/ Ghaith Sankari [LinkedIn]
- SQL Cheatsheet for Data Science
General SQL Cheatsheets
- SQL Cheatsheet Booklet - InterviewBit [LinkedIn]
- SQL Cheat Sheet - Steve Nouri [LinkedIn]
- SQL Basics Cheat Sheet - LearnSQL.com [LinkedIn]
- SQL for Data Analysis - Kyle Malone [LinkedIn]
General
Online Databases for Practice
Open-Source Databases for Practice
Interactive
- SQLBattle
- Schemaverse
- SQL Murder Mystery [LinkedIn]
- Codewars
- HackerRank
- LeetCode (Freemium)
- Ace The SQL Interview - DataLemur [LinkedIn]
- SQL Concepts - Data.World
AI Tools
General/ANSI SQL
- SQL Tutorial - SQLcourse.com
- Relational Database - freecodecamp
- Awesome Repo (Databases Section)
- SQL Tutorial - SQLtutorial.org
- SQL Tutorial - W3 Schools
- SQL Tutorial - Mode
- SQL Tutorial - tutorialspoint.com [LinkedIn]
- SQL Tutorial - Bipp.io [LinkedIn
- SQL Tutorial - geeksforgeeks
Interactive
- Khan Academy - Intro to SQL: Querying and Managing Data
- Danny Ma - 8 Week SQL Challenge [LinkedIn]
- Codecademy - Learn SQL
- Kaggle - Intro to SQL
- SQL Courses - Edx (Freemium)
- SQL Zoo
- SQL Bolt
- SQL Interactive Tutorial - SQLteaching.com
- GalaXQL SQL Galaxy Interactive Tutorial
- Select Star SQL [LinkedIn]
- SQL Tutorial - data.world
Postgres SQL
MySQL
- MySQL Tutorial for Beginners - Programming with Mosh
- SQL and Databases - A Full Course for Beginners - freecodecamp [LinkedIn]
Data Modeling
Books
- Practical SQL - Anthony Debarros
- SQL for Data Analysis - Cathy Tanimura (O'Reilly)
- Learning SQL - Alan Beaulieu (O'Reilly)
- SQL with Practice Exercises - D Armstrong
- SQL Antipatterns
Interactive Courses/Tutorials
- Learn SQL - Datacamp
- Maven Analytics
- SQL Courses - Coursera
- SQL Courses - Udemy
- SQL Courses - learnsql.com
- 21 Days to Data - Avery Smith
- Data with Danny - Danny Ma
Tutorials/Courses
Practice