Databases
Talk through SQL queries, joins, indexes, transactions and schema design, hands-on.
- 7 challenges
SQL Basics
Read and explain everyday SQL queries: filtering, sorting, grouping and handling missing values.
- 6 challenges
Joins
Combine tables correctly: inner and outer joins, many-to-many links and spotting duplicated rows.
- 7 challenges
Indexes and Performance
How indexes work inside, how to read a query plan, and why a query is slow.
- 6 challenges
Transactions and Locking
What goes wrong when users change the same data at once, and how isolation and locks prevent it.
- 7 challenges
Schema Design
Keys, constraints, data types and normal forms, plus changing a schema safely with migrations.
- 6 challenges
NoSQL
Key-value, document, wide-column, graph and search stores: how they model data and when they fit.