Course Description

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

## Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.