Teradata Online Training

Teradata Online Training

Teradata Warehouse and Competitiveness

  • What is Teradata-RDMBS?
  • Teradata 12 Vs other version.
  • Teradata History.
  • Teradata in the Enterprise.
  • Teradata users &scalability.
  • Teradata competitiveness’ with other RDBMS
  • Oracle, Sql Server etc.
  • Teradata warehouse.
  • Discussion on interview and
  • Certification questions.

Teradata Architecture and Components

  • PDE(Parallel Data Extension)
  • Vprocs(Virtual Processors)
  • PE(Parsing Engine)
  • Amp(Access Module Processing)
  • Board Less Bynet
  • TDT(Teradata Directory Program)
  • CLI(Call Level Interface)
  • Tap(Trusted Parallel Application)
  • Going in Depth by Explaining The Processor
  • SQL Statement Execution.

Various Architectures

  • Node Architecture (Shared Nothing)
  • SMP Architecture
  • MPP Architecture
  • Parallelism Architecture
  • Benefit & Types

Data Recovery And Protection

  • Object Locks
  • Various locks for simultaneous access
  • RAID1
  • RAID5
  • Disk Arrays
  • Fall Back
  • Clique
  • AMP Clustering
  • Journals
  • Recovery Journal
  • Transient Journal
  • Before Journal
  • After Journal
  • Answering Various Recovery Questions.

Teradata Storage And Retrieval Architecture

  • Request Processing
  • Syntaxes
  • Resolver
  • Security Module
  • Optimizer
  • Step Generator
  • GNC Apply
  • Dispatcher
  • Primary Index
  • Hash Algorithm
  • Row Hash
  • DSW
  • Hash Map
  • Hash Bucket
  • Reaching Vdisk

Teradat Indexes

  • Primary Index
  • Unique
  • Non Unique
  • Partitioned
  • Secondary Index
  • Unique
  • Non Unique
  • Hash, Join, Value Ordered
  • Skewness
  • Secondary Index Sub Table
  • Accessing Records Via Primary Index
  • Accessing Records Via Secondary
  • Index
  • Keys Vs Indexes
  • Full Real Time Scenarios and Explaining.

 

Teradat a Sql Reference

  • Fundamentals
  • Data Types and Literals
  • Data Definition Statements
  • Data Manipulation Statement
  • Explaining with Proper Examples.

Taradata Functions and Operators

  • String Function
  • Format Function
  • Cast Functions
  • Group & Aggregate Functions
  • With & With by Clauses
  • Practices of This Section.

Taradata Transactions

  • Implicit Transaction
  • Explicit Transaction

Performance Tuning and Explain Utility

  • Explain Usage
  • Collecting Statistics
  • Tuning SQL Performance
  • Usage of PMON
  • Explaining Various SQL Statements.

Joins & Unions

  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Detailed Explanation.

Join Strategies

  • Product Join
  • Merge Join
  • Hash Join
  • Nested Join
  • Questions of Section.

Teradata Basic Commands

  • HELP
  • SHOW
  • EXPLAIN
  • COLLECT STATISTICS

Taradata Objects

  • Table
  • Set Table
  • Multi Set Table
  • Volatile Temporary Tables
  • Derived Tables
  • Views
  • Macros
  • Stored Procedures
  • Triggers
  • Practices and FAQs of This Session.

Teradata Spaces

  • Perm Space
  • Spool Space
  • Temporary Space
  • Teradata User and Managing.
  • Practical

Teradata Transaction Modes

  • BETET
  • ANSI
  • INTERACTIVE
  • Batch

Load And Unload Utilities & Tool

  • Tear Data Sql Assistant (Query man)
  • Teradata Performance Monitor
  • Teradata BTEQ
  • Batch Scripts with Samples.
  • Branching and Looping
  • Importing Data Through Scripts.
  • Exporting Data Though Scripts.
  • Session Control Command Set
  • Error Handling.

Explanation with Proper Debugging.

  • Teradata Fast Load
  • Various Phases of Fast Load
  • Advantages and Process.
  • Limitations of Fast Load
  • Sample Scripts.

Real Time Issues and Resolving It.

  • Teradata Multi Load
  • Various Phases of Multi Load
  • Limitations of Multi Load
  • Working with Multiple Tables
  • Appling Various Operations.
  • Sample Scripts

Real Time Issues and Solving It.

  • Teradata Parallel Data Pump
  • Limitations of TPump
  • Overview of TPump
  • Sample Scripts
  • Teradata Fast Export
  • Exporting Data
  • Passing Parameters
  • OUTMODS
  • Sample Scripts.
  • Utility Vs Parallelism.