Learn SQL

Learn SQL from scratch with hands-on, interactive tutorials. Master SELECT queries, JOINs, aggregates, subqueries, indexes, and transactions — write and run real SQL in your browser. All lessons free.

Start Learning →

All Tutorials

1

Getting Started with SQL

What SQL is, how databases work, and your first SELECT query.

beginner

2

SELECT & WHERE

Filter rows with WHERE conditions, comparison operators, LIKE, IN, and BETWEEN.

beginner

3

ORDER BY & LIMIT

Sort query results with ORDER BY and retrieve top N rows with LIMIT and OFFSET.

beginner

4

Aggregate Functions

COUNT, SUM, AVG, MIN, MAX — summarize groups of rows into single values.

beginner

5

JOINs

Combine data from multiple tables with INNER JOIN, LEFT JOIN, and RIGHT JOIN.

intermediate

6

INSERT, UPDATE, DELETE

Modify data in your database — add rows, change values, and remove records safely.

beginner

7

Subqueries

Use the result of one SELECT query inside another — in WHERE, FROM, and SELECT clauses.

intermediate

8

Common Table Expressions (CTEs)

Write cleaner, readable queries with WITH clauses — reusable named subqueries.

intermediate

Why learn SQL?

SQL (Structured Query Language) is the universal language of data — every application that stores information uses it. Databases powered by SQL run at companies like Google, Amazon, Meta, and every bank, hospital, and e-commerce site on the planet. Knowing SQL is one of the most transferable skills in tech: it's required for software engineers, data analysts, data scientists, and product managers alike.

What you'll learn in this SQL tutorial

This free, interactive SQL course covers SELECT queries, filtering with WHERE, sorting with ORDER BY, aggregate functions (COUNT, SUM, AVG, MIN, MAX), GROUP BY and HAVING, JOINs (INNER, LEFT, RIGHT, FULL), subqueries, CTEs, window functions, indexes, transactions, and database design — all by writing and running real SQL queries in your browser.

8 topics · 25 hands-on lessons · all levels

SQL tutorial topics

Who is this SQL course for?

Complete beginners who want to learn how to query databases, developers who need to work with data in their applications, data analysts and data scientists, and engineers preparing for SQL coding interviews or data engineering roles.

5

JOINsCombine data from multiple tables with INNER JOIN, LEFT JOIN, and RIGHT JOIN. · 3 lessons

6INSERT, UPDATE, DELETEModify data in your database — add rows, change values, and remove records safel… · 3 lessons

7SubqueriesUse the result of one SELECT query inside another — in WHERE, FROM, and SELECT c… · 3 lessons

8Common Table Expressions (CTEs)Write cleaner, readable queries with WITH clauses — reusable named subqueries. · 3 lessons