Working with Data Definition Language (DDL)

Teradata 14    |    Beginner
  • 12 videos | 1h 31m 11s
  • Earns a Badge
Rating 4.5 of 4 users Rating 4.5 of 4 users (4)
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

  • 9m 10s
    During this video, you will learn how to create and alter databases in Teradata. FREE ACCESS
  • 6m 2s
    In this video, you will create and manage database users for Teradata. FREE ACCESS
  • Locked
    3.  Creating Basic Tables
    5m 22s
    To create a table in Teradata, use the CREATE TABLE statement. FREE ACCESS
  • Locked
    4.  Creating Advanced Tables
    9m 27s
    In 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
  • Locked
    5.  Altering Tables
    5m 53s
    Learn how to alter, manage, and drop tables in Teradata. FREE ACCESS
  • Locked
    6.  Creating and Altering Indexes
    9m 54s
    In this video, you will learn how to create and alter indexes in Teradata. FREE ACCESS
  • Locked
    7.  Creating and Altering Views
    9m 38s
    In this video, you will learn how to create and modify views in Teradata. FREE ACCESS
  • Locked
    8.  Creating Recursive Views
    11m 4s
    In this video, learn how to create views that reference themselves (recursive views) in Teradata. FREE ACCESS
  • Locked
    9.  Creating Macros
    7m 50s
    To find out how to create macros in Teradata, consult Teradata documentation or support. FREE ACCESS
  • Locked
    10.  Creating Triggers
    6m 14s
    In this video, you will learn how to create triggers in Teradata. FREE ACCESS
  • Locked
    11.  Creating Procedures
    7m 4s
    In this video, you will create procedures in Teradata. FREE ACCESS
  • Locked
    12.  Altering Functions and Procedures
    3m 34s
    During 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.

YOU MIGHT ALSO LIKE

Course CompTIA Data+: Database Concepts
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
Course CompTIA Data+: Data Visualization Dashboards
Rating 4.8 of 6 users Rating 4.8 of 6 users (6)
Course CompTIA Data+: Data Visualization Reports
Rating 5.0 of 6 users Rating 5.0 of 6 users (6)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SQL Concepts & Queries
Rating 4.6 of 2013 users Rating 4.6 of 2013 users (2013)
Course Traditional Data Architectures: Relational Databases
Rating 4.0 of 72 users Rating 4.0 of 72 users (72)
Course Working with DML, Optimization, & Temporal Concepts
Rating 4.7 of 15 users Rating 4.7 of 15 users (15)