THE FULL SQL LEARNING PATH
Read it. Try it.
Make it click.
The complete 19-lesson library: clear explanations, worked examples, and exercises you can run as you learn.
0 of 19 lessons completed on this browser · All lessons are open; choose the topic you need.
LESSONS 1–5
Start with a question
SELECT, filtering, sorting, and single-table practice.
SELECT Queries 101
Learn the fundamentals of SQL SELECT statements with the Pixar movies database.
Read the lesson · Try the exercises →Queries with Constraints (Pt. 1)
Master WHERE clauses and filtering data with basic conditions.
Read the lesson · Try the exercises →Queries with Constraints (Pt. 2)
Advanced filtering with LIKE, IN, BETWEEN, and text patterns.
Read the lesson · Try the exercises →Filtering and Sorting Query Results
Learn ORDER BY, LIMIT, and advanced result manipulation.
Read the lesson · Try the exercises →Simple SELECT Queries Review
Review and practice all single-table query concepts.
Read the lesson · Try the exercises →LESSONS 6–12
Connect and summarize
JOINs, NULLs, expressions, aggregates, and query order.
Multi-table Queries with JOINs
Combine data from multiple tables using INNER JOIN operations.
Read the lesson · Try the exercises →OUTER JOINs
Learn LEFT JOIN, RIGHT JOIN, and FULL JOIN to include unmatched rows.
Read the lesson · Try the exercises →A Short Note on NULLs
Handle NULL values in SQL queries with IS NULL and IS NOT NULL constraints.
Read the lesson · Try the exercises →Queries with Expressions
Use mathematical expressions, functions, and aliases to transform data in queries.
Read the lesson · Try the exercises →Queries with Aggregates (Pt. 1)
Summarize data using aggregate functions like COUNT, MIN, MAX, AVG, and SUM with GROUP BY.
Read the lesson · Try the exercises →Queries with Aggregates (Pt. 2)
Learn advanced aggregate techniques with the HAVING clause to filter grouped results.
Read the lesson · Try the exercises →Order of Execution of a Query
Understand how SQL processes queries step-by-step and master complex query construction.
Read the lesson · Try the exercises →LESSONS 13–19
Build and change a database
INSERT, UPDATE, DELETE, CREATE, ALTER, DROP, and the mastery challenge.
Inserting Rows
Learn to add new data to databases using INSERT statements and understand database schemas.
Read the lesson · Try the exercises →Updating Rows
Learn to modify existing data in databases using UPDATE statements with proper WHERE conditions.
Read the lesson · Try the exercises →Deleting Rows
Learn to remove data from databases using DELETE statements with proper WHERE conditions and safety practices.
Read the lesson · Try the exercises →Creating Tables
Learn to create new database tables using CREATE TABLE statements and define table schemas with data types and constraints.
Read the lesson · Try the exercises →Altering Tables
Learn to modify existing table structures using ALTER TABLE statements to add columns, rename tables, and understand database limitations.
Read the lesson · Try the exercises →Dropping Tables
Learn to remove entire tables from your database using DROP TABLE statements and understand the implications of destructive operations.
Read the lesson · Try the exercises →SQL Mastery Challenge
Test your comprehensive SQL knowledge with advanced challenges covering all concepts from basic queries to complex joins and calculations.
Read the lesson · Try the exercises →Recovered from the original classroom, including SQLBolt-based practice lessons. Current assignments, deadlines, and grades are on Canvas.