Teradata Certification Training Course Overview

Enroll for the 4-days Teradata certification training course from Koenig solutions. This course will introduce you to the fundamentals of working with Teradata. In this, you will learn about Teradata architecture, the indexing mechanism and the various SQL queries that will allow you to retrieve and perform manipulations on your data. You will also learn about the various Teradata utilities such as Fast Load and Multi Load and how they are used to import data into Teradata.

Target Audience

The following job roles will be benefited from this training:

  • Developers/Designers who want to gain acceleration in their careers as a Teradata Developer/Designer.
  • Analytics Managers
  • Enterprise Business Intelligence Professionals

Learning Objectives

Upon completion of this training, you will be able to:

  • Understand Teradata architecture and indexing mechanisms
  • Understand the competitive advantages of Teradata over other RDBMSs
  • Use Teradata application utilities for importing/exporting data
  • Learn how to process data in Teradata tables using SQL processes
  • Implement performance tuning techniques and optimize queries

Teradata Certification Training (Duration : 32 Hours) Download Course Contents

Live Virtual Classroom

Fee : On Request
9 AM - 5 PM (Flexible Time Slots for 4 hours option)




Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request

Special Solutions for Corporate Clients! Click here

Hire Our Trainers! Click here

Course Modules

  • What is Teradata
  • Overview of Teradata
  • Data warehouse concepts
  • Teradata Architecture
  • SMP Architecture
  • MPP Architecture
  • AMP(Access Module Processing)
  • TDP(Teradata Directory Program)
  • CLI(Call Level Interface)
  • TPA(Trusted Parallel Application)
  • Parallelism Architecture
  • Benefits and Types
  • locks
  • RAID 1&RAID 5
  • Disk Arrays
  • Fall Back
  • Clique
  • AMP Clustering
  • Journaling
  • Answering various recovery questions
  • 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
  • Keys Vs Indexes
  • SQL Fundamentals
  • Data Types and Literals
  • Data Definition Statements(DDL)
  • Data Manipulation Statements(DML)
  • Explaining with proper examples
  • String Functions
  • Format Function
  • Cast Functions
  • Group & Aggregate Functions
  • With & with by clauses
  • Practices of this section
  • Joins and Unions
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Detailed explanation
  • Join Strategies
  • Product Join
  • Merge Join
  • Questions of this section
  • HELP
  • SHOW
  • EXPLAIN
  • COLLECT STATISTICS
  • Tables
  • SET table
  • Multi Set table
  • Volatile tables
  • Global Temporary tables
  • Derived tables
  • Views
  • Macros
  • Stored Procedures
  • Triggers
  • Practices and FAQs of this session
  • PERM space
  • SPOOL space
  • TEMPORARY space
  • Teradata User and managing
  • Practical Examples
  • BTET
  • ANSI
  • Interactive
  • Batch
  • How to use Sql Assistant
  • Query Processing
  • Importing and exporting
  • 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
  • Teradata Multi Load
  • Various Phases of Multi Load
  • Advantages and Process
  • Limitations of Multi Load
  • Working with multiple tables
  • Applying various operations
  • Sample Scripts
  • Teradata Fast Export
  • Advantages and Process
  • Limitations of Fast Export
  • Sample Scripts
  • Advantages and Process
  • Teradata Parallel Data Pump
  • Limitations of TPump
  • Overview of TPump
  • Sample Scripts
  • Utility Vs Parallelism
  • Difference between Multi load and T pump
  • Performance Tuning and Explain Utility
  • Explain Usage
  • Collecting Statistics
  • Tuning SQL Performance
  • Explaining various SQL statements
  • Retail or Banking or Health care Project Architecture
  • Teradata relation with Informatica
  • How to run Teradata scripts in Unix
  • Sample Real time scripts walk thru.
  • Interview guidance.

Request More Information

Course Prerequisites

Participants are expected to have basic Knowledge in SQL, general relational database knowledge and basic Unix commands.