Databases

Talk through SQL queries, joins, indexes, transactions and schema design, hands-on.

  1. 7 challenges

    SQL Basics

    Read and explain everyday SQL queries: filtering, sorting, grouping and handling missing values.

  2. 6 challenges

    Joins

    Combine tables correctly: inner and outer joins, many-to-many links and spotting duplicated rows.

  3. 7 challenges

    Indexes and Performance

    How indexes work inside, how to read a query plan, and why a query is slow.

  4. 6 challenges

    Transactions and Locking

    What goes wrong when users change the same data at once, and how isolation and locks prevent it.

  5. 7 challenges

    Schema Design

    Keys, constraints, data types and normal forms, plus changing a schema safely with migrations.

  6. 6 challenges

    NoSQL

    Key-value, document, wide-column, graph and search stores: how they model data and when they fit.