Course Details

Previous Page


Teradata SQL: Functions, Data Conversions, and Working with Time


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/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.

Target Audience
Individuals looking to learn SQL basics to query Teradata databases

Prerequisites
None

Expected Duration (hours)
2.5

Lesson Objectives

Teradata SQL: Functions, Data Conversions, and Working with Time

  • 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
  • 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
  • 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
  • Course Number:
    df_tesq_a02_it_enus