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 Teradataperform advanced WHERE clause searches in a SELECT statement to limit results in Teradatause the ORDER BY clause in a SELECT statement to perform a query in Teradatause 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 Teradatause MIN, MAX, COUNT, AVG, SUM aggregates in a SELECT statement in Teradatause GROUPING SETS, ROLLUP, and CUBE to analyze data across a dimension in Teradatause the WITH clause in a SELECT statement in Teradata
IN THIS COURSE
-
6m 47sLearn how to use the basic WHERE clause in a SELECT statement to perform conditional queries in Teradata. FREE ACCESS
-
9m 6sIn this video, learn how to use advanced WHERE clause searches in a SELECT statement to limit results in Teradata. FREE ACCESS
-
6m 7sLearn how to use the ORDER BY clause in a SELECT statement to query Teradata. FREE ACCESS
-
9m 40sIn this video, learn how to use the GROUP BY and HAVING clauses to group query results in Teradata. FREE ACCESS
-
7m 20sIn this video, you will use TOP, SAMPLE, and the SAMPLEID expression in a SELECT statement to limit results in Teradata. FREE ACCESS
-
6m 12sIn this video, find out how to use MIN, MAX, COUNT, AVG, and SUM aggregates in a SELECT statement in Teradata. FREE ACCESS
-
9m 56sIn this video, you will use GROUPING SETS, ROLLUP, and CUBE to analyze data across a dimension in Teradata. FREE ACCESS
-
6m 25sDuring 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.