Working with Data Definition Language (DDL)
Teradata 14
| Beginner
- 12 videos | 1h 31m 11s
- Earns a Badge
Teradata supports the use of SQLs data definition language (DDL) to create, modify, and remove objects in a database. Work with DDL to create and alter databases, tables, indexes, triggers, and more.
WHAT YOU WILL LEARN
-
Create and alter a database in teradataCreate and manage database users for teradataCreate a table in teradata using the create table statementCreate a table in teradata using the create table statement which includes defining an index, column definitions, and table optionsAlter, manage, and drop tables in teradataCreate and alter indexes in teradata
-
Create and alter views in teradataCreate recursive views in teradataCreate macros in teradataCreate triggers in teradataCreate procedures in teradataAlter, rename, and drop functions and stored procedures in teradata
IN THIS COURSE
-
9m 10sDuring this video, you will learn how to create and alter databases in Teradata. FREE ACCESS
-
6m 2sIn this video, you will create and manage database users for Teradata. FREE ACCESS
-
5m 22sTo create a table in Teradata, use the CREATE TABLE statement. FREE ACCESS
-
9m 27sIn this video, learn how to create a table in Teradata using the CREATE TABLE statement. This includes defining an index, column definitions, and table options. FREE ACCESS
-
5m 53sLearn how to alter, manage, and drop tables in Teradata. FREE ACCESS
-
9m 54sIn this video, you will learn how to create and alter indexes in Teradata. FREE ACCESS
-
9m 38sIn this video, you will learn how to create and modify views in Teradata. FREE ACCESS
-
11m 4sIn this video, learn how to create views that reference themselves (recursive views) in Teradata. FREE ACCESS
-
7m 50sTo find out how to create macros in Teradata, consult Teradata documentation or support. FREE ACCESS
-
6m 14sIn this video, you will learn how to create triggers in Teradata. FREE ACCESS
-
7m 4sIn this video, you will create procedures in Teradata. FREE ACCESS
-
3m 34sDuring this video, you will learn how to alter, rename, and drop functions and stored procedures in Teradata. 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.