TERADATA V13 Developer

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
•  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
•  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