DDL - Data Definition Language
Автор: Clint Tuttle
Загружено: 2021-01-05
Просмотров: 2904
In this video we introduce you to DDL which is one of three functional syntaxes used in SQL; DML and DCL being the other two. This also shows you how to use the DDL Matrix as a guide to the Murach textbook reading on DDL and then is followed with a step-by-step walk-through of the DDL examples in the book.
00:00 - 02:03 - Introduction to SQL's three functional syntaxes (e.g. DDL, DML, DCL)
02:03 - 04:15 - How to utilize the DDL Matrix to reference book's syntax examples
04:15 - 08:46 - Creating and dropping basic tables
08:46 - 09:32 - Common error when writing SQL and how to spot them
09:32 - 13:02 - Creating primary keys
13:02 - 16:00 - Creating foreign keys
16:00 - 18:24 - Using a CHECK constraint
18:24 - 22:00 - How to ALTER columns of a table
22:00 - 24:20 - How to ALTER constraints of a table
24:20 - end - How to RENAME, TRUNCATE, and DROP a table
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
