PostgreSQL & MySQL
The open-source relational databases behind most web applications, and SQL practice.
Beginner
Start here. No background needed beyond school maths.
PostgreSQL Tutorial
Step-by-step lessons on SQL in ••••, from selecting and filtering to joins, window functions, indexes and stored procedures.
Sign up to see the source
SQL Tutorial (ThoughtSpot, formerly Mode)
A SQL course aimed at analysts, with a basic, intermediate and advanced track and real data to practise on.
Sign up to see the source
MySQL Tutorial
MySQL's own walkthrough: connect, create tables, load data and run the queries you will use every day.
Sign up to see the source
PostgreSQL Exercises
Practice questions on a sample club database that you answer in the browser, from simple selects to window functions and recursive queries.
Sign up to see the source
SQLZoo
Old and loved interactive SQL tutorials with quizzes that run against real tables.
Sign up to see the source
Advanced
Once the basics are comfortable.
PostgreSQL EXPLAIN Glossary
Reads like a dictionary for query plans: what each node in EXPLAIN output means and what to look for when a query is slow.
Sign up to see the source
PostgreSQL Wiki: Don't Do This
A short list of common •••• mistakes and what to do instead, from choosing data types to using timestamps and NULL correctly.
Sign up to see the source