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 |
RAID 1 &RAID 5 |
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) |
Skewness |
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 |
Help |
Show |
Explain |
Collect statistics |
Types of tables |
Views |
Macros |
Stored procedures |
Triggers |
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 |
FAQS |
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 |