MySQL Database Development: Manipulating Data Overview/Description Expected Duration Lesson Objectives Course Number Expertise Level Overview/Description 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.
Expected Duration (hours)
0.9
Lesson 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
Course Number: it_dfmydd_04_enus
Expertise Level
Beginner