space
Search Courses  in 

Just fill this form to get COURSE FEE details from BEST Training Institutes Instantly !

 

My City

 

I need details for

 

My Name

My Mobile Number

My Email ID

Purpose

Tell us your expectation...

Teradata training course content

 

Teradata Course content




Introduction:


» 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


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


Implicit Transaction


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 Commands


» 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 spaces


» PERM space
» SPOOL space
» TEMPORARY space
» Teradata User and managing
» Practical Examples


Teradata Transaction Modes


» BTET
» ANSI
» Interactive
» Batch


Teradata Sql Assistant(Queryman)


» 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


Real time Issues and solving it


» Teradata Parallel Data Pump
» Limitations of TPump
» Overview of TPump
» Sample Scripts
» Teradata Fast Export
» Exporting Data
» Passing Parameters
» OUTMODS
» Sample Scripts
» Utility Vs Parallelism


Below you can find city wise Teradata Institutes


Teradata training institutes in India

Teradata training institutes in Chennai

Teradata training institutes in Bangalore

AbnitioE training institutes in Mumbai

Teradata training institutes in Pune

Teradata training institutes in Delhi-NCR

 

16-08-2013 by Training Support

Unix Academy Delhi Training

High Technologies Solutions - Delhi,Noida,Gurgaon

Embedded Technosolutions Mumbai

SHRISTI TECHNOLOGY LABS

GRRAS Institute Ahmedabad Jaipur Pune

Sun Infosystems Surat

Indian Institute of Technocrafts, Kolkata

7 Eleven Arthashastra Chennai

Best Oracle PHP Java Training chennaiCareer Innovation Technologies Velachery

Core Mind Technologies Chennai

Mazenet SolutionAMEKS Infotech Ekkattuthangal, Chennai

RIA Institute of Technology Bangalore

IIHT Bangalore

IIHT Vadapalani Chennai

JITS Training

IICT Chrompet - SAP Training in ChennaiPMP Training in India

HB Services Adyar Training InstituteITBMS chennai Best Training Institute

Systems Domain Bangalore

HITS computer Education chennai

Peridot Systems Chennai

vgit kilpauke learning, e-publishing, technical writting courses

Dallas Technologies Bangalore

Training course fee & Discounts

 

 

   DMCA.com Protection Status