Working with Data Conversions & SET Operations

Teradata 14    |    Beginner
  • 12 Videos | 1h 2m 37s
  • Earns a Badge
Likes 13 Likes 13
You can use functions, expressions, and operators to perform operations on data in Teradata. Learn how to perform data conversions and computations, and use SET operators.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Overview of Data Type Conversions
    5m 58s
    UP NEXT
  • Playable
    2. 
    Understanding Implicit Type Conversions
    6m 23s
  • Locked
    3. 
    Overview of Using CAST
    3m 52s
    FREE ACCESS
  • Locked
    4. 
    Using Data Type Conversion Functions (Part 1)
    6m 32s
    FREE ACCESS
  • Locked
    5. 
    Using Data Type Conversion Functions (Part 2)
    7m 29s
    FREE ACCESS
  • Locked
    6. 
    Using Data Type Conversion Functions
    5m 44s
    FREE ACCESS
  • Locked
    7. 
    Overview of Using Set Operators
    4m 39s
    FREE ACCESS
  • Locked
    8. 
    Using INTERSECT
    4m 25s
    FREE ACCESS
  • Locked
    9. 
    Using MINUS and EXCEPT
    3m 30s
    FREE ACCESS
  • Locked
    10. 
    Using Union
    4m 41s
    FREE ACCESS
  • Locked
    11. 
    Using Set Operators in Advanced Queries
    4m 14s
    FREE ACCESS
  • Locked
    12. 
    Exercise: Using Teradata Functions
    5m 9s
    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 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

COURSE Operations with petl: Basic Data Transformations
COURSE Datasets in R: Transforming Data
CHANNEL Data Visualization
Likes 66 Likes 66  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Authentication & Security
Likes 14 Likes 14  
BOOK Teradata SQL
COURSE Working with Functions, Times, Dates, & Intervals
Likes 11 Likes 11