Working with DML, Optimization, & Temporal Concepts

Teradata 14    |    Beginner
  • 15 Videos | 1h 11m 32s
  • Earns a Badge
Likes 10 Likes 10
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
    FREE ACCESS
  • Locked
    4. 
    Using the INSERT Statement
    5m 29s
    FREE ACCESS
  • Locked
    5. 
    Using the UPDATE Statement
    4m 20s
    FREE ACCESS
  • Locked
    6. 
    Using the DELETE Statement
    3m 40s
    FREE ACCESS
  • Locked
    7. 
    Using MERGE
    4m 55s
    FREE ACCESS
  • Locked
    8. 
    Optimizing Query Design
    6m 23s
    FREE ACCESS
  • Locked
    9. 
    Improving Performance of Merge Joins
    3m 1s
    FREE ACCESS
  • Locked
    10. 
    Overview of Temporal Concepts
    3m 30s
    FREE ACCESS
  • Locked
    11. 
    Creating Temporal Tables
    4m 27s
    FREE ACCESS
  • Locked
    12. 
    Loading Data into Temporal Tables
    5m 58s
    FREE ACCESS
  • Locked
    13. 
    Performing DDL on Temporal Tables
    4m 48s
    FREE ACCESS
  • Locked
    14. 
    Performing DML on Temporal Tables
    3m 26s
    FREE ACCESS
  • Locked
    15. 
    Exercise: Performing DDL and DML in Teradata
    8m 21s
    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 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

COURSE MySQL Database Development: Manipulating Data
Likes 40 Likes 40  
BOOK Practitioner's Guide to Data Science: Streamlining Data Science Solutions using Python, Scikit-Learn, and Azure ML Service Platform
BOOK Refactoring Legacy T-SQL for Improved Performance: Modern Practices for SQL Server Applications