Working with Clauses, Operators, Expressions, & Aggregates

Teradata 14    |    Beginner
  • 8 videos | 1h 1m 31s
  • Earns a Badge
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

Course Database Fundamentals: Working with SQL Commands
Book Querying SQL Server: Run T-SQL Operations, Data Extraction, Data Manipulation, and Custom Queries to Deliver Simplified Analytics
Course Performing Joins

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Relational Database & Data Warehouse Basics
Course Logical & Physical Design
Course Java Persistence API: Executing Queries & Managing the Entity Lifecycle