SQL Summary - Isolation

query.sql

…

Expected output

Lesson notes

Summary - Isolation

Pick the right level with SET TRANSACTION.

Summary - Isolation

Four isolation levels: READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, SERIALIZABLE.

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;

Summary isolation setting.

Exercise Summary - Isolation

Summary: set isolation level to READ COMMITTED.

Show example solution

SET TRANSACTION ISOLATION LEVEL READ COMMITTED;

Test yourself

Which level is safest?
- READ UNCOMMITTED
- SERIALIZABLE
- READ COMMITTED
- REPEATABLE READ
Show answer

SERIALIZABLE — SERIALIZABLE is the safest.
Summary - Isolation: match the terms

READ UNCOMMITTED

lowest
READ COMMITTED

mid
REPEATABLE READ

high
SERIALIZABLE

highest

Next lesson: What is a lock?