TRAINING

Enroll Now

Teradata development Training  

Teradata development, will introduce the participants to work with Teradata. The course will cover in detail about Teradata Architecture, Indexing mechanism and how data is stored and retrieved. 

It will cover basic and advanced SQL operations in Teradata. It will also cover various utilities provided by Teradata to process, import and export data. Participants will also get to implement one project towards the end of the course. 

Audience

The course is designed for all those who want to learn Teradata. 

• Developers/Designers who want to gain acceleration in their careers as an Teradata Developer/Designer
• Analytics Managers who are subject matter experts, leading a team of analysts. 
• Individual Contributors in the field of Enterprise Business Intelligence

Teradata Developer Course Content

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