Hi there!
You can find out here of “Introduction into Relational Databases” course with theme “Database Transactions and Locking mechanisms”.
Themes are below.
- User sessions
- User transactions
- ACID
- Checkpoint
- Database journal (log files)
- UNDO / REDO lists
- Algorithm ARIES
- 2-Phase commit
- Autocommit
- SAVEPOINT
- Oracle autonomous transaction
- PostgreSQL prepared transaction
- MySQL XA transaction
- Lost Update Anomaly
- Dirty Reads Anomaly
- Non-Repeatable Reads Anomaly
- Phantom Reads Anomaly
- Read Skew Anomaly
- Write Skew Anomaly
- Serialization Anomaly
- Isolation levels. Serializable / Repeatable Read / Read Committed / Read Uncommitted
- Data Visibility in Isolation Level
- 2PL protocol
- MVCC
- Exclusive / Shared locks
- Precedence Graph
- Intent Locks
- Table Explicit Lock
- Database Deadlock
Please if you have some comments / questions or remarks , just let me know about it.
Thanks!