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 2700
Group Training Date On Request
1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
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

Module 1: Introduction
  • What is Teradata
  • Overview of Teradata
  • Data warehouse concepts
Module 2: Teradata Architecture and Components
  • 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
Module 3: Data Recovery and Security
  • locks
  • RAID 1&RAID 5
  • Disk Arrays
  • Fall Back
  • Clique
  • AMP Clustering
  • Journaling
  • Answering various recovery questions
Module 4: 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
  • Keys Vs Indexes
Module 5: Teradata Sql Reference
  • SQL Fundamentals
  • Data Types and Literals
  • Data Definition Statements(DDL)
  • Data Manipulation Statements(DML)
  • Explaining with proper examples
Module 6: Teradata Functions and Operators
  • String Functions
  • Format Function
  • Cast Functions
  • Group & Aggregate Functions
  • With & with by clauses
  • Practices of this section
Module 7: Teradata Transactions
  • 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
Module 8: Teradata Basic Commands
  • HELP
  • SHOW
  • EXPLAIN
  • COLLECT STATISTICS
Module 9: 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
Module 10: Teradata spaces
  • PERM space
  • SPOOL space
  • TEMPORARY space
  • Teradata User and managing
  • Practical Examples
Module 11: Teradata Transaction Modes
  • BTET
  • ANSI
  • Interactive
  • Batch
Module 12: Teradata Sql Assistant (Queryman)
  • How to use Sql Assistant
  • Query Processing
  • Importing and exporting
Module 13: Teradata Utilities
  • Topic details are not available.
Module 14: BTEQ
  • Teradata BTEQ
  • Batch Scripts with samples
  • Branching and Looping
  • Importing data through scripts
  • Exporting data through scripts
  • Error handling
  • Explanation with proper debugging
Module 15: Fast Load
  • Teradata Fast Load
  • Various Phases of Fast Load
  • Advantages and Process
  • Limitations of Fast Load
  • Sample Scripts
Module 16: Multi Load
  • Teradata Multi Load
  • Various Phases of Multi Load
  • Advantages and Process
  • Limitations of Multi Load
  • Working with multiple tables
  • Applying various operations
  • Sample Scripts
Module 17: Fast Export
  • Teradata Fast Export
  • Advantages and Process
  • Limitations of Fast Export
  • Sample Scripts
Module 18: Fast Export
  • 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
Module 19: Performance Tuning
  • Performance Tuning and Explain Utility
  • Explain Usage
  • Collecting Statistics
  • Tuning SQL Performance
  • Explaining various SQL statements
Module 20: Real time scenarios and Project Architecture
  • 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.
Download Course Contents

Request More Information

Course Prerequisites

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