Part 1 of 4 · 1 min read
Why this page comes first
In this module you will
- Name the four ACID properties and what each one guarantees, in one sentence each.
- Explain why a bank transfer needs more than one SQL statement to behave correctly.
- Recognize an operation that would break atomicity if it stopped halfway.
- Point to where ACID will be covered in full depth later in this subject.
ACID gets mentioned constantly from here on, often as a single word standing in for four separate guarantees. This page gives a working definition of each one now, using a single clear example, so it can be used by name without re-explaining it every time. Level 7 returns to ACID in full depth, with the actual mechanisms that provide each guarantee.