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
+1 (415)-873 0245