SAP Teradata Online training By MaxMunus

Training

SAP Teradata Online training By MaxMunus

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

For Free demo class please feel free to call or email us.


Email :  surya@maxmunus.com ,  contact@maxmunus.com

Skype id : suryadk1

Phone :   +91- 9036888688, +91- 9035888988