Chapter 6. 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 in 24 Hours, Fourth Edition 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.