• Online, Self-Paced
Course Description

Data Definition Language (DDL) statements are used to manipulate MySQL database schema objects. Examine the use of the CREATE, ALTER, and DROP statements to create, modify, and maintain MySQL databases, tables, and views.

Learning Objectives

MySQL Database Development: DDL Statements

  • describe the use of the CREATE, ALTER, and DROP DDL statements, and recognize their basic syntax
  • use the CREATE DATABASE DDL statement to create a new database with specific syntax and parameters
  • use the ALTER and DROP DDL statements to change and drop an existing database
  • use the CREATE TABLE DDL statement to create new tables and define their properties
  • use the ALTER and DROP DDL statements to change and drop an existing table
  • use the CREATE and ALTER VIEW DDL statements to create and alter views in MySQL databases
  • use views to retrieve records from tables and other views
  • create nested views
  • create advanced views using join statements and use aggregate functions
  • use DDL statements to work with database objects and views

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.