Tera data Online Training Online Training

Tera Data Online Course Content

Teradata Architecture and Components

  • PDE(Parallel Data Extension)
  • Vprocs (virtual processors)
  • PE (Parsing Engine)
  • AMP (Access Module processing)
  • Board less Bynet
  • TDP (Teradata Directory Program)
  • CLI (Call Level Interface)
  • TPA (Trusted parallel Application)
  • Going in depth by explaining the process of SQL statement execution

Various Architecture

  • Node Architecture (shared nothing)
  • SMP Architecture
  • MPP Architecture
  • Parallelism Architecture
  • Benefit & types

Data Recovery and Protection

  • Object Locks-Various locks for simultaneous access
  • RAIDI
  • RAIDI5
  • Disk Arrays
  • Fall Back
  • Clique
  • AMP Clustering
  • Journals

Teradata Storage and Retrieval Architecture

Request processing

  • Syntaxer
  • Resolver
  • Security Module
  • Optimizer
  • Step Generator
  • GNC Apply
  • Dispatcher

Primary index

  • Hash algorithm
  • Row hash
  • DSW
  • Hash Map
  • Hash Bucket
  • Reaching Vdisk

Teradata 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
      • Fundamentals
      • Data Types and Literals
      • Data Definition Statements
      • Data manipulation statements
      • String functions
      • Format functions
      • Cast functions
      • Group & Aggregate functions
      • With & with by clauses
      • Implicit Transaction
      • Explicit Transaction
      • Explain Usage
      • Collection Statistics
      • Tuning SQL Performance
      • Usage of PMON
      • Inner Join
      • Left Outer Join
      • Right Outer join
      • Full Outer Join
      • Product join
      • Merge Join
      • Hash Join
      • Nested join
      • HELP
      • SHOW
      • EXPLAIN
      • COLLECT STATISTICS
      • Tables
      • SET table
      • Multi Set table
      • Volatile tables
      • Global Temporary tables
      • Derived tables
      • Views
      • Macros
      • Stored procedures
      • Triggers
      • PERM space
      • SPOOL space
      • TEMPORARY space
      • Teradata user and managing.
      • BTET
      • ANSI
      • Interactive
      • Batch
      • Batch Scripts with samples
      • Branching and Looping
      • Importing data through scripts
      • Exporting data through scripts
      • Session Control Command Set
      • Error handling.
      • Various Phases of Fast Load
      • Advantages and Process
      • Limitations of Fast Load
      • Sample scripts
      • Various Phases of Multi load
      • Limitations of Multi Load
      • Working with multiple tables
      • Applying various operations
      • Sample Scripts

Teradata Sql Reference

Teradata Functions and Operators

Teradata Transactions

Performance Tuning and Explain Utility

Joints & Unions

Join strategies

Teradata Basic Commands

Teradata objects

Teradata spaces

Teradata Transaction Modes

Load and Unload Utilities & Tools

      Teradata Sql Assistant (Queryman)

      Teradata Performance Monitor

    Teradata BTEQTeradata Fast loadTeradata Multi Load