• Online, Self-Paced

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

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration

Specialty Areas have been removed from the NICE Framework. With the recent release of the new NICE Framework data, updates to courses are underway. Until this course can be updated, this historical information is provided to give better context as to how it can help you with your cybersecurity goals.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.