Teradata Online Training Course Content :

WHAT IS TERADATA???? WHY TERADATA IS NEEDED????

What is Teradata…
Teradata v12 & next versions
Teradata History
Teradata users scalability
Teradata and other R-DBMS’s
Teradata is a warehouse
Teradata in the Enterprise level
Interview Questations & Answers and Certification support
Real time Scenarios & Problems – Solutions

TERADATA ARCHITECTURE & IT’S COMPONENTS

Node Architecture (Shared Architecture)
SMP Architecture
MPP Architecture
Parsing engine(PE) Architecture
AMP Architecture &usage
Bynet Benefits and types
Parallel data extension-(PDE)
Teradata directory program(TDP)
Call level interface-(CLI)
Trusted parallel application-(TPA)
Virtual processors
Bynet 0 and Bynet 1
Parallism Architecture

RECOVERY &PROTECTION OF DATA

What is fall back &where it used
Why for fall back
What is Clique
AMP Clustering
& types for simultaneous Access
Why for locks &how to release
RAID 1 and RAID 5
Journals and types
Virtual Disk Array
How & where is used journals
Q and A about data recovery

TERADATA INDEXES

Types of indexes in Teradata
Hash index
Join index
Primary index(unique, non- unique)
Secondary index(unique, non- unique)
Skewness
Keys & indexes (How & why these used)

HOW TO STORAGE & RETRIEVAL OF DATA

Hash algorithm
hash
Hash map
Hash bucket
Receiving VDisc

TERADATA SQL QUARRYMAN

SQL fundamentals
Data types and literals
DDL Statements
DML Statements
Teradata naming conversing

TERADATA SQL QUARRYMAN in Teradata Online Training

SQL fundamentals
Data types and literals
DDL Statements
DML Statements
Teradata naming conversing

TERADATA SQL FUNCTIONS & OPERATIONS

String functions
Format functions
Cast functions
Cast functions
Group and Aggregation functions
Logical operations
Arithmetic operations
set operations
join operations
conditional expressions

TERADATA JOIN STRATEGIES & UNIONS

hash join
merge join
nested join
product join
inner join
left & right outer join
full outer join

TERADATA BASIC COMMANDS

Help
Show
Explain
Collect statistics

TERADATA OBJECTS
TERADATA MEMORY SPACES

Permanent spaces
Temporary spaces
Spool spaces
Users spaces & PWD

TERADATA TRANSACTION MODES : Teradata Online Training

Batch mode
BTET mode
ANSI mode
How Converted into others

TERADATA PERFORMANCE TUNING ON SQL ASSISTANCE

Usage of PMON
Explain usage
Collecting statistics
SQL tuning
Various SQL statements
Real time Issues & resolving

TERADATA UTILITIES & TOOLS (IMPORT & EXPORT)

Teradata BTeq scripts
Overview of BTeq
Looping stages
Batches scripts
Import &export scripts with Examples
Error handling
Real time scripts
Teradata FastLoad
Types of phages & how to find it
Advantages & its process
Limitations of fast load
Real time scripts
Teradata MultiLoad
Overview of Multi load
Types of phages in MultiLoad
Advantages & its process
Limitations of MultiLoad
Uses various types of operations
Work on Multi tables
Real time scripts
Sample scripts
Teradata Tpump
Overview of Tpump
Limitations of Tpump
Work on Multi tables
Real time scripts
Sample scripts
Teradata Fast Export
How to export the data
Passing parameters
IN and OUT Modes
Work on Multi tables
Real time scripts
Sample scripts
Teradata SQL Assistant(Quarryman)
Teradata performance monitor
Teradata Administrator usage
Teradata performance tuning on scripts

KEY SERVICE

FAQS
DBA concepts
Performance tuning
Real time scenarios and solutions
Certification support
Preparation of Resume
Sample Resumes will be provided
Interview Questions & Answers
How to attend the interview’s
Complete Project explanation

More about

Teradata training