Transactions and Locking

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

  1. 01

    The Lost Update

    • easy
  2. 02

    Isolation Levels

    • medium
    • Pro
  3. 03

    Optimistic Locking

    • medium
    • Pro
  4. 04

    Lock Rows While You Work

    • medium
    • Pro
  5. 05

    Deadlocks

    • medium
    • Pro
  6. 06

    Long-Running Transactions

    • hard
    • Pro