Course Duration in Hours
72
72
TERADATA COURSE CONTENT
Introduction
What is Teradata?
Teradatav12 & versions Other versions
Overview OF Teradata
Teradata warehouse
Teradata in the Enterprise
Teradata Users & Scalability
Teradata Architecture and Components
Teradata Architecture
SMP Architecture
MPP Architecture
AMP(Access Module Processing)
TDP(Teradata Directory Program)
CLI(Call Level Interface)
TPA(Trusted Parallel Application)
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
Transient Journal
Permanent Journal
Before Journal
After Journal
Teradata Sql Assistant (Query man)
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
BE - CS, IT, BTech, ME-CS, IT, MTech, BCA, MCA, BSc. CS, IT, Any Degree
Satori Technologies and Solutions Private Limited, Velachery (Chennai),Chennai,IN