Working with DML, Optimization, & Temporal Concepts
Teradata 14
| Beginner
- 15 videos | 1h 11m 32s
- Earns a Badge
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 Teradatause NORMALIZED in a SELECT statement in Teradatause the EXPAND ON clause in a SELECT statement in Teradatause the INSERT statement to insert data into Teradatause the UPDATE statement to update data in Teradatause the DELETE statement to remove data from Teradatause MERGE to merge data into a table in Teradataidentify how to optimize query design in Teradata
-
identify how to improve the performance of merge joins in Teradatadescribe the basic temporal concepts in Teradatacreate temporal tables in Teradataload data into temporal tables in Teradataperform DDL operations using their temporal form in Teradataperform DML operations using their temporal form in Teradataperform DDL and DML operations on regular and temporal tables in Teradata
IN THIS COURSE
-
1.Using the QUALIFY Clause4m 22sUP NEXT
-
2.Using NORMALIZED4m 27s
-
3.Using the EXPAND ON Clause4m 25s
-
4.Using the INSERT Statement5m 29s
-
5.Using the UPDATE Statement4m 20s
-
6.Using the DELETE Statement3m 40s
-
7.Using MERGE4m 55s
-
8.Optimizing Query Design6m 23s
-
9.Improving Performance of Merge Joins3m 1s
-
10.Overview of Temporal Concepts3m 30s
-
11.Creating Temporal Tables4m 27s
-
12.Loading Data into Temporal Tables5m 58s
-
13.Performing DDL on Temporal Tables4m 48s
-
14.Performing DML on Temporal Tables3m 26s
-
15.Exercise: Performing DDL and DML in Teradata8m 21s
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.