Course Outline

Introduction

Managing Space in Teradata

  • PERM Space
  • SPOOLSpace
  • TEMP Space

Understanding Different Types of Tables

  • Derived Table
  • Volatile Table
  • Global Temporary Table

Protecting Data in Teradata

  • RAID protection
  • Achieving and recovering data

Distributing Data in Teradata

  • Hashing Algorithm
  • Primary & secondary index in Teradata
  • Retrieving data using PI & NUPI
  • Retrieving data using USI & NUSI

Understanding Other Indexes in Teradata

  • PPI (Partition Primary Index)
  • MLPPI (Multi Level PPI)
  • Join Index
  • Sparse Index

Reading Explain Plan

  • Key words in Explain Plan

Teradata Join Strategies

  • Dealing with different types of Joins in SQL
  • Teradata SQL Performance Tuning
  • Optimization in Teradata

Using SQL in Teradata

  • Working with different Functions
    • String Functions
    • Format Functions
    • Cast Functions
    • Date Functions
    • Group & Aggregate Functions

Using Teradata Utilities

  • FastLoad
  • MultiLoad
  • FastExport
  • BTEQ
  • Pros & cons of each utility

Best Practices

Troubleshooting

Summary and Conclusion

Requirements

  • Rich experience in using SQL.

Audience

  • Developers
 14 Hours

Number of participants



Price per participant

Testimonials (5)

Related Courses

Teradata Fundamentals

21 Hours

Big Data Analytics for Telecom Regulators

14 Hours

Big Data Business Intelligence for Govt. Agencies

35 Hours

Big Data Architect

35 Hours

Big Data Business Intelligence for Criminal Intelligence Analysis

35 Hours

Programming with Big Data in R

21 Hours

Big Data Storage Solution - NoSQL

14 Hours

A Practical Introduction to Data Analysis and Big Data

35 Hours

Big Data & Database Systems Fundamentals

14 Hours

Big Data - Data Science

14 Hours

From Data to Decision with Big Data and Predictive Analytics

21 Hours

Data Science for Big Data Analytics

35 Hours

Machine Learning and Big Data

7 Hours

Sqoop and Flume for Big Data

7 Hours

Talend Big Data Integration

28 Hours

Related Categories

1