Course #: 12035e - Teradata V13 Datawarehousing

What is Teradata and what is it used for?

•     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
•     Locks & 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
•     Row 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
•     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 FastLoad

•         Types of phages & how to find it
•         Advantages & its process
•         Limitations of fast load
•         Real time scripts

Teradata MultiLoad

•         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

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(Quarryman)

Teradata performance monitor

Teradata Administrator usage

Teradata performance tuning on scripts

Recommended Prerequisites:

• There are no mandatory prerequisites. Work experience in IT services is recommended.