Courses

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

live Chat