Loading page
Data and query
Apply SQL concepts to a popular relational database system.
SELECT title, minutes
FROM lessons
WHERE minutes < 30;COURSE CURRICULUM
Finish one section at a time or jump directly to a concept you need.
Learn how mysql servers, schemas, clients, and sql modes works in MySQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how select, aliases, clauses, and statement syntax works in MySQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how parameters, variables, generated values, and sessions works in MySQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how numeric, text, temporal, json, and null types works in MySQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how filtering, comparison, collation, and expressions works in MySQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how case, if, transactions, and conditional work works in MySQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how set queries, recursive ctes, and batch operations works in MySQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how aggregate, scalar, date, and json functions works in MySQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how joins, grouping, subqueries, and result sets works in MySQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how text search, collations, and pattern matching works in MySQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how constraints, transactions, locks, and safe updates works in MySQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how views, procedures, triggers, indexes, and schemas works in MySQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how keys, normalization, foreign keys, and relationships works in MySQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how imports, replication, backups, and data change works in MySQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.
Learn how window functions, explain, and query testing works in MySQL, why the underlying model matters, and how to apply it in a small program without hiding important trade-offs.