MySQL Database Development: DDL Statements

MySQL 8.0    |    Beginner
  • 10 videos | 52m 6s
  • Includes Assessment
  • Earns a Badge
Likes 48 Likes 48
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

  • 2m 54s
    Upon completion of this video, you will be able to describe the use of the CREATE, ALTER, and DROP DDL statements, and recognize their basic syntax. FREE ACCESS
  • 4m 45s
    In this video, you will learn how to use the CREATE DATABASE DDL statement to create a new database with specific syntax and parameters. FREE ACCESS
  • Locked
    3.  Altering and Dropping MySQL Databases
    3m 36s
    During this video, you will learn how to use the ALTER and DROP DDL statements to change and drop an existing database. FREE ACCESS
  • Locked
    4.  Creating MySQL Tables
    6m 3s
    In this video, you will learn how to use the CREATE TABLE DDL statement to create new tables and define their properties. FREE ACCESS
  • Locked
    5.  Altering and Dropping MySQL Tables
    3m 49s
    Learn how to use the ALTER and DROP DDL statements to change and delete an existing table. FREE ACCESS
  • Locked
    6.  Creating and Altering Views
    6m 12s
    In this video, you will learn how to use the CREATE and ALTER VIEW DDL statements to create and alter views in MySQL databases. FREE ACCESS
  • Locked
    7.  Querying Views
    5m 25s
    During this video, you will learn how to use views to retrieve records from tables and other views. FREE ACCESS
  • Locked
    8.  Nested Views
    4m 42s
    In this video, you will create views within views. FREE ACCESS
  • Locked
    9.  Advanced Views
    9m 13s
    In this video, you will learn how to create advanced views using join statements and aggregate functions. FREE ACCESS
  • Locked
    10.  Exercise: Using DDL Statements and Views in MySQL
    5m 27s
    In this video, you will learn how to use DDL statements to work with database objects and views. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course MySQL Database Development: Introduction
Likes 109 Likes 109  
Channel SQL Database Development & Design
Likes 349 Likes 349  
Channel PostgreSQL
Likes 77 Likes 77  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course MySQL: Understanding & Implementing Joins
Likes 57 Likes 57  
Course MySQL Database Development: SELECT Statement & Operators
Likes 37 Likes 37  
Course Normalization Concepts & Forms
Likes 186 Likes 186