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
- SPOOL Space
- TEMP Space
Understanding Different Types of Tables for Government
- Derived Table
- Volatile Table
- Global Temporary Table
Protecting Data in Teradata for Government
- RAID Protection
- Achieving and Recovering Data
Distributing Data in Teradata for Government
- Hashing Algorithm
- Primary and Secondary Index 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 utilizing SQL for government applications and data management.
Audience
- Government Developers
14 Hours
Testimonials (1)
Nice training, full of interesting topics. After each topic helpful examples were provided.
