Teradata SQL: Functions, Data Conversions, and Working with Time
Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level
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

Expertise Level
Beginner