Get in Touch

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

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories