The Most Addictive Python and SQL Courses
Learn AI, Data Science & Business — Earn Certificates That Get You Hired
Overview
Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This presentation explains how transaction isolation levels and database concurrency designs affect data anomalies, with examples from Oracle, SQL Server, PostgreSQL, and MySQL. It also presents application-level optimistic and pessimistic locking patterns for multi-request web flows.
Syllabus
Intro
History
Atomicity
Consistency
Durability
Isolation
Conflicts
Locking
Two Phase Locking
MVCC
MVCCC
Delete
Update
Two types of isolation
Isolation leverage
Phantom rate
Reads Q
Lexical Standards
Reality
Version column
Multiple columns
Splitting tables
Updating tables
Hibernate
Taught by
Devoxx