Data and Databases

Choose and shape where data lives: indexes, transactions, replication and schema changes.

  1. 01

    SQL or NoSQL?

    • easy
  2. 02

    Add an Index

    • easy
    • Pro
  3. 03

    Transactions and ACID

    • medium
    • Pro
  4. 04

    Normalise or Denormalise?

    • medium
    • Pro
  5. 05

    Fix N Plus One Queries

    • medium
    • Pro
  6. 06

    Read Replicas and Lag

    • medium
    • Pro
  7. 07

    Change a Schema Without Downtime

    • hard
    • Pro
  8. 08

    Shard a Database

    • hard
    • Pro
  9. 09

    Consistency Trade-offs

    • hard
    • Pro