Course details

MySQL Database Development: Manipulating Data

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
  • Course Number:
    it_dfmydd_04_enus

    Expertise Level
    Beginner