Teradata Online Training

Teradata is a fully scalable relational database management system produced by Teradata Corp Browse through the contents of the program.

TERADATA Course Contents
Teradata History
Teradata users scalability
Teradata &other RDBMS
Teradata warehouse
Teradata in the Enterprise
Interview Q&A and Certification queries
Real time Issues & resolving
Node Architecture(Shared Architecture)
SMP Architecture
MPP Architecture
Parsing engine(PE) Architecture
AMP Architecture &uses
Bynet Benefits &types
Parallel data extension(PDE)
Teradata directory program(TDP)
Call level interface(CLI)
Trusted parallel application(TPA)
Virtual processors
Bynet 0 &Bynet 1
Parallism Architecture
What is fall back &where it used
Why for fall back
What is Clique
AMP Clustering
Locks & types for simultaneous Access
Why for locks &how to release
Journals &types
Virtual Disk Array
How & where is used  journals
Q & A about data recovery
Types of indexes in Teradata
Hash index
Join index
Primary index(unique, non- unique)
Secondary index(unique, non- unique)
Keys & indexes (How & why these used)
Hash algorithm
Row hash
Hash map
Hash bucket
Receiving VDisc
SQL  fundamentals
Data types and literals
DDL Statements
DML Statements
Teradata naming conversing
String functions
Format functions
Cast functions
Cast functions
Group & Aggregation functions
Logical operations
Arithmetic operations
set operations
join operations
conditional expressions
hash join
merge join
nested join
product join
inner join
left & right outer join
full outer join
Collect statistics
Types of tables
Stored procedures
Permanent spaces
Temporary spaces
Spool spaces
Users spaces & PWD
Batch mode
BTET mode
ANSI mode
How Converted into others
Usage of  PMON
Explain usage
Collecting statistics
SQL tuning
Various SQL statements
Real time Issues & resolving
Overview of BTeq
Looping stages
Batches scripts
Import &export scripts with Examples
Error handling
Real time scripts
Types of phages & how to find it
Advantages & its process
Limitations of fast load
Real time scripts
Overview of Multi load
Types of phages in MultiLoad
Advantages & its process
Limitations of MultiLoad
Uses various types of operations
Teradata SQL Assistant(Quarryman)
Teradata performance monitor
Teradata Administrator usage
Teradata performance tuning on scripts
Covering DBA concepts
Concentration on performance tuning
Real time scenarios
Certification guidance
Resume preparation
Sample resumes
Interview & certification FAQS
How to face the interview
Class notes which is useful for who is trying for job
Project preparation
Contact us today at info@techflames.com or call us at +91-9100947004.