MySQL Database Development: DDL Statements
MySQL 8.0
| Beginner
- 10 Videos | 52m 6s
- Includes Assessment
- Earns a Badge
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 syntaxuse the CREATE DATABASE DDL statement to create a new database with specific syntax and parametersuse the ALTER and DROP DDL statements to change and drop an existing databaseuse the CREATE TABLE DDL statement to create new tables and define their propertiesuse 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 databasesuse views to retrieve records from tables and other viewscreate nested viewscreate advanced views using join statements and use aggregate functionsuse DDL statements to work with database objects and views
IN THIS COURSE
-
1.Data Definition Language (DDL) Statements2m 54sUP NEXT
-
2.Creating MySQL Databases4m 45s
-
3.Altering and Dropping MySQL Databases3m 36s
-
4.Creating MySQL Tables6m 3s
-
5.Altering and Dropping MySQL Tables3m 49s
-
6.Creating and Altering Views6m 12s
-
7.Querying Views5m 25s
-
8.Nested Views4m 42s
-
9.Advanced Views9m 13s
-
10.Exercise: Using DDL Statements and Views in MySQL5m 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

BOOK
PHP 8 Solutions