SQL

5    Data Manipulation Language

With database objects in place, the next logical step is to put data into tables and learn to modify data when needed. In this chapter, you’ll learn to insert, update, and delete data. (These are the second most common set of database operations—data querying being the first). You’ll also see some automation options with triggers, which are set up to execute upon data insertion, modification, or deletion in a table and are used to automatically alter data in related tables. Stored procedures are similar mechanisms, but they aren’t executed automatically—they need to be called manually.

So far, we’ve learned about SQL statements for data definition language (DDL), which we use to create database structures to hold ...