Teradata Architecture and SQL

Training Summary
In this course, students will learn the Teradata architecture and SQL starting at the most basic level and going to the most advanced level with many examples.
There are no prerequisites for this course.
2 Days/Lecture & Lab
This course is designed for anyone who has a desire to learn the Teradata architecture and SQL from beginners to an advanced audience. This course is completely customizable by the client.
Course Topics
  • The Teradata Architecture
  • The Primary Index
  • Hashing of the Primary Index
  • Partition Primary Index (PPI) Tables
  • Space
  • Secondary Indexes
  • Collect Statistics
  • The WHERE Clause
  • Distinct Vs. Group By
  • Aggregation Function
  • Join Functions
  • Date Functions
  • Basic OLAP Functions
  • Temporary Tables
  • Sub-query Functions
  • Strings
  • Interrogating the Data

Related Scheduled Courses