Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction
Managing Space in Teradata
- PERM Space
- SPOOL Space
- TEMP Space
Understanding Different Types of Tables
- Derived Table
- Volatile Table
- Global Temporary Table
Protecting Data in Teradata
- RAID protection
- Data acquisition and recovery
Distributing Data in Teradata
- Hashing Algorithm
- Primary & secondary indexes in Teradata
- Retrieving data using PI & NUPI
- Retrieving data using USI & NUSI
Understanding Other Indexes in Teradata
- PPI (Partition Primary Index)
- MLPPI (Multi-Level PPI)
- Join Index
- Sparse Index
Reading Explain Plan
- Key terms in Explain Plan
Teradata Join Strategies
- Handling various types of Joins in SQL
- Teradata SQL Performance Tuning
- Optimization in Teradata
Using SQL in Teradata
- Working with various Functions
- String Functions
- Format Functions
- Cast Functions
- Date Functions
- Group & Aggregate Functions
Using Teradata Utilities
- FastLoad
- MultiLoad
- FastExport
- BTEQ
- Pros & cons of each utility
Best Practices
Troubleshooting
Summary and Conclusion
Requirements
- Extensive experience in using SQL.
Audience
- Developers
14 Hours
Testimonials (1)
passionate trainer
