Get trained by Teradata real professionals having 10 years MNC experience
If you are planning to attend interviews or struggling in live projects, dont waste any time. Call me on.
We are the Leading Teradata real time training institute in Chennai.
We offer best Teradata training with real-time study material.
We can guarantee a class that makes you as a Teradata professional
Best Teradata training in Chennai, Adyar by Teradata Consultant working in CTS
My training tends towards real time requirement as well as interview / certification point of view.
I work as a Senior Database Consultant for a Leading MNC in Chennai with 9+ years experience in both software development and training.
Qualification: B.E., MIS (USA), PMP
My training benefits
my batch sizes are generally very small size 3-4 members OR 1 to 1 also, so students receive direct, hands-on training from us.
100% practical training only.
Installation of software s in your desktop / laptop will be done.
Please reach out to me for any further clarification.
Fast track available | Weekend / Weekdays Classes Available
Teradata Course Content
Teradata Architecture and Components
PDE(Parallel Data Extension)
Vprocs (virtual processors)
PE (Parsing Engine)
AMP (Access Module processing)
Board less Bynet
TDP (Teradata Directory Program)
CLI (Call Level Interface)
TPA (Trusted parallel Application)
Going in depth by explaining the process of SQL statement execution
Node Architecture (shared nothing)
Benefit & types
Data Recovery and Protection
Object Locks-Various locks for simultaneous access
Teradata Storage and Retrieval Architecture
c. Security Module
f. GNC Apply
2. Row hash
4. Hash Map
5. Hash Bucket
6. Reaching Vdisk
Hash, Join, Value Ordered
Secondary Index Sub table
Accessing Records via primary index
Accessing records via Secondary index
Keys vs indexes
Teradata Sql Reference
Data Types and Literals
Data Definition Statements
Data manipulation statements
Teradata Functions and Operators
Group & Aggregate functions
With & with by clauses
Performance Tuning and Explain Utility
Tuning SQL Performance
Usage of PMON
Joints & Unions
Left Outer Join
Right Outer join
Full Outer Join
Teradata Basic Commands
1. SET table
2. Multi Set table
3. Volatile tables
4. Global Temporary tables
5. Derived tables
Teradata user and managing.
Teradata Transaction Modes
Load and Unload Utilities & Tools
Teradata Sql Assistant (Queryman)
Teradata Performance Monitor
a. Batch Scripts with samples
b. Branching and Looping
c. Importing data through scripts
d. Exporting data through scripts
e. Session Control Command Set
f. Error handling.
Teradata Fast load
a. Various Phases of Fast Load
b. Advantages and Process
c. Limitations of Fast Load
d. Sample scripts
Teradata Multi Load
a. Various Phases of Multi load
b. Limitations of Multi Load
c. Working with multiple tables
d. Applying various operations
e. Sample Scripts