Chapter 9: CRUD, Transactions, and Locking
In this chapter, we'll cover a must-know mix of fundamental notions about CRUD operations, transactions, and locking. These three topics are heavily exploited in almost any database application. In a common scenario, an application has a significant number of CRUD operations that are executed in explicitly demarcated logical transactions and, in certain cases, they also need to explicitly control the concurrent access to data to prevent race conditions, lost updates, and other SQL phenomena (or SQL anomalies).
In this chapter, we will cover the following topics:
- CRUD
- Navigating (updatable) records
- Transactions
- Locking
Let's get started!
