Course Description
Teradata supports the use of ANSI SQL to query data housed within the database system. Along with ANSI SQL, it also supports Teradata extensions that can be used. This course will demonstrate how to use the SELECT statement to perform queries, along with performing joins, subqueries, and correlated subqueries.
Learning Objectives
The SELECT Statement
- start the course
- describe SQL and how it can be used in Teradata
- launch and use the BTEQ command line tool and identify how it is used as a query management tool
- describe the different clauses in a SELECT statement
- perform basic SELECT statements in Teradata
- 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
Joins
- describe the different types of joins that can be performed in Teradata
- perform natural joins in Teradata
- perform theta joins in Teradata
- perform inner joins in Teradata
- perform outer joins in Teradata
- perform self joins and cross joins in Teradata
- perform multi-table joins in Teradata
Subqueries and Correlated Subqueries
- describe subqueries, scalar subqueries, and correlated subqueries, and how they are used in Teradata to retrieve results
- perform basic subqueries in a SELECT statement to return results from Teradata
- perform subqueries in the search condition of a WHERE clause
- perform scalar subqueries to return results from Teradata
- perform correlated subqueries to return results from Teradata
- create and use derived tables in Teradata
Practice: Querying a Teradata Database
- use the SELECT statement to perform queries, including performing joins and subqueries