+1-646-597-8346     +91-7396-388-592     Info@araniconsulting.com                
Arani Consulting
Teradata Online Training | Teradata Training
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
  • e. Sample Scripts
  • RSS
  • Delicious
  • Digg
  • Facebook
  • Twitter
  • Linkedin
  • Youtube

Popular Posts

Online Training

Live virtual Online Training: Through a combination of new and existing ...

On Demand Training

At Arani Consulting we provide the training needs of our ...

Project Support

As a leading online Training services institute, we specialize in ...

Corporate Training

Right skill set and quickly adapting to the new technologies ...