SQL Tutorial
SQL is how you query and change data in a relational database. These concise lessons each come with a live editor that runs a real SQLite database in your browser (via sql.js), so you write queries and see the result tables instantly. No setup and no sign-up.
1SQL IntroductionLearn what SQL is — tables, rows and columns — and run your first query in a live SQL editor in your browser.
2SQL SELECTLearn to choose columns with SELECT, using a live SQL editor that runs in your browser.
3SQL WHERELearn to filter rows with WHERE in a live SQL editor that runs in your browser.
4SQL ORDER BY and LIMITLearn to sort results with ORDER BY and cap them with LIMIT in a live browser SQL editor.
5SQL COUNT, SUM and GROUP BYLearn aggregate functions and GROUP BY in a live SQL editor that runs in your browser.
6SQL INSERT, UPDATE and DELETELearn to add, change and remove rows in a live SQL editor that runs in your browser.
7SQL JOINLearn to combine two tables with INNER JOIN in a live SQL editor that runs in your browser.
8SQL DISTINCT and LIKELearn DISTINCT and pattern matching with LIKE in a live SQL editor that runs in your browser.