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.
