Tera Data Online Training | Just Learn Online Technologies

Teradata 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

Our Training Courses