TERADATA ONLINE TRAINING

Content Of  TERADATA V13 

WHAT IS TERADATA WHY FOR IT IS WHAT FOR IT IS

• What is Teradata?

• Teradatav12 & versions

• Teradata History

• Teradata users scalability

• Teradata &other RDBMS

• Teradata warehouse

• Teradata in the Enterprise

• Interview Q&A and Certification queries

• Real time Issues & resolving 

TERADATA ARCHITECTURE & IT’S COMPONENTS

• Node Architecture(Shared Architecture)

• SMP Architecture

• MPP Architecture

• Parsing engine(PE) Architecture

• AMP Architecture &uses

• Bynet Benefits &types

• Parallel data extension(PDE)

• Teradata directory program(TDP)

• Call level interface(CLI)

• Trusted parallel application(TPA)

• Virtual processors

• Bynet 0 &Bynet 1

• Parallism Architecture

RECOVERY &PROTECTION OF DATA

• What is fall back &where it used

• Why for fall back

• What is Clique

• AMP Clustering

• & types for simultaneous Access

• Why for locks &how to release

• RAID 1 &RAID 5

• Journals &types

• Virtual Disk Array

• How & where is used  journals

• Q & A about data recovery

TERADATA INDEXES

• Types of indexes in Teradata

• Hash index

• Join index

• Primary index(unique, non- unique)

• Secondary index(unique, non- unique)

• Skewness

• Keys & indexes (How & why these used)

HOW TO STORAGE & RETRIEVAL OF DATA

Hash algorithm

• hash

• Hash map

• Hash bucket

• Receiving VDisc

Day2

TERADATA SQL QUARRYMAN

• SQL  fundamentals

• Data types and literals

• DDL Statements

• DML Statements

• Teradata naming conversing

TERADATA SQL FUNCTIONS & OPERATIONS

• String functions

• Format functions

• Cast functions

• Cast functions

• Group & Aggregation functions

• Logical operations

• Arithmetic operations

• Set operations

• Join operations

• Conditional expressions

Day 3

TERADATA JOIN STRATEGIES & UNIONS

• Hash join

• Merge join

• Nested join

• Product join

• Inner join

• Left & right outer join

• Full outer join

TERADATA BASIC COMMANDS

• Help

• Show

• Explain

• Collect statistics

TERADATA OBJECTS

• Types of tables

       § Set tables

       § Multi tables

       § Volatile tables

       § Global temporary tables

       § Derived tables

• Views

• Macros

• Stored procedures

• Triggers

TERADATA MEMORY SPACES

• Permanent spaces

• Temporary spaces

• Spool spaces

• Users spaces & PWD

TERADATA TRANSACTION MODES

• Batch mode

• BTET mode

• ANSI mode

• How Converted into others

Day4 and 5

TERADATA PERFORMANCE TUNING ON SQL ASSISTANCE

• Usage of  PMON

• Explain usage

• Collecting statistics

• SQL tuning

• Various SQL statements

• Real time Issues & resolving   

TERADATA UTILITIES & TOOLS (IMPORT & EXPORT)

• Teradata BTeq scripts

• Teradata FastLoad

• Teradata MultiLoad

• Teradata Tpump

• Overview of BTeq

• Looping stages

• Batches scripts

• Import &export scripts with Examples

• Error handling

• Real time scripts

• Types of phages & how to find it

• Advantages & its process

• Limitations of fast load

• Real time scripts

• Overview of Multi load

• Types of phages in MultiLoad

• Advantages & its process

• Limitations of MultiLoad

• Uses various types of operations

• Work on Multi tables

• Real time scripts

• Sample scripts

• Overview of Tpump

• Limitations of Tpump

• Work on Multi tables

• Teradata Fast Export

• Teradata SQL Assistant(Quarryman)

• Teradata performance tuning on scripts

• Real time scripts

• Sample scripts

• How to export the data

• Passing parameters

• IN/OUT Modes

• Work on Multi tables

• Real time scripts

• Sample scripts