Teradata

1.) Introduction to Teradata

  • a) Teradata Overview
  • b) Teradata Architecture
  • c) Parallelism in Teradata
  • d) Teradata components
  • e) Different types of Data storage in Teradata
  • f) How Teradata is different form others DB

2.) Detailed Teradata Architecture

3.) Indexes/Hashing/Joins in Teradata

  • a) Importance of Indexes in Teradata
  • b) Primary Indexes
  • c) Secondary Indexes
  • d) NUSI Indexes
  • e) Factors for selecting Primary Index and its importance
  • f) Data Skewness
  • g) Hashing in Teradata
  • h) Joins in Teradata

4.) Teradata utilities and useful constructs

  • a) Use of Explains
  • b) Use of Statistics
  • c) Use of Case Logic
  • d) Use of Date Logic
  • e) Use of Cast statement
  • f) Data formatting examples

5.) SQL in Teradata

  • a) Basic SQL
  • b) First query in Teradata
  • c) How to construct a query using Grouping/Aggregating/Summarizing
  • d) Functions
  • e) Different types of statements (DML Statement, Case, Upsert, Merge, etc…)
  • f) Pre-aggregation and Union—All Techniques
  • g) OLAP Expressions
  • h) Use of Sampling
  • i) NUSI Lookups
  • j) Advanced Query Tuning
  • k) Statistical Functions
  • l) OLAP Analytics

6.) Teradata utilities

  • a) BTEQ utility
  • b) Live project scenarios using BTEQ utility with Debugging Techniques – USP
  • c) Fastload utility
  • d) Live project scenarios using Fastload utility with Debugging Techniques – USP
  • e) Mload utility
  • f) Live project scenarios using Mload utility with Debugging Techniques – USP
  • g) Export, Fast Export utility
  • h) Live project scenarios using Export, Fast Export utility with Debugging Techniques – USP
  • i) Tpump utility
  • j) Live project scenarios using Tpump utility with Debugging Techniques – USP
  • k) TPT
  • l) Hands-on exercises

7.) Teradata utilities and sql Interface with Unix shell scripts – USP

8.) Teradata best practices – USP