Working with DML, Optimization, & Temporal Concepts

Teradata 14
  • 15 Videos | 1h 14m 32s
  • Earns a Badge
Likes 6 Likes 6
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

  • Playable
    1. 
    Using the QUALIFY Clause
    4m 22s
    UP NEXT
  • Playable
    2. 
    Using NORMALIZED
    4m 27s
  • Locked
    3. 
    Using the EXPAND ON Clause
    4m 25s
  • Locked
    4. 
    Using the INSERT Statement
    5m 29s
  • Locked
    5. 
    Using the UPDATE Statement
    4m 20s
  • Locked
    6. 
    Using the DELETE Statement
    3m 40s
  • Locked
    7. 
    Using MERGE
    4m 55s
  • Locked
    8. 
    Optimizing Query Design
    6m 23s
  • Locked
    9. 
    Improving Performance of Merge Joins
    3m 1s
  • Locked
    10. 
    Overview of Temporal Concepts
    3m 30s
  • Locked
    11. 
    Creating Temporal Tables
    4m 27s
  • Locked
    12. 
    Loading Data into Temporal Tables
    5m 58s
  • Locked
    13. 
    Performing DDL on Temporal Tables
    4m 48s
  • Locked
    14. 
    Performing DML on Temporal Tables
    3m 26s
  • Locked
    15. 
    Exercise: Performing DDL and DML in Teradata
    8m 21s

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.