For Online Training Aspirants (With Placement)

Name :

Email :

Phone :

Message :


Courses

Tera data Online Training Online Training

Tera data Online Training Online Training Course Content

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

 

FAQ
© Copyright 2013 Tectist., All rights reserved