Course Catalog
Master SQL through structured learning modules with hands-on practice
SQL Speed Game
Test your skills against the clock and climb the leaderboard
Daily Puzzle
Solve today's challenge and maintain your streak
Review Mistakes
Practice questions you got wrong to improve
Learn SQL
Master SQL from basics to advanced concepts through interactive lessons inspired by SQLBolt
Fundamentals
Core SQL concepts every developer needs
Introduction to SQL
Learn what SQL is and why it matters for managing data
SELECT Queries 101
Learn to retrieve data from database tables using SELECT
Queries with Constraints (Pt. 1)
Filter results using =, <>, BETWEEN, and IN operators
Queries with Constraints (Pt. 2)
Use LIKE, NOT LIKE, and wildcards for pattern matching
Filtering and Sorting Results
Master DISTINCT, ORDER BY, LIMIT, and OFFSET
Simple SELECT Review
Practice everything you have learned so far
Intermediate
Advanced querying techniques and functions
Multi-table Queries with JOINs
Combine data from multiple tables using INNER JOIN
OUTER JOINs
Use LEFT, RIGHT, and FULL OUTER JOINs
Working with NULLs
Handle NULL values properly in your queries
Expressions in Queries
Use math operations, string functions, and aliases
Aggregates (Pt. 1)
Use COUNT, MIN, MAX, AVG, SUM and GROUP BY
Aggregates (Pt. 2)
Filter grouped results with HAVING clause
Query Execution Order
Understand how SQL processes your queries
Advanced
Expert-level optimization and architecture
Inserting Rows
Add new data to tables using INSERT INTO
Updating Rows
Modify existing data with UPDATE statements
Deleting Rows
Remove data from tables using DELETE
Creating Tables
Design and create database tables with CREATE TABLE
Altering Tables
Modify table structure with ALTER TABLE
Dropping Tables
Remove tables from database with DROP TABLE
Subqueries
Write powerful nested queries for complex data problems