Syllabus
Getting started
Filtering and sorting
- WHERE: filtering rows12 min
- AND, OR, NOT and parentheses12 min
- IN, BETWEEN and LIKE13 min
- NULL: missing values13 min
- ORDER BY: sorting12 min
- LIMIT, OFFSET and paging12 min
Functions and expressions
- String functions15 min
- Numeric functions14 min
- Date and time functions16 min
- CASE: conditions inside a query15 min
- CAST, COALESCE and NULLIF14 min
Summarising data
- COUNT, SUM, AVG, MIN and MAX15 min
- GROUP BY16 min
- HAVING: filtering groups13 min
- The order a query runs in14 min
Combining tables
- Relationships between tables14 min
- INNER JOIN16 min
- LEFT JOIN and RIGHT JOIN18 min
- FULL and CROSS joins15 min
- Self joins15 min
- Joining three or more tables17 min
- UNION, INTERSECT and EXCEPT15 min
Subqueries and CTEs
- Subqueries17 min
- Correlated subqueries16 min
- EXISTS and NOT EXISTS14 min
- Common table expressions (WITH)16 min
- Recursive CTEs17 min
Window functions
Changing data
- INSERT13 min
- UPDATE13 min
- DELETE and TRUNCATE12 min
- Transactions: COMMIT and ROLLBACK14 min
Designing databases
Practice
- Ten common SQL mistakes16 min
- Project: a company report25 min