Working with Functions, Times, Dates, & Intervals

Teradata 14    |    Beginner
  • 14 videos | 1h 31m 52s
  • Earns a Badge
Rating 4.4 of 34 users Rating 4.4 of 34 users (34)
Teradata supports the use of functions, expressions, and operators to perform operations on data. Explore attribute, string, and analytical functions, as well as times, dates, and intervals in Teradata.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • 9m 47s
    In this video, you will identify the different types of functions in Teradata and how expressions and SQL operators are used. FREE ACCESS
  • 7m 15s
    During this video, you will learn how to use arithmetic functions and operators on data in Teradata. FREE ACCESS
  • Locked
    3.  Using Attribute Functions
    5m 50s
    In this video, find out how to use attribute functions to return descriptive information about their operand in Teradata. FREE ACCESS
  • Locked
    4.  Using String Functions
    5m 26s
    Learn how to use string functions to perform operations on strings of data in Teradata. FREE ACCESS
  • Locked
    5.  Using Regular Expression Functions
    5m 47s
    During this video, you will learn how to use regular expression functions on data in Teradata. FREE ACCESS
  • Locked
    6.  Using Analytical Functions
    9m 43s
    Find out how to use the analytical functions in Teradata. FREE ACCESS
  • Locked
    7.  Using CASE Expressions
    7m 48s
    In this video, you will learn how to use CASE expressions to evaluate a set of expressions in Teradata. FREE ACCESS
  • Locked
    8.  Using Calendar Functions
    5m 8s
    Learn how to use calendar functions to work with dates, months, and years in Teradata. FREE ACCESS
  • Locked
    9.  Using ANSI DateTime Expressions
    4m 41s
    In this video, you will learn how to use ANSI DateTime expressions to do computations with Time Zones and interval values in Teradata. FREE ACCESS
  • Locked
    10.  Using ANSI Interval Expressions
    5m 13s
    In this video, you will use ANSI Interval expressions to perform calculations on Interval values in Teradata. FREE ACCESS
  • Locked
    11.  Using Arithmetic DateTime and Interval Functions
    6m 42s
    Find out how to use arithmetic operators, ANSI DateTime, and Interval Data Types in Teradata. FREE ACCESS
  • Locked
    12.  Using Scalar Operations and DateTime Functions
    3m 54s
    In this video, find out how to use scalar operations with DateTime functions to work with dates and times in Teradata. FREE ACCESS
  • Locked
    13.  Using DateTime and Interval Functions (Part 1)
    6m 46s
    Learn how to use the different DateTime and Interval functions: ADD_MONTHS, OADD_MONTHS, and MONTHS_BETWEEN in Teradata. FREE ACCESS
  • Locked
    14.  Using DateTime and Interval Functions (Part 2)
    7m 53s
    Learn how to use the different DateTime and Interval functions: LAST_DAY, NEXT_DAY, TRUNC, ROUND, EXTRACT in Teradata. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course CompTIA Data+: Inferential Statistical Methods
Rating 4.6 of 5 users Rating 4.6 of 5 users (5)
Course CompTIA Data+: Data Governance
Rating 4.9 of 10 users Rating 4.9 of 10 users (10)
Course CompTIA Data+: Data Acquisition & Cleansing
Rating 4.6 of 13 users Rating 4.6 of 13 users (13)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Working with Data Definition Language (DDL)
Rating 4.5 of 4 users Rating 4.5 of 4 users (4)
Course Functions
Rating 4.5 of 43 users Rating 4.5 of 43 users (43)
Course Serverless App Development: Implementation in Google Cloud Platform
Rating 4.6 of 49 users Rating 4.6 of 49 users (49)