CSE Roadmap

Core tier · about 2 hours · 4 parts

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.