Working with Data Conversions & SET Operations
Teradata 14
| Beginner
- 12 videos | 1h 2m 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 teradataIdentify when implicit data conversion is performed and what the supported data types areIdentify the syntax and rules for using cast to perform data conversions in teradataUse data type conversion functions to convert characters in teradata with castUse data type conversion to convert numbers, times, and intervals in teradata with castIdentify and use the data type conversion functions to convert data in teradata
-
Describe the set operators, their syntax, and order precedence for use in teradataUse the intersect set operator in teradataUse the minus and except set operators in teradataUse the union set operator in teradataUse set operators in derived tables, subqueries, and select…insert statements in teradataUse functions, expressions, and operations in teradata to work with data
IN THIS COURSE
-
5m 58sIn this video, learn how to identify the three ways data types can be converted in Teradata. FREE ACCESS
-
6m 23sDuring this video, you will learn how to identify when implicit data conversion is performed and what the supported data types are. FREE ACCESS
-
3m 52sDuring this video, you will learn how to identify the syntax and rules for using CAST to perform data conversions in Teradata. FREE ACCESS
-
6m 32sIn this video, you will learn how to use data type conversion functions to convert characters in Teradata with the CAST function. FREE ACCESS
-
7m 29sIn this video, learn how to use data type conversion to convert numbers, times, and intervals in Teradata with the CAST function. FREE ACCESS
-
5m 44sDuring this video, you will learn how to identify and use the data type conversion functions to convert data in Teradata. FREE ACCESS
-
4m 39sUpon 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. FREE ACCESS
-
4m 25sIn this video, learn how to use the INTERSECT set operator in Teradata. FREE ACCESS
-
3m 30sIn this video, learn how to use the MINUS and EXCEPT set operators in Teradata. FREE ACCESS
-
4m 41sIn this video, you will learn how to use the UNION set operator in Teradata. FREE ACCESS
-
4m 14sIn this video, you will use set operators in derived tables, subqueries, and SELECT...INSERT statements in Teradata. FREE ACCESS
-
5m 9sIn this video, you will use functions, expressions, and operations in Teradata to manipulate data. 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.