Teradata database is a relational database system used to store data. It supports single-node, symmetric multiprocessing systems and multinode, massively parallel processing systems providing fast interconnected structures for querying data. Teradata supports the use of ANSI SQL for querying, along with providing its own Teradata extensions.

Course content

The SELECT Statement

Course: 1 Hour, 39 Minutes

• Course Introduction
• Overview of SQL for Teradata
• Overview of the Basic Teradata Query Utility
• The SELECT Statement
• Performing Basic SELECT Statements
• Performing Basic WHERE Clause Searches
• Performing Advanced WHERE Clause Searches
• Using the ORDER BY Clause
• Using the GROUP BY and HAVING Clauses
• Using TOP, SAMPLE, and SAMPLEID
• Using Aggregations
• Using GROUPING SETS, ROLLUP, and CUBE
• Using the WITH Clause

Joins

Course: 56 Minutes

• Overview of Joins
• Performing Natural Joins
• Performing Theta Joins
• Performing Inner Joins
• Performing Outer Joins
• Performing Self Joins and Cross Joins
• Performing Multitable Joins

Subqueries and Correlated Subqueries

Course: 41 Minutes

• Overview of the Types of Subqueries
• Performing Subqueries in a SELECT Statement
• Performing Subqueries in Search Conditions
• Performing Scalar Subqueries
• Performing Correlated Subqueries
• Using Derived Tables

Practice: Querying a Teradata Database

Course: 9 Minutes

• Exercise: Using the SELECT Statement

Functions

Course: 53 Minutes

• Course Introduction
• Overview of Functions and SQL Operators
• Using Arithmetic Functions
• Using Attribute Functions
• Using String Functions
• Using Regular Expression Functions
• Using Analytical Functions
• Using CASE Expressions

Times, Dates, and Intervals

Course: 43 Minutes

• Using Calendar Functions
• Using ANSI DateTime Expressions
• Using ANSI Interval Expressions
• Using Arithmetic DateTime and Interval Functions
• Using Scalar Operations and DateTime Functions
• Using DateTime and Interval Functions (Part 1)
• Using DateTime and Interval Functions (Part 2)

Data Conversions and Computations

Course: 35 Minutes

• Overview of Data Type Conversions
• Understanding Implicit Type Conversions
• Overview of Using CAST
• Using Data Type Conversion Functions (Part 1)
• Using Data Type Conversion Functions (Part 2)
• Using Data Type Conversion Functions (Part 3)

SET Operations

Course: 23 Minutes

• Overview of Using Set Operators
• Using INTERSECT
• Using MINUS and EXCEPT
• Using Union
• Using Set Operators in Advanced Queries

Practice: Using Functions and Operators

Course: 5 Minutes

• Exercise: Using Teradata Functions

Data Definition Language

Course: 1 Hour, 36 Minutes

• Course Introduction
• Creating and Altering Databases
• Creating and Managing Database Users
• Creating Basic Tables
• Creating Advanced Tables
• Altering Tables
• Creating and Altering Indexes
• Creating and Altering Views
• Creating Recursive Views
• Creating Macros
• Creating Triggers
• Creating Procedures
• Altering Functions and Procedures

Data Manipulation Language

Course: 34 Minutes

• Using the QUALIFY Clause
• Using NORMALIZED
• Using the EXPAND ON Clause
• Using the INSERT Statement
• Using the UPDATE Statement
• Using the DELETE Statement
• Using MERGE

SQL Optimization

Course: 10 Minutes

• Optimizing Query Design
• Improving Performance of Merge Joins

Temporal Concepts

Course: 24 Minutes

• Overview of Temporal Concepts
• Creating Temporal Tables
• Loading Data into Temporal Tables
• Performing DDL on Temporal Tables
• Performing DML on Temporal Tables

Practice: Use DDL, DML, and Temporal Tables

Course: 8 Minutes

• Exercise: Performing DDL and DML in Teradata