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 for Government
- PERM Space
- SPOOLSpace
- TEMP Space
Understanding Different Types of Tables
- Derived Table
- Volatile Table
- Global Temporary Table
Protecting Data in Teradata for Government
- RAID Protection
- Data Achieving and Recovery
Distributing Data in Teradata for Government
- 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 for Government
- PPI (Partition Primary Index)
- MLPPI (Multi Level PPI)
- Join Index
- Sparse Index
Reading Explain Plan for Government
- Key Words in Explain Plan
Teradata Join Strategies for Government
- Dealing with Different Types of Joins in SQL
- Teradata SQL Performance Tuning
- Optimization in Teradata
Using SQL in Teradata for Government
- Working with Different Functions
- String Functions
- Format Functions
- Cast Functions
- Date Functions
- Group and Aggregate Functions
Using Teradata Utilities for Government
- FastLoad
- MultiLoad
- FastExport
- BTEQ
- Pros and Cons of Each Utility
Best Practices for Government
Troubleshooting for Government
Summary and Conclusion for Government
Requirements
- Extensive experience in utilizing SQL for government data management and analysis.
Audience
- Software Developers for government applications
14 Hours
Testimonials (1)
Nice training, full of interesting topics. After each topic helpful examples were provided.
