learnthings
← All paths

SQL, from your first SELECT to window functions

Get a real database running, learn the queries you write every day, then joins, CTEs and window functions — with exercise sites to practise on after each stage.

69 sources·16 rooms

Published by learnthings · 2h ago

sqldatabasesdata analysis
You get your own copy — yours to change, and to take notes on.

Stage 1 · What a database is, and getting one running

video

Databases, and installing one

3
  1. 1How to learn SQL for free | Roadmap to learning SQLyoutube.com
  2. 2Learn What is Database | Types of Database | DBMSyoutube.com
  3. 3How to install PostgreSQL on Mac OS | Install and Uninstall PostgreSQL Databaseyoutube.com
read

Two front doors

2
  1. 4SQLBolt — interactive lessons in the browsersqlbolt.com
  2. 5The PostgreSQL tutorialpostgresql.org

Stage 2 · The queries you write every day

video

SELECT, WHERE, GROUP BY, ORDER BY

6
  1. 6Installing MySQL and Creating Databases | MySQL for Beginnersyoutube.com
  2. 7Select Statement in MySQL | Beginner MySQL Seriesyoutube.com
  3. 8Where Clause in MySQL | Beginner MySQL Seriesyoutube.com
  4. 9Group By + Order By in MySQL | Beginner MySQL Seriesyoutube.com
  5. 10Having vs Where in MySQL | Beginner MySQL Seriesyoutube.com
  6. 11Limit + Aliasing in MySQL | MySQL Beginner Seriesyoutube.com
video

The same ground, with joins begun

3
  1. 12SQL Basics Tutorial for Beginners (Practice SQL Queries)youtube.com
  2. 13SQL JOINS Tutorial for beginners | Practice SQL Queries using JOINS - Part 1youtube.com
  3. 14SQL JOINS Tutorial for beginners | Practice SQL Queries using JOINS - Part 2youtube.com
read

Practise as you go

3
  1. 15SQLZoosqlzoo.net
  2. 16Select Star SQL — an interactive bookselectstarsql.com
  3. 17The MySQL tutorialdev.mysql.com

Stage 3 · Joins, subqueries, CTEs and windows

video

Joins, unions, cases, subqueries, windows

6
  1. 18Joins in MySQL | Intermediate MySQLyoutube.com
  2. 19Unions in MySQL | Intermediate MySQLyoutube.com
  3. 20String Functions in MySQL | Intermediate MySQL Seriesyoutube.com
  4. 21Case Statements in MySQL | Intermediate MySQLyoutube.com
  5. 22Subqueries in MySQL | Intermediate MySQLyoutube.com
  6. 23Window Functions in MySQL | Intermediate MySQLyoutube.com
video

Subqueries, WITH, and window functions in depth

4
  1. 24Subquery in SQL | Correlated Subquery + Complete SQL Subqueries Tutorialyoutube.com
  2. 25SQL WITH Clause | How to write SQL Queries using WITH Clause | SQL CTE (Common Table Expression)youtube.com
  3. 26SQL Window Function | How to write SQL Query using RANK, DENSE RANK, LEAD/LAG | SQL Queries Tutorialyoutube.com
  4. 27SQL Window Function | How to write SQL Query using Frame Clause, CUME_DIST | SQL Queries Tutorialyoutube.com
read

Exercises with a real schema

1
  1. 28PostgreSQL Exercisespgexercises.com

Stage 4 · Practice on real problems

video

Intermediate query practice

10
  1. 29Solving SQL Interview Queries | Tricky SQL Interview Queriesyoutube.com
  2. 30Learn how to write SQL Queries(Practice Complex SQL Queries)youtube.com
  3. 31Practice Writing SQL Queries using Real Dataset(Practice Complex SQL Queries)youtube.com
  4. 32SQL Interview Assignment Queries | REAL SQL Assignment given in Interview Part 2 (Query Solution)youtube.com
  5. 33SQL Interview Assignment Queries | REAL SQL Assignment given in Interview Part 1 (Problem Statement)youtube.com
  6. 34Practice SQL Interview Questions on LeetCode | Solve SQL Interview Questions (Practice SQL Queries)youtube.com
  7. 35Solving SQL Interview Query | Ungroup given input data | FAANG Interview Queryyoutube.com
  8. 36Practice SQL Interview Query | Big 4 Interview Questionyoutube.com
  9. 37Solving SQL Interview Query using a "VERY IMPORTANT SQL concept"youtube.com
  10. 38Tricky SQL Interview Query | Practice Solving SQL Interview Queriesyoutube.com
video

Complex query practice

6
  1. 39REAL SQL Interview Question by a FAANG company | SQL Interview Query and Solutionyoutube.com
  2. 40Practice Writing SQL Queries on StrataScratch | How to Solve SQL Queriesyoutube.com
  3. 41Solving Complex SQL Query from HackerRank | SQL Interview Queryyoutube.com
  4. 42REAL SQL Interview Question | Complex SQL Interview Query and Solutionyoutube.com
  5. 43Solving SQL Query | Rows to Column in SQLyoutube.com
  6. 44Practice Complex SQL Queries | SQL Query to fetch N consecutive recordsyoutube.com
video

Interview-style problems

5
  1. 45SQL Interview Problem: The Suspicious Split (+ 2 Challenges to Solve Yourself)youtube.com
  2. 46SQL Interview Question | Can You Solve This Inventory Stockout Problem?youtube.com
  3. 47FAANG-Style SQL Interview Question | Consecutive Months Streak Challengeyoutube.com
  4. 48Top 3 SQL Interview Questions You Must Know (With Answers)youtube.com
  5. 49Solving an SQL Problem during Data Analyst Interviewyoutube.com

Stage 5 · Beyond queries

video

CTEs, temp tables, procedures, triggers

4
  1. 50CTEs in MySQL | Advanced MySQL Seriesyoutube.com
  2. 51Temp Tables in MySQL | Advanced MySQL Seriesyoutube.com
  3. 52Stored Procedures in MySQL | Advanced MySQL Seriesyoutube.com
  4. 53Triggers and Events in MySQL | Advanced MySQL Seriesyoutube.com
video

Views, recursion, and query craft

6
  1. 54SQL Views Tutorial | VIEWS in SQL Complete Tutorialyoutube.com
  2. 55Recursive SQL Queries Tutorial | Learn to write SQL Queries using Recursionyoutube.com
  3. 56Materialized View in SQL | Faster SQL Queries using Materialized Viewsyoutube.com
  4. 57LATERAL Joins in SQL | Write Smarter SQL Queriesyoutube.com
  5. 58GROUPING SETS vs ROLLUP vs CUBE in SQL | Advanced SQL Tutorial with Examplesyoutube.com
  6. 597 Simple Tricks to Instantly Make Your SQL Queries Betteryoutube.com
read

Making queries fast, and readable

2
  1. 60Use The Index, Luke — SQL indexing and tuninguse-the-index-luke.com
  2. 61SQL style guidesqlstyle.guide
read

The courses these videos come from

7
  1. 62techTFQ: Learn Complete SQL (Beginner to Advance) (21 videos)youtube.com
  2. 63techTFQ: Practice Solving INTERMEDIATE SQL Queries (22 videos)youtube.com
  3. 64techTFQ: Practice Solving COMPLEX SQL Queries (11 videos)youtube.com
  4. 65techTFQ: SQL Interview Problems (5 videos)youtube.com
  5. 66Alex The Analyst: MySQL Basics Tutorial Series (6 videos)youtube.com
  6. 67Alex The Analyst: Intermediate MySQL Tutorial Series (6 videos)youtube.com
  7. 68Alex The Analyst: Advanced MySQL Tutorial Series (4 videos)youtube.com
notebook

How to use this path

1
  1. 69Type every query
SQL, from your first SELECT to window functions · learnthings