| Book Exercise Lanes | exercise | 4 | Open |
| Constraints: NOT NULL, UNIQUE, CHECK, FOREIGN KEY, Cascading | concept | 1 | Open |
| Denormalization: When and Why | concept | 2 | Open |
| ER Modeling and Translation to Tables | concept | 2 | Open |
| Functional Dependencies and Normal Forms: 1NF, 2NF, 3NF, BCNF | concept | 1 | Open |
| JOINs and Set Operations: Inner, Outer, Semi, Anti | concept | 1 | Open |
| Keys: Primary, Candidate, Foreign, Surrogate vs Natural | concept | 1 | Open |
| Learning Resources | resource | 4 | Open |
Reading an EXPLAIN / EXPLAIN ANALYZE Plan | concept | 2 | Open |
| Reference and Selective Reading | reference | 5 | Open |
| Relational Algebra: Selection, Projection, Join, Union | concept | 1 | Open |
| Relations, Tuples, Attributes, Domains | concept | 2 | Open |
| Schema Migrations: Adding/Removing Columns, Online Migrations | concept | 2 | Open |
| Subqueries, CTEs, and Window Functions | concept | 1 | Open |
| The Cost of a Bad Query: Scan vs Seek, N+1 Queries | concept | 1 | Open |
| The SQL Logical Pipeline: SELECT/FROM/WHERE/GROUP BY/HAVING/ORDER BY | concept | 1 | Open |
Transactions at the SQL Level: BEGIN, COMMIT, ROLLBACK, Isolation Preview | concept | 2 | Open |
| Views, Materialized Views, and Stored Procedures | concept | 1 | Open |