TeraData Training

Teradata Training

Teradata delivers powerful and proven solutions that bring together different data sources from across your enterprise to give you a single view of your business. Choose from an entire family of data warehousing platforms that provide the benefits of Active Enterprise Intelligence to any company, regardless of size or budget.

Teradata brings it all together with the expertise of the largest and most experienced force of consultants in the data warehousing industry to help you design, implement, and maintain your Teradata system.

Course Information

Duration: 30 Hours

Timings: Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day

Method: Online/Classroom Training

Study Material: Soft Copy

Course Content

Introduction:

What is Teradata

Overview Of Teradata

Data warehouse concepts

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

Data Recovery and Security

locks

RAID 1&RAID 5

Disk Arrays

Fall Back

Clique

AMP Clustering

Journaling

Answering various recovery questions

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

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

Teradata Basic Commands

HELP

SHOW

EXPLAIN

COLLECT STATISTICS

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)

How to use Sql Assistant

Query Processing

Importing and exporting

Teradata Utilities

BTEQ

Teradata BTEQ

Batch Scripts with samples

Branching and Looping

Importing data through scripts

Exporting data through scripts

Error handling

Explanation with proper debugging

Fast Load

Teradata Fast Load

Various Phases of Fast Load

Advantages and Process

Limitations of Fast Load

Sample Scripts

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

Fast Export

Teradata Fast Export

Advantages and Process

Limitations of  Fast Export

Sample Scripts

T-Pump

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

Performance Tuning and Explain Utility

Explain Usage

Collecting Statistics

Tuning SQL Performance

Explaining various SQL statements

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.

Key Features

Instructor Led Online Training

Flexible Time At Your Convenience

Over 1,00,000+ Professionals Trained Across 100 Countries

24x7 Live Support via Chat, Mail and Phone

Corporate Training and On-Job Support

Request for demo