Teradata supports the use of functions, expressions, and operators to perform operations on data. It generally takes an argument or expression and performs an action for an output. This course will demonstrate the different types of functions used in Teradata, including attribute, string, and analytical functions. It will also demonstrate how to perform data conversions and computations, use SET operations, and work with times, dates, timestamps, and intervals.
Learning Objectives
Functions
- start the course
- identify the different types of functions in Teradata and how expressions and SQL operators are used
- use arithmetic functions and operators on data in Teradata
- use attribute functions to return descriptive information about their operand in Teradata
- use string functions to perform operations on strings of data in Teradata
- use regular expression functions on data in Teradata
- use the analytical functions in Teradata
- use CASE expressions to evaluate a set of expressions in Teradata
Times, Dates, and Intervals
- use calendar functions to work with dates, months, and years in Teradata
- use ANSI DateTime expressions to do computations with Time Zones and interval values in Teradata
- use ANSI Interval expressions to perform calculations on Interval values in Teradata
- use arithmetic operators, ANSI DateTime, and Interval Data Types in Teradata
- use scalar operations with DateTime functions to work with dates and times in Teradata
- use the different DateTime and Interval functions, ADD_MONTHS, OADD_MONTHS, AND MONTHS_BETWEEN in Teradata
- use the different DateTime and Interval functions, LAST_DAY, NEXT_DAY, TRUNC, ROUND, EXTRACT in Teradata
Data Conversions and Computations
- 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
SET Operations
- 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
Practice: Using Functions and Operators
- use functions, expressions, and operations in Teradata to work with data