Teradata Tutorial – Basic to Advanced

In this Tutorial series , we will go through all the important topics which will help you in understanding Teradata from Basic to Advanced level.
If you are starting with Teradata or if you are preparing for Teradata interviews then this course will definitely help you.
I am planning to cover following points in this Tutorial series : (and few more)

Teradata Tutorial - Topics
Teradata Tutorial – Topics

Teradata Tutorial – Part 1

This is more of theoretical concepts.

Teradata Tutorial – Part 2

This is more of practical implementations.

  1. Teradata Introduction
  2. Teradata Utilities
    • BTEQ
    • Fastload
    • Multiload
    • TPT
    • Fastexport
    • TPUMP
  3. Teradata Storage
  4. Teradata Tables
    • Permanent
    • Volatile
    • Temporary
    • Set/Multiset
  5. Teradata System Tables/Views
    • DBC
  6. Teradata Indexes
    • Primary
    • Secondary
    • Partition Primary
    • NOPI
  7. Teradata LOCKS
  1. Teradata SQL
  2. Performance Tuning
    • Explain
    • Statistics
    • PI Skewness
    • PPI
    • Join/Filter conditions
    • Subquery VS Joins
    • No Fallback/Journal/Log
    • Window Functions
    • Update vs Delete + Insert
    • Query Rewrite
    • Compression
    • Join Index
  3. Other Objects
    • Macros
    • Views
    • Stored Procedures
  4. Join Strategies
    • Hash/Nested/Merge/Product

If I have missed any Topic which you feel I should cover as part of Teradata Tutorial course feel free to drop a comment below.

Leave a Reply

Your email address will not be published. Required fields are marked *