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
 

Testimonials

Related Courses

Teradata Fundamentals

  21 hours

Big Data Business Intelligence for Govt. Agencies

  35 hours

From Data to Decision with Big Data and Predictive Analytics

  21 hours

Big Data Architect

  35 hours

Programming with Big Data in R

  21 hours

Big Data Storage Solution - NoSQL

  14 hours

Big Data & Database Systems Fundamentals

  14 hours

Data Science for Big Data Analytics

  35 hours

A Practical Introduction to Data Analysis and Big Data

  35 hours

Vespa: Serving Large-Scale Data in Real-Time

  14 hours

Big Data Analytics for Telecom Regulators

  14 hours

Big Data Business Intelligence for Criminal Intelligence Analysis

  35 hours

Big Data - Data Science

  14 hours

Big Data and its Management Process

  14 hours

SQL For Data Science and Data Analysis

  14 hours