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
-
4m 22sIn this video, you will learn how to use the QUALIFY clause in Teradata SQL. FREE ACCESS
-
4m 27sIn this video, find out how to use the NORMALIZED option in a SELECT statement in Teradata. FREE ACCESS
-
4m 25sDuring this video, you will learn how to use the EXPAND ON clause in a Teradata SELECT statement. FREE ACCESS
-
5m 29sIn this video, you will use the INSERT statement to insert data into a Teradata database. FREE ACCESS
-
4m 20sLearn how to use the UPDATE statement to update data in Teradata. FREE ACCESS
-
3m 40sLearn how to use the DELETE statement to remove data from a Teradata database. FREE ACCESS
-
4m 55sIn this video, you will use MERGE to merge data into a table in Teradata. FREE ACCESS
-
6m 23sIn this video, you will learn how to optimize query design in Teradata. FREE ACCESS
-
3m 1sIn this video, you will learn how to improve the performance of merge joins in Teradata. FREE ACCESS
-
3m 30sAfter completing this video, you will be able to describe the basic temporal concepts in Teradata. FREE ACCESS
-
4m 27sIn this video, you will learn how to create temporal tables in Teradata. FREE ACCESS
-
5m 58sIn this video, you will learn how to load data into temporal tables in Teradata. FREE ACCESS
-
4m 48sIn this video, learn how to perform DDL operations using their temporal form in Teradata. FREE ACCESS
-
3m 26sIn this video, you will perform DML operations using their temporal form in Teradata. FREE ACCESS
-
8m 21sIn 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
Book
Job Ready SQL