You can find out here of “Introduction into Relational Databases” course.
Themes are below.
- Database Failure
- UNDO / REDO lists for Recovery
- ARIES Algorithm
- 2-Phase commit
- Isolation Levels
- Database Locks (Intent Locks, DeadLocks)
- MVCC and 2PL
- Precedence Graph
Please if you have some comments / questions or remarks , just let me know about it.