Best Teradata Training Institute in Hyderabad (Dev & DBA).Best Teradata Online Training.

VINAYTECHHOUSE Offers Best Teradata Class Room Training and Teradata Online Training with detailed subject, real time case studies and projects. Best TERADATA ONLINE training with more visual and detailed explanation. Incomparable with other institutes in terms of Subject, Support and Classes. Exclusive Teradata Project classes make students comfortable in the real time. Contact on 9573168449/04066638869 for class room,online, fast track, week-end and one on one sessions.

Sunday 28 August 2016

TERADATA DEV & TERADATA DBA ADVANCED CLASS ROOM / ON LINE TRAINING WITH PROJECTS

DEDICATED INSTITUTE FOR TERADATA CLASS ROOM TRAINING, TERADATA ONLINE TRAINING, FAST TRACK,WEEK-END AND ONE ON ONE SESSIONS.

Course	Type(Online, Class Room)	Schedule
Teradata Dev	Both	22- Feb 7AM-8AM
Teradata DBA	Both	24-Feb 8PM-9PM
Teradata Dev	Both	26-Feb 9AM-10AM
Teradata DBA	Both	26-Feb 7PM-8PM
Register: Call us on 9573168449 / drop a message to vinaytechhouse.info@gmail.com Week-End, One on One and Support reach us directly [Call or Email] Teradata Viewpoint and Teradata Latest Topics covered detail with Projects

Teradata Development Training and Teradata DBA Training with Real Time Projects and Case Studies.Detailed subject and creatively designed course material.Huge success and track record, and direct recruitment in the corporate companies.

ONLY INSTITUTION PROVIDING GOOD REAL TIME PROJECTS FOR TERADATA.
Vinaytechhouse offers the below projects during class hours.

Banking project includes FSLDM (Financial Services Logical Data Model)
Telecom project includes CLDM (Communications Logical Data Model)
Retail project in Galaxy Schema Model

Why VinayTechHouse?

Completely Practical, Real-time and Project Oriented.

Suitable for Freshers,Experienced and Advanced Technical Professionals

Session wise Handouts,Tasks and Solutions

One Real-time Project explanation for Interview Guidance & Certification

Resume Preparation & Project Specification

Broad and detail subject with practicals and case-studies

Corporate companies direct recruitment for freshers and experienced.

TERADATA CLASSES MODES

TERADATA CLASSROOM TRAINING
TERADATA ONLINE TRAINING
TERADATA FAST TRACK TRAINING
TERADATA ONE ON ONE TRAINING
TERADATA WEEK-END TRAINING

TERADATA COURSE DETAIL CONTENT

Read "TERADATA_DEV_SYLLABUS" / "TERADATA_DBA_SYLLABUS" TABS

TERADATA DEVELOPMENT SYLLABUS

(TERADATA PART-1: DATABASE & SYSTEMS)

1)Teradata Warehouse and Competitiveness

v Opportunities of Teradata in the enterprise.

v What is Teradata-RDBMS/DWH & BI?

v Teradata 15 & Other versions( 14,13.10,13,12)

v Teradata History and Real time running versions.

v Teradata View Point Features (Web based management tool) ***.

v Descriptions on Golden Gate and Data Mover***

v Teradata competitiveness’ and differences with other RDBMS

Discussion on Interview and Certification questions

2)Teradata Single ,Multi and Cloud System

v Node Architecture(Shared Nothing)

v SMP Architecture

v MPP Architecture

v Cloud Architecture (Teradata 14)

v Discussion on real time no of AMPs and Nodes

Real time Project Configurations

3)Teradata Components and Explanation

v PDE(Parallel Data Extension),

v Vprocs (Virtual Processors)

v TPA (Trusted Parallel Application)

v PE(Parsing Engine)

v AMP(Access Module Processing)

v BYNETs (Board less, Board Oriented)

v TDP (Teradata Directory Program)

v CLI(Call Level Interface),

v VSS (Virtual Storage System)***

Discussion on Certification & Interview questions

Discussion on various organizations configurations.

4)Teradata Storage and Retrieval Architecture

Request Processing

v a. Syntaxer b. Resolver

v c. Security Module d. Optimizer

v e. Step Generator f. GNC Apply g. Dispatcher

Hashing approach

v Hash algorithm, Row Hash, Row ID

v DSW, Hash Map , Hash Bucket, Reaching Vdisk

5) Teradata Indexes (Primary, Secondary)

Primary Index

v Unique Primary Index (UPI)

v Non Unique Primary Index (NUPI)

v Partitioned Primary Index (PPI) (Range_N, Case_N, Multi Valued PPI ***)

v NOPI (No Primary Index)***

v Full Uniform Distribution vs Skewed distribution.

v Skewness and Skewfactor

Secondary Index

v Unique Secondary Index (USI)

v Non Unique Secondary Index(NUSI)

v Value Ordered Secondary Index (VOSI)

v Hash Index (HI)

v Join Index (JI) and Types

Full Table Scan(FTS) - Execution process

Diagrammatic explanation, syntaxes and practical.

Performance improvement indexes and tuning them.

TERADATA PART-2: TERADATA-SQL)

1) Teradata Server, Client and Pre-requisites

v Server start, stop, pause in Linux & Windows

v Client tools to operate [GUI, Wizard, CUI]

v Teradata Sql-Assistant, BTEQ, Query Studio

v Open Database Connectivity (ODBC), OLEDB

v Working with Sql-Assistant, BTEQ

v Transaction Modes [BTET, ANSI]

v Single, Multi Statement request operations

v Command, Query and Request Processing

Practical on this with case studies

2) Teradata DBA concepts

v Databases creation, manipulation and removal

v Users creation, manipulation and removal

v Memory management (Spool, Perm and Temp)

v Privileges management

v Working with other memory areas

v Working on DDL commands to implement

v Working with Teradata Administrator tool

v Working on ViewPoint Portal (Optional)

3) Teradata SQL Languages

v Data Definition Language (DDL)

v Data Manipulation Language (DML)

v Data Control Language (DCL)

v Stored Procedure Language (SPL)

v ANSI commands (COMMIT,ROLLBACK,ABORT)

v Teradata Extensions a. HELP b. SHOW c. EXPLAIN d. COLLECT STATISTICS

4) Data Manipulation Language (DML)

v Retrieval of data from objects (SELECT)

v Manipulation of data from objects

(Insert, Update, Delete, Merge, Upsert)

Real time usages and detailed practices

8) Other Components of table

v Data Types (ANSI, Teradata)

v Data Type Attributes

v Column Storage Attributes(COMPRESS)

v COMPRESS (Block, Row, Column)

v Constraints

o Primary / Unique / References / Check

v Soft Referential Integrity(SOFT RI)

v COLUMNAR FEATURE

Real time practices and performance improvements

9) Teradata Transactions

v Implicit & Explicit Transaction

v Interactive & Batch Modes

Semantic Modes a. BTET b. ANSI

10) Conditional Expressions and Operators

v Conditional Expressions (IN,NOT IN,LIKE, EXISTS,

BETWEEN AND, IS NULL etc…)

v Arithmetic Operators and order of precedence

v Logical Operators and order of precedence

v Conditional Operators and order of precedence

11) Teradata Other Objects

v Sub Queries :Simple , Nested & Correlated

v Set Operations :Union , Union All ,Intersect , Except

v Joins : Cross ,Inner ,Left ,Right and Full Joins

Detailed discussion on Real Time Queries and Tips

v Views

v Macros

v Stored Procedures

v Triggers

v Cursors

Detailed discussion on Real Time Queries and Tips.

5) Data Definition Language (CREATE, ALTER, DROP)

v Create/alter table with all possible options (Free space, Data Block Size)

Create different types of tables

v Set table

v Multi Set table

v Derived table

v Volatile table (VT)

v Global Temporary table (GTT)

v Error table (ET)

v Queue

v System Calendar

v Temporal tables(TD 14)***

i. Valid Time ii. Transaction Time iii. Bi Temporal

Real time usages and detailed practices

6) Data Control Language (DBA Related Concepts)

v GRANTing privileges (GRANT)

v REVOKing privileges (REVOKE)

v GIVing Privileges (GIVE)

Real time usages and detailed practices

7) Locks, Data Recovery and Protection

v Object Locks -Access, Read, Write, Exclusive, Hut

v NO Wait ,Pseudo table lock

v HSA,HSN (Hot Stand By AMP,NODE)

v RAID1 ,RAID5 , Disk Arrays

v Fall Back , AMP Clustering

v Clique

v Images (Single , Dual , Before, After)

v Journals ( Recovery , Transient and Permanent Journals ,Write ahead logging)

12) Teradata Functions

Niladic Functions

Table Functions

Scalar Functions

Aggregate Functions

Oracle functions in Teradata

Otranslate, Greatest, Decode, NVL, Lpad etc…

ETL(Normal )Functions :

Format, Cast , Coalesce, Nullif ,Trim ,Substr, Position, Length, Chars, Upper, Lower, Sample, Random, Rank, Type, Named, Title, Index, Trim, Add_Months etc….

Advanced OLAP Functions (Ordered Analytical)

v Moving SUM/AVG/DIFF

v Cumulative SUM/AVG/DIFF

v With, With By

v Rank(), Qualify

v Row_Number(), Qualify

v Format

v Extract

v Top

v Csum

Detailed discussion on Real Time Queries and Tips

13) Teradata Performance Tuning

v Explain Request Modifier(EXPLAIN PLAN)

v Collecting Statistics, Confidence Levels (High, ,Low, NO, JOIN), DIAGNOSTICS HELP STATS

v Tuning SQL Queries & Utilities

v Usage of PMON, Index & Statistics wizards

v Various Indexes (Hash, Join ),

v Teradata Join Strategies (Merge, Product ,Nested ,Row hash)

v Skew Factor, Skewness and remedies

v Spool space Issues

v System Level Bottlenecks identification.

(TERADATA PART-3: UTILITIES [ETL & ADMIN] )

Load and Unload Utilities & Tools

1) Teradata SQL ASSISTANT (SQLA)

v Import and Export data

v Working on various Options

2) Teradata BTEQ

v Features, Command Sets, Modes, Formats

v Scripts with Fixed, Vartext and Report.

v Branching and Looping

v Load/Un Load with ETL operations

v Multi Statement Requests **

v Table –Table data loading

v Exception handling and examples

Questions and error handling

3) Teradata FASTLOAD

v Features, Phases and Limitations of Fast Load

v Advantages , Process, Error tables

v Working with Fixed and Variable text scripts.

v Real time Issues and resolving it.

Questions and error handling

4) Teradata MULTILOAD

v Features, Phases ,Limitations of Multi Load

v Tables and Tasks in Multi Load

v INSERT/UPDATE/DELETE/UPSERT/RELEASE

v SCDs implementation(Type1, Type2, Type3)

v Multi file and Multi table loading

v Real time Issues and solving it.

Questions and error handling

5) Teradata TPUMP

v Features, Limitations, Process of TPump

v Diff between MLOAD and Tpump

v SCDs Implementation(Type1,Type2, Type3)

Real time & Sample scripts, Issues Resolution.

6) Teradata FASTEXPORT

v Features, Process ,Limitations

v Exporting data to Single, Multiple tables

v Passing Parameters (Internal, External)

Real time usages & scripts.

7) TPT (Teradata Parallel Transporter) & TPT API

v Load, Export, Update, Stream Operators

v TPT Streaming Process

v TPT Wizard Implementation

v Implementing LOAD operator with multiple examples

v Implementing UPDATE operator with multiple examples

v Implementing STREAM operator with multiple examples

v Implementing FILTER operator with multiple examples

v Implementing STANDALONE operator with multiple examples

v Implementing Data Connector Operator

v Sessions and Instances

Real time usages & scripts and recommendations

8) Teradata OLELOAD

Moving data between Heterogeneous Sources
(Flat Files, Excel Files and Databases)

9) Teradata other utilities and tools (over view)

v Teradata Backup Archive and Recovery Solutions

v Teradata Performance Monitor (PMON)

v TERADATA Administrator

v TERADATA Index WIZARD

v TERADATA statistics wizard

v Teradata System Emulation tool (TSET)

v Teradata Viewpoint (portals and portlets)

Teradata course fee
Teradata
Teradata training institute
Teradata training in hyderabad
Teradata course
Teradata development training
Teradata course details
Teradata Training Institute in Hyderabad Hyderabad Telangana
Teradata course fee in hyderabad
Teradata training
Teradata Online training
Best Teradata Training institute
Teradata training inistitutes in ameerpet
Best Teradata Online training
Teradata courses
Teradata classes in hyderabad
Teradata online classes
Teradata DBA training