Teradata Training Institute in Chennnai - Peridot

18/09/2014 Professional & Short Term Course

Price: Free

No image available

Description

PERIDOT SYSTEMS is best Training Institutes in chennai with Placement


Real Time Training

Free Demo Classes

Real Time MNC Working Faculty


Peridot is proud to introduce job oriented IT Training courses with globally accredited certification on all platforms that have wider scope in the existing IT Job Market. These platforms are picked after a thorough research and analysis based upon the existing and prospective IT industry in mind.


Introduction:



  • What is Teradata

  • Overview Of Teradata

  • Data warehouse concepts


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



  • locks

  • RAID 1&RAID 5

  • Disk Arrays

  • Fall Back

  • Clique

  • AMP Clustering

  • Journaling

  • 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


Teradata Sql Reference



  • SQL Fundamentals

  • Data Types and Literals

  • Data Definition Statements(DDL)

  • Data Manipulation Statements(DML)

  • Explaining with proper examples


Teradata Functions and Operators



  • String Functions

  • Format Function

  • Cast Functions

  • Group & Aggregate Functions

  • With & with by clauses

  • Practices of this section


Teradata Transactions



  • Joins and Unions

  • Inner Join

  • Left Outer Join


 


For More Details,


Visit Our Website: www.peridotsystems.in


Venue:


Kamatchi Krupa Apts,
No: 84/8, Ground Floor,
Venkatarathinam main street,
Venkatarathinam Nagar,
LB Road, Adyar, Chennai,


Tamil Nadu – 600020


Selvakumar – 9952010141

More Details

Total Views:6
Reference Id:#473108
Current Rating: /5 0 Vote
Copyright © 2018 |   All Rights Reserved |   tuffclassified.com |   24x7 support |   Email us : info[at]tuffclassified.com