Working with Functions, Times, Dates, & Intervals

Teradata 14
  • 14 Videos | 1h 32m 52s
  • Earns a Badge
Likes 11 Likes 11
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

  • Playable
    1. 
    Overview of Functions and SQL Operators
    9m 47s
    UP NEXT
  • Playable
    2. 
    Using Arithmetic Functions
    7m 15s
  • Locked
    3. 
    Using Attribute Functions
    5m 50s
  • Locked
    4. 
    Using String Functions
    5m 26s
  • Locked
    5. 
    Using Regular Expression Functions
    5m 47s
  • Locked
    6. 
    Using Analytical Functions
    9m 43s
  • Locked
    7. 
    Using CASE Expressions
    7m 48s
  • Locked
    8. 
    Using Calendar Functions
    5m 8s
  • Locked
    9. 
    Using ANSI DateTime Expressions
    4m 41s
  • Locked
    10. 
    Using ANSI Interval Expressions
    5m 13s
  • Locked
    11. 
    Using Arithmetic DateTime and Interval Functions
    6m 42s
  • Locked
    12. 
    Using Scalar Operations and DateTime Functions
    3m 54s
  • Locked
    13. 
    Using DateTime and Interval Functions (Part 1)
    6m 46s
  • Locked
    14. 
    Using DateTime and Interval Functions (Part 2)
    7m 53s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 0 Likes 0  
COURSE Data Analysis
Likes 101 Likes 101  
Likes 62 Likes 62  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 14 Likes 14  
Likes 5 Likes 5