Transactions & Isolation

Transactions & Isolation

The anomalies each level still lets through
Free
5h · 5 lessons
Overview

Relational modelling, indexes, transactions, the NoSQL families and what each one is actually for, then replication and sharding. More interviews are lost on the storage layer than on any other part of the diagram.

This module is 02.3 of the 6 in Data Storage & Retrieval. It runs about 5 hours across 5 lessons, and closes with Anomaly — Two transactions interleave. Name the anomaly and the lowest isolation level that would have prevented it.

Lessons
1. ACID, term by term

Concept · 30 minutes

2. The four isolation levels and their anomalies

Concept · 45 minutes

3. MVCC and how readers avoid writers

Concept · 40 minutes

4. Locks, deadlocks and lock ordering

Concept · 35 minutes

5. Distributed transactions, 2PC and sagas

Concept · 45 minutes

Module information
Duration
5 hours
Lessons
5
Level
Beginner
Track
Data Storage & Retrieval
Drill
Anomaly
Price
Free

Related modules

NoSQL & Choosing a Data Model
5 hours
6 lessons
Beginner
NoSQL & Choosing a Data Model
Free
02.4
Replication
5 hours
5 lessons
Beginner
Replication
Free
02.5
Partitioning & Sharding
5 hours
5 lessons
Beginner
Partitioning & Sharding
Free
02.6
Relational Modelling
5 hours
5 lessons
Beginner
Relational Modelling
Free
02.1