Hour 10
Manipulating Data
What You’ll Learn in This Hour:
▶ Getting an overview of DML
▶ Manipulating data in tables
▶ Understanding table population of data
▶ Deleting data from tables
▶ Changing or modifying data in tables
▶ Applying DML to the BIRDS database
In this hour, you learn how to use the piece of SQL known as Data Manipulation Language (DML) to change data and tables in a relational database.
Getting an Overview of Data Manipulation
DML is the part of SQL that enables a database user to actually propagate changes among data in a relational database. With DML, the user can populate tables with new data, update existing data in tables, and delete data from tables. Simple database queries can also be performed within ...
Get SQL in 24 Hours, Sams Teach Yourself, 7th 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.
