Teradata SQL Training Overview
Accelebrate's Teradata SQL training course teaches attendees how to write queries to efficiently process and filter massive amounts of data contained in Teradata data warehouses.
Location and Pricing
Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for private corporate training on-site or online, please contact us.
In addition, some courses are available as live, instructor-led training from one of our partners.
Objectives
- Basic SQL Functions
- The WHERE Clause
- Distinct Vs. Group By
- Aggregation Function
- Join Functions
- Date Functions
- OLAP Functions
- Temporary Tables
- Sub-query Functions
- Strings
- Interrogating the Data
- View Functions
- Set Operators
- Data Manipulation Language (DML)
- Statistical Aggregate Functions
Prerequisites
No prior experience is required.
Outline
Introduction
Basic SQL Functions
The WHERE Clause
Distinct Vs. Group By
The TOP Command
Review
HELP and SHOW
Aggregation Function
Join Functions
Date Functions
Format Functions
OLAP Functions
The Quantile Function
Temporary Tables
Sub-query Functions
Substrings and Positioning Functions
Interrogating the Data
View Functions
Macro Functions
Set Operators Functions
Creating Tables, Secondary Indexes, and Join Indexes
Data Manipulation Language (DML)
Stored Procedure Functions
Trigger Functions
Math Functions
Sample
Statistical Aggregate Functions
Explain
Collect Statistics
Hashing Functions
BTEQ – Batch Teradata Query
Conclusion
Training Materials
All Teradata training students receive comprehensive courseware.
Software Requirements
We have multiple options for setting up this course using a mix of local and/or cloud resources that we provide. Please ask us for details.
