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 recovery and availability
Distributing Data in Teradata
- Hashing Algorithm
- Primary and secondary indexes in Teradata
- Retrieving data using PI and NUPI
- Retrieving data using USI and NUSI
Understanding Additional Indexes in Teradata
- PPI (Partitioning Primary Index)
- MLPPI (Multi-Level PPI)
- Join Index
- Sparse Index
Reading Explain Plans
- Key terms in Explain Plans
Teradata Join Strategies
- Handling various types of SQL Joins
- Teradata SQL Performance Tuning
- Optimization in Teradata
Using SQL in Teradata
- Working with Various Functions
- String Functions
- Format Functions
- Cast Functions
- Date Functions
- Group and Aggregate Functions
Utilizing Teradata Utilities
- FastLoad
- MultiLoad
- FastExport
- BTEQ
- Advantages and disadvantages of each utility
Best Practices
Troubleshooting
Summary and Conclusion
Requirements
- Extensive experience with SQL.
Target Audience
- Developers
14 Hours
Testimonials (1)
passionate trainer