Have Queries? Ask us +91 72592 22234

Course Overview

Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on Teradata which gives you the opportunity to interact with a Teradata instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants.

Course Content

Teradata Architecture and Components

  • PDE(ParaIIe| Data Extension)
  • Vprocs (virtual processors)
  • PE (Parsing Engine)
  • AMP (Access Module processing)
  • Board less Bynet
  • TDP (Teradata Directory Program)
  • CLI (Call Level Interface)
  • TPA (Trusted parallel Application)
  • Going in depth by explaining the process of SQL statement execution

Various Architecture

  • Node Architecture (shared nothing)
  • SMP Architecture
  • MPP Architecture
  • Parallelism Architecture
  • Benefit & types

Data Recovery and Protection

  • Object Locks-Various locks for simultaneous access
  • RAIDI 
  • Disk Arrays
  • Fall Back
  • Clique
  • AMP Clustering
  • Journals

Teradata Storage and Retrieval Architecture

  • Request processing
  • Syntaxer
  • Resolver
  • Security Module
  • Optimizer
  • Step Generator
  • GNC Apply
  • Dispatcher

Primary index

  • Hash algorithm
  • Row hash
  • DSW
  • Hash Map
  • Hash Bucket
  • Reaching Vdisk

Teradata Indexes

  • Primary Index
  • Unique
  • Non unique
  • Partitioned
  • Secondary Index
  • Unique
  • Non unique
  • Hash, Join, Value Ordered
  • Skewness
  • Secondary Index Sub table
  • Accessing Records via primary index
  • Accessing records via Secondary index
  • Keys vs indexes

Teradata Sql Reference

  • Fundamentals
  • Data Types and Literals
  • Data Definition Statements
  • Data manipulation statements

Teradata Functions and Operators

  • String functions
  • Format functions
  • Cast functions
  • Group &Aggregate functions
  • With & with by clauses

Teradata Transactions

  • Implicit Transaction
  • Explicit Transaction

Performance Tuning and Explain Utility

  • Explain Usage
  • Collection Statistics
  • Tuning SQL Performance
  • Usage of PMON

Joints & Unions

  • Inner Join
  • Left Outer Join
  • Right Outerjoin
  • Full Outer Join

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

Teradata spaces

  • PERM space
  • SPOOL space
  • TEMPORARY space
  • Teradata user and managing.

Teradata Transaction Modes

  • BTET
  • ANSI
  • Interactive
  • Batch

Load and Unload Utilities & Tools

  • Teradata Sql Assistant (Queryman)
  • Teradata Performance Monitor
  • Teradata BTEQ
    • Batch Scripts with samples
    • Branching and Looping
    • Importing data through scripts
    • Exporting data through scripts
    • Session Control Command Set
    • Error handling.
  • Teradata Fast load
    • Various Phases of Fast Load
    • Advantages and Process
    • Limitations of Fast Load
    • Sample scripts
  • Teradata Multi Load
    • Various Phases of Multi load
    • Limitations of Multi Load
    • Working with multiple tables
    • Applying various operations
    • Sample Scripts

Customer Reviews

Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.


For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for


My Team/Organization

I agree to be contacted over mail or phone

Call us at: +91 7259222234