Hands-on database engineering study focused on ACID transactions, concurrency control, isolation levels, locking, deadlocks, MVCC, query optimization, and production-grade transaction design using MySQL InnoDB.
consistency mvcc rollback commit acid atomicity lost-update payment-transactions bank-transfer isolation-level concurrent-transactions inventory-transactions deadlock-prevention row-locking production-transaction transaction-retry phantom-read non-repeatable-read basic-transaction dirty-read
-
Updated
Nov 7, 2026