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