This list brings together the best free resources for learning SQL. If you're interested in how these resources rank, you can go to the Learning SQL Reddit page and go to the wiki. Click on any of the link categories and you will get a ranked list of content in that category. Instructions for custom searching the Reddit page are at the bottom of the wiki.
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 the following:
- Reddit: This is a link to the post on Reddit
- LinkedIn: This is a link to the post on LinkedIn
- Source: The original link where the info was first discovered (will update to original source if it can be found)
- SQL for Data Analytics — Beginners Guide by Standford University [Reddit] [LinkedIn]
- Select Star SQL [Reddit] [LinkedIn]
- SQL Server Execution Plans
- Use the Index, Luke [Reddit] [LinkedIn]
- SQL Blog - KDNuggets [Reddit] [LinkedIn]
- SQL Topic Blogs - Medium [Reddit] [LinkedIn]
- Learning SQL Blog - Medium
- Alex The Analyst - YouTube [Reddit] [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 [LinkedIn]
- SQL Joins — Join Diagram [LinkedIn]
- SQL Joins - Join Diagram Highlighted Rows [Source] [LinkedIn]
SQL Interview Cheatsheets
- SQL Interview Questions & Answers [Reddit] [LinkedIn]
- SQL Interview Questions by Atul Kumar [Reddit] [LinkedIn]
SQL Order of Execution Cheatsheets
SQL Commands Cheatsheets
- Basic Statistics Using SQL [Reddit] [LinkedIn]
- SQL Mind Map
- SQL Commands Cheatsheet
- 3 Page SQL Commands Cheatsheet from SQL Tutorial [LinkedIn]
- SQL Visuals for SQL Sprinters Cheatsheet [LinkedIn]
- SQL Cheatsheet for Data Science
- Data Prep with SQL Quick Reference
- The Big 6 of SQL Query Cheatsheet
- Row Number, Rank, and Dense Rank [LinkedIn]
- SQL Commands Categories - GeeksforGeeks [LinkedIn]
General SQL Cheatsheets
- Common Commands SQL Cheatsheet [Reddit] [LinkedIn]
- Database Types
- SQL Cheatsheet Booklet from InterviewBit [Reddit] [LinkedIn]
- SQL Concepts - Data.World
General/ANSI SQL
- Khan Academy - Intro to SQL: Querying and Managing Data [Reddit]
- Danny Ma - 8 Week SQL Challenge [Reddit] [LinkedIn]
- Codecademy - Learn SQL [Reddit]
- Kaggle - Intro to SQL [Reddit]
- SQL Courses - Edx (Freemium)
- Google BigQuery Sandbox [LinkedIn]
- PostgreSQL Online Database [Reddit]
- SQLite Online Database [Reddit]
- SQL Fiddle
- Codewars [Reddit]
- HackerRank
- LeetCode (Freemium) [Reddit]
- SQL Murder Mystery [Reddit]
- SQLBattle
- Advanced SQL Puzzles [Reddit] [LinkedIn]
- Ace The SQL Interview by DataLemur [LinkedIn]
General/ANSI SQL
- SQL Tutorial - SQLcourse.com
- SQL Zoo [Reddit]
- SQL Bolt [Reddit]
- 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
- SQL Interactive Tutorial - SQLteaching.com
- SQL Tutorial - data.world
- SQL Tutorial - geeksforgeeks
Postgres SQL
MySQL
- MySQL Tutorial for Beginners Full Course
Books
- Practical SQL - Anthony Debarros [Reddit]
- SQL for Data Analysis - Cathy Tanimura (O'Reilly) [Reddit]
- Learning SQL - Alan Beaulieu (O'Reilly) [Reddit]
- SQL with Practice Exercises - D Armstrong [Reddit]
Courses