O'Reilly logo

Sams Teach Yourself SQL by Arie D. Jones, Ron Plew, Ryan Stephens

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required