Chapter 6. Managing Database Transactions

Managing Database Transactions

In this hour, you learn the concepts behind the management of database transactions.

The highlights of this hour include:

  • The definition of a transaction

  • The commands used to control transactions

  • The syntax and examples of transaction commands

  • When to use transactional commands

  • The consequences of poor transactional control

What Is a Transaction?

A transaction is a unit of work that is performed against a database. Transactions are units or sequences of work accomplished in a logical order, whether in a manual fashion by a user or automatically by some sort of a database program. In a relational database using SQL, ...

Get Sams Teach Yourself SQL now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.