8247  Reviews star_rate star_rate star_rate star_rate star_half

Teradata SQL

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. Skills Gained Basic...

Read More
Course Code TER-120
Duration 3 days
Available Formats Classroom

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.

Skills Gained

  • 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.

Course Details

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.

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