Teradata Course Content

Teradata Course Curriculum
 
   Overview of the TERADATA

• 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

• Real time Issues & resolving

• 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

  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

   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

   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

• Overview of BTeq

• Looping stages

• Batches scripts

• Import &export scripts with Examples

• Error handling

• Real time scripts

• Teradata Fast Load

• Types of phages & how to find it

• Advantages & its process

• Limitations of fast load

• Real time scripts

• Teradata Multi Load

• Overview of Multi load

• Types of phages in Multi Load

• Advantages & its process

• Limitations of Multi Load

• Uses various types of operations

• Work on Multi tables

• Real time scripts

• Sample scripts

• Teradata Tpump

• Overview of Tpump

• Limitations of Tpump

• Work on Multi tables

• Real time scripts

• Sample scripts

• Teradata Fast Export

• How to export the data

• Passing parameters

• IN/OUT Modes

• Work on Multi tables

• Real time scripts

• Sample scripts

• Teradata SQL Assistant (Quarry man)

• Teradata performance tuning on scripts