Teradata Training

Teradata is the solution offered by Teradata Corporation, an American company that sells database software for data warehouses and analytic applications, including Big data. The solutions developed by this company helps in consolidating data from different sources in order to make the data available for analysis.

Teradata Online Training

at BestOnlineTrainers starts with the overview of Teradata & further extends to Teradata architecture & components, data recovery, Teradata Storage and Retrieval Architectures and ends with real time issues resolution training.

  • Course Overview
  • Target Audience
  • Why choose us
  • Trainer Profile


  • What is Teradata-RDBMS?
  • Teradatav12 Vs Other versions
  • Overview of Teradata
  • Teradata History
  • Teradata warehouse
  • Teradata in the Enterprise
  • Teradata Users & Scalability
  • Teradata Comptitiveness with the Other RDBMS (Oracle, Sql Server etc)
  • Interview Q&A and Certification queries

Teradata Architecture and Components

  • Teradata Architecture
  • PDE(Parellel Data Extension)
  • Vprocs(Virtual Processors)
  • AMP(Access Module Processing)
  • TDP(Teradata Directory Program)
  • CLI(Call Level Interface)
  • TPA(Trusted Parallel Application)
  • SQL Statement Execution process in detail

Various Architectures

  • Node Architecture(Shared Nothing)
  • SMP Architecture
  • MPP Architecture
  • Parallelism Architecture
  • Benefits and Types

Data Recovery and Security

  • Why for locks & how to release
  • Various locks for simultaneous access
  • RAID 1 & RAID 5
  • Disk Arrays
  • Fall Back
  • Clique
  • AMP Clustering
  • Types of Journals
  • Recovery Journal
  • Trasient Journal
  • Permanent Journal
  • Before Journal
  • After Journal
  • How & where is used journals
  • Answering various recovery questions

Teradata Storage and Retrival Architectures

  • Request
  • Processing
  • Syntaxer
  • Resolver
  • Security Module
  • Optimizer
  • Step Generator
  • GNC Apply
  • Dispatcher
  • Primary Index
  • Hash algorithm
  • Row Hash
  • DSW
  • Hash Map
  • Hash Bucket
  • Reaching V disk

Teradata Indexes

  • Primary Index
  • Unique
  • Non unique
  • Partitioned
  • Secondary Index
  • Unique
  • NonUnique
  • Hash, Join, Value Ordered
  • Skewness
  • Secondary Index Sub table
  • Accessing Records via Primary Index
  • Accessing records via Secondary Index
  • Keys Vs Indexes
  • Full Real time scenarios and explaining

Teradata Sql Reference

  • SQL Fundamentals
  • Data Types and Literals
  • Data Definition Statements(DDL)
  • Data Manipulation Statements(DML)
  • Explaining with proper examples

Teradata Functions and Operators

  • String Functions
  • Format Function
  • Cast Functions
  • Group & Aggregate Functions
  • With & with by clauses
  • Practices of this section

Teradata Transactions

Implicit Transaction

Explicit Transaction

  • Performance Tuning and Explain Utility
  • Explain Usage
  • Collecting Statistics
  • Tuning SQL Performance
  • Usage of PMON
  • Explaining various SQL statements
  • Joins and Unions
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Detailed explanation
  • Join Strategies
  • Product Join
  • Merge Join
  • Hash Join
  • Nested Join
  • Questions of this section

Teradata Basic Commands

  • HELP
  • SHOW

Teradata Objects

  • Tables
  • SET table
  • Multi Set table
  • Volatile tables
  • Global Temporary tables
  • Derived tables
  • Views
  • Macros
  • Stored Procedures
  • Triggers
  • Practices and FAQs of this session

Teradata spaces

  • PERM space
  • SPOOL space
  • TEMPORARY space
  • Teradata User and managing
  • Practical Examples

Teradata Transaction Modes

  • BTET
  • ANSI
  • Interactive
  • Batch

Teradata Sql Assistant(Queryman)

  • Teradata Performance Monitor
  • Teradata BTEQ
  • Batch Scripts with samples
  • Branching and Looping
  • Importing data through scripts
  • Exporting data through scripts
  • Error handling
  • Explanation with proper debugging
  • Teradata Fast Load
  • Various Phases of Fast Load
  • Advantages and Process
  • Limitations of Fast Load
  • Sample Scripts

Real time Issues and resolving it

  • Teradata Multi Load
  • Various Phases of Multi Load
  • Limitations of Multi Load
  • Working with multiple tables
  • Applying various operations
  • Sample Scripts

Real time Issues and solving it

  • Teradata Parallel Data Pump
  • Limitations of TPump
  • Overview of TPump
  • Sample Scripts
  • Teradata Fast Export
  • Exporting Data
  • Passing Parameters
  • Sample Scripts
  • Utility Vs Parallelism

Introduction to Answering AD-hoc queries and FAQs

Covering DBA Concepts

Teradata training is intended for:

  • Professionals who want to make their career in Big data & analytics.
  • Students who want to learn about Teradata in order to give their career a start

We guarantee learning at your convenience & pace.

  • Instant Access:
    Get instant access to self-paced training after signup.
  • Streaming video recording:
    Watch lessons any time at your schedule, free recording.
  • Exercises:
    Practical exercises help you test what you are learning as you go.
  • Free Demo:
    Sign up for free demo to check whether the course is right for you and interact with the faculty live.
  • Experienced Trainers:
    We only hire the industry’s best trainers
  • Live free interactive web sessions:
    Ask the Expert Shell Scripting trainers about the career prospects and clarify your questions any time after you complete the course.
  • Structured Curriculum Schedule:
    Progress with your complete daily interactive lessons and assignments.
  • Faculty Mentoring:
    Turn in daily and weekly homework for personalized feedback from faculty.
  • Virtual Office Hours:
    Live interaction with the faculty and other students around the world.
  • Hands on Live Projects:
    Work on live lab sessions to tackle real-world projects. Get 100% faculty guidance and ratings.


You may be also interested in

Register for FREE Demo

Fields marked with (*) are mandatory

* Name:
* Email:
* Phone:
* Location:
* Course:
* Enquiry:
* Captcha:


Client Feedback

Thanks, you guys provided the best online training in SAP BODS. The hands on training is very informative and helpful.

- David Sergi, Camaga Ltd; U.K