ACID Properties
Published Jun 9, 2022
Contribute to Docs
ACID properties refer to properties a database transaction must follow in order to maintain consistency in a database. Those properties are as follows:
- Atomicity: The entire transaction must occur, or none of it does. There are no partial transactions.
- Consistency: The database must remain consistent before and after the transaction.
- Isolation: Transactions are independent of one another, and do not interfere with each other.
- Durability: A transaction, once completed, is permanent and persists even if a system failure occurs.
Contribute to Docs
- Learn more about how to get involved.
- Edit this page on GitHub to fix an error or make an improvement.
- Submit feedback to let us know how we can improve Docs.
Learn more on Codecademy
- Skill path
Analyze Data with SQL
Learn to analyze data with SQL and prepare for technical interviews.Includes 9 CoursesWith CertificateBeginner Friendly17 hours - Career path
Data Scientist: Machine Learning Specialist
Machine Learning Data Scientists solve problems at scale, make predictions, find patterns, and more! They use Python, SQL, and algorithms.Includes 27 CoursesWith Professional CertificationBeginner Friendly90 hours