SQL

Free

Learn SQL on your iPhone

Learn SQL with 40 short lessons and 200 exercises. Each lesson explains the idea, shows you an example and gets you practicing, with an AI tutor that gives hints when you get stuck.

lessons
40
exercises
200
Beginner
10
Intermediate
15
Advanced
15
Syntax, the 3D SyntaxQuest mascot

What is SQL used for?

SQL is the language for querying and managing relational databases. It lets you filter, group and join data, and it is useful for developers, analysts and anyone who works with data.

How the course starts

  1. 01

    Introduction to SQL

    What SQL is and how to write your first query.

  2. 02

    Basic SELECT

    Selecting columns, rows, and distinct values.

  3. 03

    WHERE Clause

    Filtering rows with simple conditions.

  4. 04

    ORDER BY

    Sorting results in ascending or descending order.

  5. 05

    LIMIT and OFFSET

    Limit results, skip rows, and compare common variants for paginating queries.

  6. +35 more lessons in the app

    The full syllabus, the explanations and the practice are in the app.

SQL course syllabus

Beginner 10 lessons

  1. Introduction to SQL
  2. Basic SELECT
  3. WHERE Clause
  4. ORDER BY
  5. LIMIT and OFFSET
  6. Logical Operators
  7. BETWEEN, IN, LIKE
  8. Aggregate Functions
  9. GROUP BY and HAVING
  10. DISTINCT and Aliases

Intermediate 15 lessons

  1. INSERT INTO
  2. UPDATE and DELETE
  3. CREATE TABLE
  4. Data Types
  5. ALTER TABLE and Constraints
  6. INNER JOIN
  7. LEFT and RIGHT JOIN
  8. FULL OUTER JOIN
  9. Self-Join and Multiple JOINs
  10. CROSS JOIN and NATURAL JOIN
  11. Subqueries in WHERE
  12. Subqueries in FROM
  13. EXISTS and NOT EXISTS
  14. Views
  15. Materialized Views and Temp Tables

Advanced 15 lessons

  1. CASE WHEN
  2. String Functions
  3. Date Functions
  4. CAST, CONVERT, and COALESCE
  5. Advanced Aggregate Functions
  6. Indexes
  7. Constraints
  8. Normalization
  9. Transactions
  10. EXPLAIN and Execution Plan
  11. Window Functions
  12. CTEs
  13. UNION, INTERSECT, EXCEPT
  14. Procedures and Triggers
  15. Security and Permissions

A question from the course

Basic SELECT

Complete the query to select all columns:

SELECT ___ FROM products;

The answer, the explanation and many more exercises are waiting for you in the app.

Download

Questions about the course

Is the SQL course free?

Yes. SQL is one of SyntaxQuest's free courses: download the app and start without paying.

Do I need experience to learn SQL?

No. The course starts at beginner level (10 lessons) and moves on to intermediate and advanced at your pace.

How long is the SQL course?

It has 40 lessons and 200 exercises. Lessons are short, so you can move forward a few minutes a day; adaptive learning brings back what you are about to forget.