MySQL Database Development: Manipulating Data from Skillsoft

Online, Self-Paced

Data Manipulation Language (DML) statements are used to manipulate the actual data in MySQL databases. Explore the syntax and use of the most common DML statements, including INSERT, UPDATE, and DELETE.

Learning Objectives

MySQL Database Development: Manipulating Data

describe the use of the INSERT, UPDATE, and DELETE DML statements, and recognize their basic syntax
work with the INSERT statement to add new data to your MySQL tables
work with the UPDATE statement to modify existing data in your MySQL tables
work with the DELETE statement to remove existing data from your MySQL tables
use additional INSERT options to add new data to your MySQL tables
use additional UPDATE options to modify existing data in your MySQL tables
use MySQL Workbench to insert and delete data in your tables
use MySQL Workbench to view and modify existing data in your tables
use MySQL Workbench to retrieve data from your tables using filters
use MySQL Workbench to export existing data in your tables to an external file
use MySQL Workbench to import existing data into your tables
manipulate data using the DML statements and MySQL Workbench