DDL Statements

MySQL 8.0    |    Beginner
  • 10 Videos | 56m 36s
  • Includes Assessment
  • Earns a Badge
Likes 27 Likes 27
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Data Definition Language (DDL) Statements
    2m 54s
    UP NEXT
  • Playable
    2. 
    Creating MySQL Databases
    4m 45s
  • Locked
    3. 
    Altering and Dropping MySQL Databases
    3m 36s
  • Locked
    4. 
    Creating MySQL Tables
    6m 3s
  • Locked
    5. 
    Altering and Dropping MySQL Tables
    3m 49s
  • Locked
    6. 
    Creating and Altering Views
    6m 12s
  • Locked
    7. 
    Querying Views
    5m 25s
  • Locked
    8. 
    Nested Views
    4m 42s
  • Locked
    9. 
    Advanced Views
    9m 13s
  • Locked
    10. 
    Exercise: Using DDL Statements and Views in MySQL
    5m 27s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 24 Likes 24  
Likes 24 Likes 24  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 32 Likes 32  
Likes 498 Likes 498