Dive into the techniques DBMSs use to manage simultaneous access, including locks, deadlock handling, timestamp ordering, and optimistic concurrency control.
Learn how shared and exclusive locks are used to control access to data.
Understand what deadlocks are and how they are detected and handled.
Learn about the timestamp ordering protocol as an alternative to locking.
Understand the 'validate-then-commit' approach of optimistic concurrency.
A brief look at MVCC, where different versions of data are maintained.