Working with Clauses, Operators, Expressions, & Aggregates

Teradata 14
  • 8 Videos | 1h 1m 31s
  • Earns a Badge
Likes 13 Likes 13
Learn how to work with clauses, operators, expressions, and aggregates in Teradata using ANSI SQL and Teradata extensions.

WHAT YOU WILL LEARN

  • use basic WHERE clause in a SELECT statement to perform conditional queries in Teradata
    perform advanced WHERE clause searches in a SELECT statement to limit results in Teradata
    use the ORDER BY clause in a SELECT statement to perform a query in Teradata
    use the GROUP BY and HAVING clauses to perform grouping in query results in Teradata
  • use TOP, SAMPLE, and the SAMPLEID expression in a SELECT statement to limit results in Teradata
    use MIN, MAX, COUNT, AVG, SUM aggregates in a SELECT statement in Teradata
    use GROUPING SETS, ROLLUP, and CUBE to analyze data across a dimension in Teradata
    use the WITH clause in a SELECT statement in Teradata

IN THIS COURSE

  • Playable
    1. 
    Performing Basic WHERE Clause Searches
    6m 47s
    UP NEXT
  • Playable
    2. 
    Performing Advanced WHERE Clause Searches
    9m 6s
  • Locked
    3. 
    Using the ORDER BY Clause
    6m 7s
  • Locked
    4. 
    Using the GROUP BY and HAVING Clauses
    9m 40s
  • Locked
    5. 
    Using TOP, SAMPLE and SAMPLEID
    7m 20s
  • Locked
    6. 
    Using Aggregations
    6m 12s
  • Locked
    7. 
    Using GROUPING SETS, ROLLUP, and CUBE
    9m 56s
  • Locked
    8. 
    Using the WITH clause
    6m 25s

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 24 Likes 24  
Likes 31 Likes 31  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 14 Likes 14  
Likes 5 Likes 5