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 (5)
The training was conducted in an interesting and professional way, which allowed for systematization and expansion of knowledge in the field of the training topic. The presenter demonstrated extensive experience and the ability to convey information. The training was very practical and tailored to our needs. I recommend
Dominik Kozłowski - Shell Polska
Course - Big Data - Data Science
Machine Translated
The beginning of day 3 was the best.
- Shell Polska
Course - Big Data - Data Science
Machine Translated
How big data work, data programs, greater knowledge of how our current world works using data
Ozayr Hussain - Vodacom
Course - A Practical Introduction to Data Analysis and Big Data
The practical side of the training.
Patrick - Vodacom PTy Ltd
Course - A Practical Introduction to Data Analysis and Big Data
The content, as I found it very interesting and think it would help me in my final year at University.