Chapter 5. Manipulating Data

In this hour, you learn the part of SQL known as Data Manipulation Language (DML). DML is the part of SQL that is used to make changes to data and tables in a relational database.

This hour’s highlights include:

  • An overview of data manipulation language

  • Instruction on how to manipulate data in tables

  • Concepts behind table population of data

  • How to delete data from tables

  • How to change or modify data in tables

Overview of Data Manipulation

DML is the part of SQL that allows 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 a DML ...

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.