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

Introduction

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
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)

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
OUTMODS
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.

N/A

You may be also interested in

Register for FREE Demo

Fields marked with (*) are mandatory

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