Teradata Training at @ elegant it services – Bangalore.

Teradata Class Room / Online Training From Elegant IT Services at Marthahalli,Bangalore:9886541264

Elegant IT Services is a proficient training institute that provides the best and unique training to students, so that, they are ready for work with the company.
Attend Free Demo Classes & Experience the Quality of Training.
We also provide training on different modules of SAP both ONLINE and CLASSROOM TRAINING with an expert ready to provide you training at your time and availability.
Teradata course Content
Foundation
• What is Teradata?
• Teradatav12 & versions Other versions
• Overview OF Teradata
• Teradata warehouse
• Teradata in the Enterprise
• Teradata Users & Scalability
• interview Q&A and Certification queries
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
• Trasient Journal
• Permanent Journal
• Before Journal
• After Journal
• How & where is used journals
• Answering various recovery questions
Teradata Indexes
• Primary Index
• Unique
• Non unique
• Partitioned
• Secondary Index
• Unique
• NonUnique
• Hash, Join, Value Ordered
• Skewness
• Secondary Index Sub table
• Accessing Records via Primary Index
• Accessing records via Secondary Index
• Keys Vs Indexes
• Full Real time scenarios and explaining
Explicit Transaction
• Performance Tuning and Explain Utility
• Explain Usage
• Collecting Statistics
• Tuning SQL Performance
• Usage of PMON
• Explaining various SQL statements
• Joins and Unions
• Inner Join
• Left Outer Join
• Right Outer Join
• Full Outer Join
• Detailed explanation
• Join Strategies
• Product Join
• Merge Join
• Hash Join
• Nested Join
• Questions of this section
Teradata Basic Command
• HELP
• SHOW
• EXPLAIN
• COLLECT STATISTICS
Teradata Objects
• Tables
• SET table
• Multi Set table
• Volatile tables
• Global Temporary tables
• Derived tables
• Views
• Macros
• Stored Procedures
• Triggers
• Practices and FAQs of this session
Teradata Space
• PERM space
• SPOOL space
• TEMPORARY space
• Teradata User and managing
• Practical Example

Teradata Utilities

• Teradata Multi Load
• Various Phases of Multi Load
• Limitations of Multi Load
• Sample Scripts
• Teradata Parallel Data Pump
• Limitations of TPump
• Overview of TPump
• Sample Scripts
• Teradata Fast Export
• Fast Load

Thanks & Regards
Elegant IT Services,
#352, 2nd Floor,Aswath Nagar
Varthur main road,Near Railway Fly Over
Maratha halli,Land mark : Chemmunar Jewellers,
Bangalore - 560037.Ph:-9886541264/87