Course Outline
Introduction
Managing Space in Teradata
- PERM Space
- SPOOLSpace
- TEMP Space
Understanding Different Types of Tables
- Derived Table
- Volatile Table
- Global Temporary Table
Protecting Data in Teradata
- RAID protection
- Achieving and recovering data
Distributing Data in Teradata
- Hashing Algorithm
- Primary & secondary index 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 words in Explain Plan
Teradata Join Strategies
- Dealing with different types of Joins in SQL
- Teradata SQL Performance Tuning
- Optimization in Teradata
Using SQL in Teradata
- Working with different 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
- Rich experience in using SQL.
Audience
- Developers
Testimonials
Explaining the step to take when trying to answer a question via the SQL
Maastricht University | UMIO
The enthusiasm of the trainer
Maastricht University | UMIO
New learned skills
Maastricht University | UMIO
passionate trainer
Sylvia Baniak - Maastricht University | UMIO
I liked the depth of the training. I was able to understand most of it and definitely learned from this training
Maastricht University | UMIO
Discussing many examples.
Emily Chesworth - Maastricht University | UMIO
I like the comprehensive approach to the subject taught. The course was well-structured, the topics were prepared and presented in a good order, helping us understand step-by-step logic how particular aspects of Teradata work. Especially I like that a lot of impact was put on the topic of indices. Pablo is a very likeable person and a good teacher. The time spent on this training was definitely spent well.
MicroStrategy Poland Sp. z o.o.
Nice training, full of interesting topics. After each topic helpful examples were provided.
Pawel Wojcikowski - MicroStrategy Poland Sp. z o.o.
Materials (code, presentation) were good
MicroStrategy Poland Sp. z o.o.
the good energy of the trainer, he explained everything clearly and precisely
MicroStrategy Poland Sp. z o.o.
Tips to improve performance