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 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
-
3. Using the ORDER BY Clause6m 7sLearn how to use the ORDER BY clause in a SELECT statement to query Teradata. FREE ACCESS
-
4. Using the GROUP BY and HAVING Clauses9m 40sIn this video, learn how to use the GROUP BY and HAVING clauses to group query results in Teradata. FREE ACCESS
-
5. Using TOP, SAMPLE and SAMPLEID7m 20sIn this video, you will use TOP, SAMPLE, and the SAMPLEID expression in a SELECT statement to limit results in Teradata. FREE ACCESS
-
6. Using Aggregations6m 12sIn this video, find out how to use MIN, MAX, COUNT, AVG, and SUM aggregates in a SELECT statement in Teradata. FREE ACCESS
-
7. Using GROUPING SETS, ROLLUP, and CUBE9m 56sIn this video, you will use GROUPING SETS, ROLLUP, and CUBE to analyze data across a dimension in Teradata. FREE ACCESS
-
8. Using the WITH clause6m 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.
