Transactions, concurrency, and isolation levels are some of the most interesting parts of database systems.
Dirty reads/writes, read skew, write skew, lost updates, and phantom reads each reveal different trade-offs in concurrency control.
Reference table