Course Content
Teradata Architecture and Components
- PDE(ParaIIe| 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
- 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
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 Outerjoin
- 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
- Batch Scripts with samples
- Branching and Looping
- Importing data through scripts
- Exporting data through scripts
- Session Control Command Set
- Error handling.
- Teradata Fast load
- Various Phases of Fast Load
- Advantages and Process
- Limitations of Fast Load
- Sample scripts
- Teradata Multi Load
- Various Phases of Multi load
- Limitations of Multi Load
- Working with multiple tables
- Applying various operations
- Sample Scripts
