Introduction to Data Manipulation
Explore how to use PostgreSQL's data manipulation language to perform CRUD operations while ensuring data integrity and concurrency control. Understand key concepts like ACID guarantees and batch processing to manage database records effectively.
We'll cover the following...
There are many different ways to fetch exactly the data you’re interested in from the database server. This data that we’ve been querying using SQL must get there, and that’s the role of the DML parts of the standard.
Maintaining the data
The most important aspects of DML language for maintaining data are its concurrency properties with the ACID guarantees and its capability to process batches of rows at a time.
The CRUD capabilities are essential to any application: CREATE, READ, UPDATE, and DELETE one entry at a time are at the foundation of our applications, or at least their admin panels.