Working with Clauses, Operators, Expressions, & Aggregates

Teradata 14    |    Beginner
  • 8 videos | 1h 1m 31s
  • Earns a Badge
Rating 4.6 of 15 users Rating 4.6 of 15 users (15)
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

  • 6m 47s
    Learn how to use the basic WHERE clause in a SELECT statement to perform conditional queries in Teradata. FREE ACCESS
  • 9m 6s
    In this video, learn how to use advanced WHERE clause searches in a SELECT statement to limit results in Teradata. FREE ACCESS
  • Locked
    3.  Using the ORDER BY Clause
    6m 7s
    Learn how to use the ORDER BY clause in a SELECT statement to query Teradata. FREE ACCESS
  • Locked
    4.  Using the GROUP BY and HAVING Clauses
    9m 40s
    In this video, learn how to use the GROUP BY and HAVING clauses to group query results in Teradata. FREE ACCESS
  • Locked
    5.  Using TOP, SAMPLE and SAMPLEID
    7m 20s
    In this video, you will use TOP, SAMPLE, and the SAMPLEID expression in a SELECT statement to limit results in Teradata. FREE ACCESS
  • Locked
    6.  Using Aggregations
    6m 12s
    In this video, find out how to use MIN, MAX, COUNT, AVG, and SUM aggregates in a SELECT statement in Teradata. FREE ACCESS
  • Locked
    7.  Using GROUPING SETS, ROLLUP, and CUBE
    9m 56s
    In this video, you will use GROUPING SETS, ROLLUP, and CUBE to analyze data across a dimension in Teradata. FREE ACCESS
  • Locked
    8.  Using the WITH clause
    6m 25s
    During this video, you will learn how to use the WITH clause in a Teradata SELECT statement. 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

Channel Data and Analytics at Work
Rating 2.0 of 1 users Rating 2.0 of 1 users (1)
Course Oracle Database 12c R2 SQL: Using the Set Operators
Rating 4.6 of 40 users Rating 4.6 of 40 users (40)
Journey How to Transform Tables with SQL

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Logical & Physical Design
Rating 4.6 of 169 users Rating 4.6 of 169 users (169)
Course Performing Subqueries & Correlated Subqueries
Rating 4.4 of 7 users Rating 4.4 of 7 users (7)
Course Primary & Partitioned Indexes
Rating 4.7 of 12 users Rating 4.7 of 12 users (12)