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
use DDL statements to work with database objects and views
Course Number: it_dfmydd_03_enus
Expertise Level
Beginner