A transaction is a logical unit of work performed on a database. Transactions are logically ordered units or sequences of work that can be completed manually by a human or automatically by a database application. The propagation of ONE or more changes to the database is referred to as a transaction. For instance, whether you create, update, or delete a record from a table, you are completing a transaction on that table. To preserve data integrity and address database issues, it's critical to keep track of these transactions. In practice, you will group several SQL queries TOGETHER and run them all at the same time as part of a transaction. Transactions n SQL contain the four standard qualities listed below, which are frequently abbreviated as ACID.

• Atomicity: Atomicity ensures the successful completion of all processes INSIDE the work unit. Otherwise, the transaction will be aborted at the point of FAILURE, and all preceding activities would be reversed.
• Consistency: When a transaction is successfully committed, consistency ensures that the database changes states properly.
• Isolation: Isolation allows transactions to execute independently of one another while remaining TRANSPARENT to them.
• Durability: Durability ensures that a committed transaction's outcome or effect is preserved in the event of a system failure.