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
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
- 01
Introduction to SQL
What SQL is and how to write your first query.
- 02
Basic SELECT
Selecting columns, rows, and distinct values.
- 03
WHERE Clause
Filtering rows with simple conditions.
- 04
ORDER BY
Sorting results in ascending or descending order.
- 05
LIMIT and OFFSET
Limit results, skip rows, and compare common variants for paginating queries.
-
+35 more lessons in the app
The full syllabus, the explanations and the practice are in the app.
SQL course syllabus
Beginner 10 lessons
- Introduction to SQL
- Basic SELECT
- WHERE Clause
- ORDER BY
- LIMIT and OFFSET
- Logical Operators
- BETWEEN, IN, LIKE
- Aggregate Functions
- GROUP BY and HAVING
- DISTINCT and Aliases
Intermediate 15 lessons
- INSERT INTO
- UPDATE and DELETE
- CREATE TABLE
- Data Types
- ALTER TABLE and Constraints
- INNER JOIN
- LEFT and RIGHT JOIN
- FULL OUTER JOIN
- Self-Join and Multiple JOINs
- CROSS JOIN and NATURAL JOIN
- Subqueries in WHERE
- Subqueries in FROM
- EXISTS and NOT EXISTS
- Views
- Materialized Views and Temp Tables
Advanced 15 lessons
- CASE WHEN
- String Functions
- Date Functions
- CAST, CONVERT, and COALESCE
- Advanced Aggregate Functions
- Indexes
- Constraints
- Normalization
- Transactions
- EXPLAIN and Execution Plan
- Window Functions
- CTEs
- UNION, INTERSECT, EXCEPT
- Procedures and Triggers
- 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.
DownloadQuestions 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.