VEL ORENDISVel Orendis

Databases

PostgreSQL, indexing, transactions, concurrency.

6 lessonsquests, about 1.1 h. None is open yet: they open here as they are written. Take them in any order.

Introductory3 lessonsquests

  1. Tables, keys and modellingBeing written10 min
  2. Indexes and query plansBeing written12 min
  3. Transactions and the write-ahead logBeing written10 min

Intermediate1 lessonquest

  1. Replicas, pooling and partitioningBeing written12 min

Advanced2 lessonsquests

  1. MVCC and isolation anomaliesBeing written12 min
  2. Locks, contention and deadlocksBeing written10 min