Free course
Learn SQL by doing
22 short lessons, each with a challenge you solve in a real database running in your browser. Start with a murder mystery, then work up to joins, schema design, PostgreSQL window functions and NoSQL.
Start lesson 101The Murder MysterySQLite
- The Crime SceneStart the SQL murder mystery: filter crime scene reports with WHERE to find the murder in SQL City.
- Finding WitnessesFind the witnesses in the SQL murder mystery with ORDER BY, LIMIT and LIKE.
- Interviewing SuspectsRead the witnesses' statements by joining two tables with SQL JOIN.
- Catch the KillerCombine every clue with multi-table JOINs and LIKE to catch the killer.
02SQL FundamentalsSQLite
- SELECT BasicsLearn the SQL SELECT statement: pick exactly the columns you need instead of SELECT *.
- Filtering with WHEREFilter rows with SQL WHERE, comparison operators, IN, LIKE and BETWEEN.
- Sorting & LimitingSort results with SQL ORDER BY (ASC and DESC) and take the top rows with LIMIT and OFFSET.
- Aggregate FunctionsCount, sum and average data with SQL aggregate functions and GROUP BY.
03Joins & RelationshipsSQLite
04Schema DesignSQLite
05PostgreSQL BasicsPostgreSQL
- Intro to PostgreSQLGet started with PostgreSQL: run your first queries on a real Postgres database in your browser, no install.
- Data TypesLearn PostgreSQL data types (SERIAL, TEXT, TIMESTAMP, JSONB and more), then build a table with them.
- String FunctionsUse PostgreSQL string functions UPPER, LOWER, LENGTH, CONCAT and TRIM.
06Advanced PostgreSQLPostgreSQL
07NoSQL BasicsNoSQL
08Data ModelingNoSQL