Types of tables
o Set tables
o Multi tables
o Volatile tables
? Global temporary tables
? Derived tables
Views
Macros
Stored procedures
Triggers
TERADATA MEMORY SPACES
Permanent spaces
Temporary spaces
Spool spaces
Users spaces & PWD
TERADATA MEMORY SPACES
Permanent spaces
Temporary spaces
Spool spaces
Users spaces & PWD
TERADATA TRANSACTION MODES
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
o Overview of BTeq
o Looping stages
o Batches scripts
o Import &export scripts with Examples
o Error handling
o Real time scripts
Teradata FastLoad
o Types of phages & how to find it
o Advantages & its process
o Limitations of fast load
o Real time scripts
Teradata MultiLoad
o Overview of Multi load
o Types of phages in MultiLoad
o Advantages & its process
o Limitations of MultiLoad
o Uses various types of operations
o Work on Multi tables
o Real time scripts
o Sample scripts
Teradata Tpump
o Overview of Tpump
o Limitations of Tpump
o Work on Multi tables
o Real time scripts
o Sample scripts
Teradata Fast Export
o How to export the data
o Passing parameters
o IN/OUT Modes
o Work on Multi tables
o Real time scripts
o Sample scripts
Teradata SQL Assistant(Quarryman)
Teradata performance monitor
Teradata Administrator usage
Teradata performance tuning on scripts
KEY SERVICE
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
Customer Care - USA: 703-738-9900 
