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 and secondary indexes in Teradata
- Retrieving data using PI and NUPI
- Retrieving data using USI and NUSI
Understanding Other Indexes in Teradata
- PPI (Partition Primary Index)
- MLPPI (Multi-Level PPI)
- Join Index
- Sparse Index
Reading Explain Plan
- Key keywords in Explain Plan
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
Using Teradata Utilities
- FastLoad
- MultiLoad
- FastExport
- BTEQ
- Pros and Cons of Each Utility
Best Practices
Troubleshooting
Summary and Conclusion
Requirements
- Extensive experience with SQL.
Audience
- Developers
14 Hours
Testimonials (1)
passionate trainer