Working with DML, Optimization, & Temporal Concepts

Teradata 14    |    Beginner
  • 15 videos | 1h 11m 32s
  • Earns a Badge
Rating 4.7 of 15 users Rating 4.7 of 15 users (15)
Teradata supports the use of SQLs data manipulation language (DML) to retrieve, insert, update, and delete data in a database. Explore DDL and DML operations in a database or temporal tables.

WHAT YOU WILL LEARN

  • Use the qualify clause in teradata
    Use normalized in a select statement in teradata
    Use the expand on clause in a select statement in teradata
    Use the insert statement to insert data into teradata
    Use the update statement to update data in teradata
    Use the delete statement to remove data from teradata
    Use merge to merge data into a table in teradata
    Identify how to optimize query design in teradata
  • Identify how to improve the performance of merge joins in teradata
    Describe the basic temporal concepts in teradata
    Create temporal tables in teradata
    Load data into temporal tables in teradata
    Perform ddl operations using their temporal form in teradata
    Perform dml operations using their temporal form in teradata
    Perform ddl and dml operations on regular and temporal tables in teradata

IN THIS COURSE

  • 4m 22s
    In this video, you will learn how to use the QUALIFY clause in Teradata SQL. FREE ACCESS
  • 4m 27s
    In this video, find out how to use the NORMALIZED option in a SELECT statement in Teradata. FREE ACCESS
  • Locked
    3.  Using the EXPAND ON Clause
    4m 25s
    During this video, you will learn how to use the EXPAND ON clause in a Teradata SELECT statement. FREE ACCESS
  • Locked
    4.  Using the INSERT Statement
    5m 29s
    In this video, you will use the INSERT statement to insert data into a Teradata database. FREE ACCESS
  • Locked
    5.  Using the UPDATE Statement
    4m 20s
    Learn how to use the UPDATE statement to update data in Teradata. FREE ACCESS
  • Locked
    6.  Using the DELETE Statement
    3m 40s
    Learn how to use the DELETE statement to remove data from a Teradata database. FREE ACCESS
  • Locked
    7.  Using MERGE
    4m 55s
    In this video, you will use MERGE to merge data into a table in Teradata. FREE ACCESS
  • Locked
    8.  Optimizing Query Design
    6m 23s
    In this video, you will learn how to optimize query design in Teradata. FREE ACCESS
  • Locked
    9.  Improving Performance of Merge Joins
    3m 1s
    In this video, you will learn how to improve the performance of merge joins in Teradata. FREE ACCESS
  • Locked
    10.  Overview of Temporal Concepts
    3m 30s
    After completing this video, you will be able to describe the basic temporal concepts in Teradata. FREE ACCESS
  • Locked
    11.  Creating Temporal Tables
    4m 27s
    In this video, you will learn how to create temporal tables in Teradata. FREE ACCESS
  • Locked
    12.  Loading Data into Temporal Tables
    5m 58s
    In this video, you will learn how to load data into temporal tables in Teradata. FREE ACCESS
  • Locked
    13.  Performing DDL on Temporal Tables
    4m 48s
    In this video, learn how to perform DDL operations using their temporal form in Teradata. FREE ACCESS
  • Locked
    14.  Performing DML on Temporal Tables
    3m 26s
    In this video, you will perform DML operations using their temporal form in Teradata. FREE ACCESS
  • Locked
    15.  Exercise: Performing DDL and DML in Teradata
    8m 21s
    In this video, you will perform DDL and DML operations on regular and temporal tables 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 Database Fundamentals: Database Administration Basics
Rating 4.5 of 141 users Rating 4.5 of 141 users (141)
Course CompTIA Data+: Understanding Data
Rating 4.8 of 12 users Rating 4.8 of 12 users (12)
Book Getting Started with SQL and Databases: Managing and Manipulating Data with SQL

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Primary & Partitioned Indexes
Rating 4.7 of 12 users Rating 4.7 of 12 users (12)
Course Oracle Database 12c R2 SQL: Using Basic SELECT statements
Rating 4.7 of 88 users Rating 4.7 of 88 users (88)
Course Working with Data Definition Language (DDL)
Rating 4.5 of 4 users Rating 4.5 of 4 users (4)