Hour 5. Manipulating Data
What You’ll Learn in This Hour:
• An overview of DML
• 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
In this hour, you learn the part of SQL known as Data Manipulation Language (DML). DML is the part of SQL that you use to change data and tables in a relational database.
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 a DML command. ...
Get Sams Teach Yourself SQL in 24 Hours, Fifth 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.
