Teradata Online Training

 Teradata Online Training
Best Institute for learn exert level Online Teradata Training By Experts, Learn Teradata Certification Training with Course Material, Tutorial Videos, Attend Demo for free & you will find SpiritSofts is the best institute within reasonable fee, Job Support
Spiritsofts is the best Training Institutes to expand your skills and knowledge. We Provide the best learning Environment. Obtain all the training by our expert professional which is having working experience from Top IT companies. The Training in is every thing we explained based on real-time scenarios, it works which we do in companies.
Experts Training sessions will absolutely help you to get in-depth knowledge on the subject.

Teradata Online Training Course Content
Teradata Indexes
  • Primary Index
  • Unique
  • Nonunique
  • Partitioned
  • Secondary Index
  • Unique
  • Nonunique
  • 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
    • SET table
    • Multi Set table
    • Volatile tables
    • Global Temporary tables
    • 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
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
  • RAID
  • RAIDI5
  • Disk Arrays
  • Fall Back
  • Clique
  • AMP Clustering
  • Journals
Teradata Storage and Retrieval Architecture
  • Request processing
    • a. Syntax
    • b. Resolver
    • c. Security Module
    • d. Optimizer
    • e.Step Generator
    • f. GNC Apply
    • g. Dispatcher
Primary index
  • Hash algorithm
  • Row hash
  • DSW
  • Hash Map
  • Hash Bucket
  • Reaching Vdisk