☰ Learn SQL Tutorial Menu

Free tutorial · with live playground

Learn SQL Tutorial

Query real data with SELECT, joins, aggregates and window functions — every lesson runs in the live playground.

Start the Tutorial Open Playground

1What is SQL? Databases 101

2Your Practice Database: A Guided Tour

3The SELECT Statement

4Filtering Rows with WHERE

5Understanding NULL

6Sorting Results with ORDER BY

7Pattern Matching with LIKE

8Aggregate Functions: COUNT, SUM, AVG, MIN, MAX

9Grouping Data: GROUP BY and HAVING

10Joining Tables: INNER JOIN

11Outer Joins: LEFT, RIGHT, and FULL

12Self Joins and Multi-Table Queries

13Subqueries: Queries Inside Queries

14Combining Result Sets: UNION, INTERSECT, EXCEPT

15String Functions

16Date and Time Functions

17CASE Expressions: Conditional Logic in SQL

18Creating and Modifying Tables: DDL

19Inserting, Updating, and Deleting Data (DML)

20Keys, Constraints, and Relationships

21Views: Saving Queries as Virtual Tables

22Window Functions: ROW_NUMBER, RANK, and More

23Common Table Expressions (CTEs) and Recursive Queries

24Transactions and ACID

25Indexes and Query Performance

26Database Normalization

27Practice Challenges: Put It All Together