Working with Data Conversions & SET Operations
Teradata 14
12 Videos | 1h 5m 37s - Earns a Badge
You can use functions, expressions, and operators to perform operations on data in Teradata. Learn how to perform data conversions and computations, and use SET operators.
WHAT YOU WILL LEARN
-
identify the three ways data types are converted in Teradata
identify when implicit data conversion is performed and what the supported data types are
identify the syntax and rules for using CAST to perform data conversions in Teradata
use data type conversion functions to convert characters in Teradata with CAST
use data type conversion to convert numbers, times, and intervals in Teradata with CAST
identify and use the data type conversion functions to convert data in Teradata -
describe the set operators, their syntax, and order precedence for use in Teradata
use the INTERSECT set operator in Teradata
use the MINUS and EXCEPT set operators in Teradata
use the UNION set operator in Teradata
use set operators in derived tables, subqueries, and SELECT…INSERT statements in Teradata
use functions, expressions, and operations in Teradata to work with data
IN THIS COURSE
-
1.Overview of Data Type Conversions5m 58sUP NEXT
-
2.Understanding Implicit Type Conversions6m 23s
-
3.Overview of Using CAST3m 52s
-
4.Using Data Type Conversion Functions (Part 1)6m 32s
-
5.Using Data Type Conversion Functions (Part 2)7m 29s
-
6.Using Data Type Conversion Functions5m 44s
-
7.Overview of Using Set Operators4m 39s
-
8.Using INTERSECT4m 25s
-
9.Using MINUS and EXCEPT3m 30s
-
10.Using Union4m 41s
-
11.Using Set Operators in Advanced Queries4m 14s
-
12.Exercise: Using Teradata Functions5m 9s
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.
