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
