Working with Data Definition Language (DDL)

Teradata 14
  • 12 Videos | 1h 33m 11s
  • Earns a Badge
Likes 7 Likes 7
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 Teradata
    create and manage database users for Teradata
    create a table in Teradata using the CREATE TABLE statement
    create a table in Teradata using the CREATE TABLE statement which includes defining an index, column definitions, and table options
    alter, manage, and drop tables in Teradata
    create and alter indexes in Teradata
  • create and alter views in Teradata
    create recursive views in Teradata
    create macros in Teradata
    create triggers in Teradata
    create procedures in Teradata
    alter, rename, and drop functions and stored procedures in Teradata

IN THIS COURSE

  • Playable
    1. 
    Creating and Altering Databases
    9m 10s
    UP NEXT
  • Playable
    2. 
    Creating and Managing Database Users
    6m 2s
  • Locked
    3. 
    Creating Basic Tables
    5m 22s
  • Locked
    4. 
    Creating Advanced Tables
    9m 27s
  • Locked
    5. 
    Altering Tables
    5m 53s
  • Locked
    6. 
    Creating and Altering Indexes
    9m 54s
  • Locked
    7. 
    Creating and Altering Views
    9m 38s
  • Locked
    8. 
    Creating Recursive Views
    11m 4s
  • Locked
    9. 
    Creating Macros
    7m 50s
  • Locked
    10. 
    Creating Triggers
    6m 14s
  • Locked
    11. 
    Creating Procedures
    7m 4s
  • Locked
    12. 
    Altering Functions and Procedures
    3m 34s

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 0 Likes 0  
Likes 1 Likes 1  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 3 Likes 3  
Likes 212 Likes 212  
Likes 19 Likes 19