• Online, Self-Paced
Course 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.

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

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.