Teradata SQL: The SELECT Statement, Joins, and Subqueries


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/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.

Target Audience
individuals looking to learn SQL basics to query Teradata databases

Prerequisites
None

Expected Duration (hours)
3.4

Lesson Objectives

Teradata SQL: The SELECT Statement, Joins, and Subqueries

  • 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
  • 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 multitable joins in Teradata
  • 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
  • use the SELECT statement to perform queries, including performing joins and subqueries

    • Course Number:
    df_tesq_a01_it_enus

    Expertise Level
    Beginner