TERADATA

  • 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
    • a. Syntaxer
    • b. Resolver
    • c. Security Module
    • d. Optimizer
    • e.Step Generator
    • f. GNC Apply
    • g. Dispatcher
  • Primary index
    • 1.Hash algorithm
    • 2. Row hash
    • 3. DSW
    • 4. Hash Map
    • 5. Hash Bucket
    • 6. 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
  • Teradata Sql Reference
    • Fundamentals
    • Data Types and Literals
    • Data Definition Statements
    • Data manipulation statements
  • Teradata Functions and Operators
    • String functions
    • Format functions
    • Cast functions
    • Group & Aggregate functions
    • With & with by clauses
  • Teradata Transactions
    • Implicit Transaction
    • Explicit Transaction
  • Performance Tuning and Explain Utility
    • Explain Usage
    • Collection Statistics
    • Tuning SQL Performance
    • Usage of PMON
  • Joints & Unions
    • Inner Join
    • Left Outer Join
    • Right Outer join
    • Full Outer Join
  • Teradata Basic Commands
    • HELP
    • SHOW
    • EXPLAIN
    • COLLECT STATISTICS
  • Teradata objects
    • Tables
    • 1. SET table
    • 2. Multi Set table
    • 3. Volatile tables
    • 4. Global Temporary tables
    • 5. Derived tables
    • Views
    • Macros
    • Stored procedures
    • Triggers
  • Teradata spaces
    • PERM space
    • SPOOL space
    • TEMPORARY space
    • Teradata user and managing.
  • Teradata Transaction Modes
    • BTET
    • ANSI
    • Interactive
    • Batch
  • Load and Unload Utilities & Tools
    • Teradata Sql Assistant (Queryman)
    • Teradata Performance Monitor
    • Teradata BTEQ
    • a. Batch Scripts with samples
    • b. Branching and Looping
    • c. Importing data through scripts
    • d. Exporting data through scripts
    • e. Session Control Command Set
    • f. Error handling.
    • Teradata Fast load
    • a. Various Phases of Fast Load
    • b. Advantages and Process
    • c. Limitations of Fast Load
    • d. Sample scripts
    • Teradata Multi Load
    • a. Various Phases of Multi load
    • b. Limitations of Multi Load
    • c. Working with multiple tables
    • d. Applying various operations

QUICK ENQUIRY