Teradata Course Contents

Introduction to Teradata
 Data warehousing concepts and SCD’s
 OLTP & OLAP
 Teradata Architecture & Physical Design
 Teradata Vs. Other RDBMS
 BYNETPEs
 AMPs
 Vprocs
 Clique
 Cluster
 Data Storage
 Data Distribution
 Data Access
 Teradata Space Management

Fault Tolerance
 Data Protection
Teradata Indexes and Performance Tuning and Optimization
 UPI – Unique Primary Index
 NUPI – Non Unique Primary Index
 USI – Unique Secondary Index
 NUSI – Non Unique Secondary Index
 PPI – Partition Primary Index
 MLPPI – Multilevel Partition Primary Index
 STJI – Single Table Join Index
 MTJI – Multi Table Join Index
 AJI – Aggregate Join Index
 Global Temporary Tables and Volatile Temporary Tables
 Different Types of Tables in Teradata RDBMS
 Performance Tuning
 Explain Plan
Teradata Application Utilities
 Real-time hands-on Query Man / SQL Assistance
Teradata Application Utilities
 BTEQ
 FastExport
 FastLoad
 MultiLoad
 TPump
 Teradata Parallel Transporter (TPT)
 High Level Design of DWH Architecture from customer request to SDLC