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
  1.  TERADATA CLASSROOM TRAINING
  2.  TERADATA ONLINE TRAINING
  3.  TERADATA FAST TRACK TRAINING
  4.  TERADATA ONE ON ONE TRAINING
  5.  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
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