Teradata Developer

Learn how to use Teradata Developer from beginner level to advanced techniques which is taught by experienced working professionals. With our Teradata Developer Training in Chennai you'll learn concepts in expert level with practical manner.

Teradata

Teradata Developer Course Syllabus

Introduction to Teradata

  • Teradata Architecture Overview
  • Teradata Vs. Other RDBMS
  • BYNET
  • PEs
  • AMPs
  • Vprocs
  • Clique
  • Cluster
  • Data Storage
  • Data Distribution
  • Data Access
  • Teradata Space Management
  • Fault Tolerance
  • Data Protection
  • Teradata Client Tools and Utilities

Teradata Indices and Performance Tuning

  • UPI - Unique Primary Index
  • NUPI - Non Unique Primary Index
  • USI - Unique Secondary Index
  • NUPI - 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 Index
  • Hash Index
  • Performance Tuning
  • Explain Plan

Teradata Application Utilities

  • BTEQ - SQL
  • FastExport
  • FastLoad
  • MultiLoad
  • Teradata Parallel Transporter (TPT)
  • UNICODE support
  • INSERT/SELCT and MERGER INTO