Loading page
Data and query
Query relational data with readable, testable, set-based SQL.
CREATE TABLE lessons (name TEXT, minutes INTEGER);
INSERT INTO lessons VALUES ('SQL basics', 20);
SELECT * FROM lessons;COURSE CURRICULUM
Finish one section at a time or jump directly to a concept you need.
Learn how relational tables, rows, and queries works in SQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how select, aliases, and readable clauses works in SQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how parameters, expressions, and derived columns works in SQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how data types, null, and three-valued logic works in SQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how filtering, comparison, and pattern matching works in SQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how case expressions and conditional results works in SQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how set operations and recursive queries works in SQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how aggregate, scalar, and date functions works in SQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how inner, outer, and self joins works in SQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how grouping, subqueries, and common table expressions works in SQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how constraints, transactions, and safe boundaries works in SQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how views, indexes, and reusable queries works in SQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how keys, normalization, and relationships works in SQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how importing, exporting, and changing data works in SQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how window functions and query-plan testing works in SQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.