Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
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
- Capgemini Polska sp. z o.o.
Related Courses
Teradata Fundamentals
21 hours
Big Data Architect
35 hours
Programming with Big Data in R
21 hours
Big Data Storage Solution - NoSQL
14 hours
Data Science for Big Data Analytics
35 hours
Big Data - Data Science
14 hours
Big Data and its Management Process
14 hours