Course details

MySQL Database Development: DDL Statements

MySQL Database Development: DDL Statements


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/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.



Expected Duration (hours)
0.9

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

    Expertise Level
    Beginner