space
Search Courses  in 

Get CourseName COURSE FEES Instantly from BEST Training Institutes!

 

My City

I need details for

 

My Name

My Mobile Number

My Email ID

teradata training institute in chennai adyar

 

Greens Technologys
Greens Technologys

 

 

Information

Get trained by Teradata real professionals having 10 years MNC experience

If you are planning to attend interviews or struggling in live projects, don’t 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.

About myself
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
Various Architecture
• Node Architecture (shared nothing)
• SMP Architecture
• MPP Architecture
• Parallelism Architecture
• Benefit & types
Data Recovery and Protection
• Object Locks-Various locks for simultaneous access
• RAIDI
• RAIDI5
• Disk Arrays
• Fall Back
• Clique
• AMP Clustering
• Journals
Teradata Storage and Retrieval Architecture
• Request processing
• a. Syntaxer
• b. Resolver
• c. Security Module
• d. Optimizer
• e.Step Generator
• f. GNC Apply
• g. Dispatcher
Primary index
• 1.Hash algorithm
• 2. Row hash
• 3. DSW
• 4. Hash Map
• 5. Hash Bucket
• 6. Reaching Vdisk
Teradata Indexes
• Primary Index
• Unique
• Non unique
• Partitioned
• Secondary Index
• Unique
• Non unique
• Hash, Join, Value Ordered
• Skewness
• Secondary Index Sub table
• Accessing Records via primary index
• Accessing records via Secondary index
• Keys vs indexes
Teradata Sql Reference
• Fundamentals
• Data Types and Literals
• Data Definition Statements
• Data manipulation statements
Teradata Functions and Operators
• String functions
• Format functions
• Cast functions
• Group & Aggregate functions
• With & with by clauses
Teradata Transactions
• Implicit Transaction
• Explicit Transaction
Performance Tuning and Explain Utility
• Explain Usage
• Collection Statistics
• Tuning SQL Performance
• Usage of PMON
Joints & Unions
• Inner Join
• Left Outer Join
• Right Outer join
• Full Outer Join
Teradata Basic Commands
• HELP
• SHOW
• EXPLAIN
• COLLECT STATISTICS
Teradata objects
• Tables
• 1. SET table
• 2. Multi Set table
• 3. Volatile tables
• 4. Global Temporary tables
• 5. Derived tables
• Views
• Macros
• Stored procedures
• Triggers
Teradata spaces
• PERM space
• SPOOL space
• TEMPORARY space
• Teradata user and managing.
Teradata Transaction Modes
• BTET
• ANSI
• Interactive
• Batch
Load and Unload Utilities & Tools
• Teradata Sql Assistant (Queryman)
• Teradata Performance Monitor
• Teradata BTEQ
• 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

 

Course Information

Teradata

 

Contact Information

Address: Greens Technologys,
1, First Street, Padmanabha nagar, Adyar
, Chennai , Adyar
PH: 044-43511623 , 8939924320 / 9840496320/ 9940516384
Website: www.greenstechnologys.com
Email: greens.adyar@yahoo.com
laureola solutions Chennai

 

Peridot Systems Chennai

 

Prolific Training India Plc Training

 

Talhunt TTA Training center insitute in Chennai

 

Core Mind Technologies Chennai Chennai

 

CADD School Vadapalani

 

Besant technologies chennaiThink up computer institute chennai

 

IICT Chrompet - SAP Training in ChennaiSatori Technologies Chennai

 

vgit kilpaukHB Services Adyar Training Institute

 

Credo Systemz VelacheryiSpark institute, Chennai

 

sap training institutes in chennaiITBMS chennai Best Training Institute

 

7 Eleven Arthashastra Chennai

 

IIHT Vadapalani Chennai

 

HITS computer Education chennai

 

HCL Learning Velachery Chennai

 

Training course fee & Discounts

 

 

 

 

   DMCA.com Protection Status