# Working with Data Conversions & SET Operations

• 12 videos | 1h 2m 37s
Rating 4.8 of 8 users (8)
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

• In this video, learn how to identify the three ways data types can be converted in Teradata.
• During this video, you will learn how to identify when implicit data conversion is performed and what the supported data types are.
• 3.  Overview of Using CAST
During this video, you will learn how to identify the syntax and rules for using CAST to perform data conversions in Teradata.
• 4.  Using Data Type Conversion Functions (Part 1)
In this video, you will learn how to use data type conversion functions to convert characters in Teradata with the CAST function.
• 5.  Using Data Type Conversion Functions (Part 2)
In this video, learn how to use data type conversion to convert numbers, times, and intervals in Teradata with the CAST function.
• 6.  Using Data Type Conversion Functions
During this video, you will learn how to identify and use the data type conversion functions to convert data in Teradata.
• 7.  Overview of Using Set Operators
Upon completion of this video, you will be able to describe the set operators, their syntax, and the order of precedence for using them in Teradata.
• 8.  Using INTERSECT
In this video, learn how to use the INTERSECT set operator in Teradata.
• 9.  Using MINUS and EXCEPT
In this video, learn how to use the MINUS and EXCEPT set operators in Teradata.
• 10.  Using Union
In this video, you will learn how to use the UNION set operator in Teradata.
• 11.  Using Set Operators in Advanced Queries
In this video, you will use set operators in derived tables, subqueries, and SELECT...INSERT statements in Teradata.
• 12.  Exercise: Using Teradata Functions
In this video, you will use functions, expressions, and operations in Teradata to manipulate data.

## 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

Rating 2.0 of 1 users (1)
Rating 4.6 of 15 users (15)

## PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.3 of 15 users (15)
Rating 4.5 of 4 users (4)
Rating 5.0 of 1 users (1)