All SQL Academy courses

From your first SELECT to database architecture — four interactive courses with auto-checking in the browser. A free foundation (JOIN, aggregates, subqueries), then pick a direction: query optimization in PostgreSQL, SQL for analytics, or database design.

Start here

The free basic course lays the foundation: SELECT, JOIN, aggregates, subqueries. Without it, any advanced course or interview will be harder than it needs to be.

Basic SQL course

Free

MySQL

PostgreSQL

~30 hours

Interactive course from scratch. You write queries right in the browser; the answer is checked automatically against a real database. SELECT, JOIN, aggregates, subqueries — everything you need to pass the SQL section of an interview.

Walk into an SQL interview confident — JOIN, GROUP BY, subqueries on autopilot
Close your own SQL tickets without escalating to the analytics team
Read SQL in teammates' pull requests — no more 'um, not sure'

Start learning

Ready for the next level?

Advanced courses

After the basic course you write SQL confidently. Where you go next is up to you: some focus on performance, some on analytics, some on data architecture. We have an advanced course for each direction — deep, on real-world problems.

SQL Query Optimization in PostgreSQL

Premium

PostgreSQL

10 hours

Stop guessing why your queries are slow. Learn to read EXPLAIN, pick indexes for specific tasks, and speed up queries by 100x+ on real production cases.

Close 'this query is slow' tickets yourself — via EXPLAIN, indexes, statistics
Cut latency on slow production queries by 10–100×
Explain to your team why the planner picked this plan

Start learning

SQL for Data Analysis

Premium

MySQL

PostgreSQL

15 hours

Learn to answer product questions right in the database — no dumping into Python or BI tools. You'll master pivot tables, time series analysis, retention, funnels, and user segmentation — all in pure SQL.

Answer product questions in Slack in minutes, not days
Build cohorts, funnels, and retention in pure SQL — no Python exports
Stop hitting the GROUP BY ceiling — windows and time series handle 80% of cases

Start learning

DB Design and Architecture

Premium

PostgreSQL

15 hours

From the first table to a live system under load. Learn not to memorize answers but to spot the forks: which key, which type, which lock, how to migrate the schema without taking prod down.

Design schemas that won't be rewritten in a year under load
Implement tricky cases — history, hierarchies, JSONB — without code-side hacks
Ship migrations on big tables without 'we'll need a one-hour outage'

Start learning

All advanced courses are included inpremium— together with AI hints, certificates, and other features.