Teradata SQL

PT0061
Summary
In this course, students will learn SQL starting at the most basic level and going to the most advanced level with many examples.
Prerequisites
There are no prerequisites for this course.
Duration
3 Days/Lecture & Lab
Audience
This course is designed for anyone who has a desire to learn Teradata SQL from beginners to an advanced audience.
Topics
  • 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
  • Top SQL Commands Cheat Sheet

Related Scheduled Courses