[vc_btn title=”On-Demand Course” color=”blue” size=”m” link=”url:http%3A%2F%2Fflexmind.co%2Fcontact%2F%23firstcontentcontainer|title:On-Demand%20Course|target:%20_blank”]
Teradata Training
Course Outline
Module 1: Teradata Architecture and Components
- PDE (Parallel Data Extension)
- Vprocs (virtual processors)
- PE (Parsing Engine)
- AMP (Access Module processing)
- BYNET
- TDP (Teradata Directory Program)
- CLI (Call Level Interface)
- TPA (Trusted parallel Application)
- Going in depth by explaining the process of SQL statement execution
Module 2: Various Architecture
- Node Architecture (shared nothing)
- SMP Architecture
- MPP Architecture
- Parallelism Architecture
- Benefit & types
Module 3: Data Recovery and Protection
- Object Locks-Various locks for simultaneous access
- RAID
- Disk Arrays
- Fall Back
- Clique
- AMP Clustering
- Permanent Journal
- Transient Journal
Module 4: Teradata Indexes
- Primary Index
- Unique
- Non unique
- Partitioned
- Secondary Index
- Unique
- Non unique
- Skewness
- Secondary Index Sub table
- Accessing Records via primary index
- Accessing records via Secondary index
- Keys vs indexes
Module 5: Teradata Sql Reference
- Fundamentals
- Data Types and Literals
- Data Definition Statements
- Data manipulation statements
Module 6: Teradata Functions and Operators
- String functions
- Format functions
- Cast functions
- Group & Aggregate functions
- With & with by clauses
Module 7: Performance Tuning and Explain Utility
- Explain Usage
- Collection Statistics
- Tuning SQL Performance
Module 8: Joins & Unions
- Inner Join
- Left Outer Join
- Right Outer join
- Full Outer Join
- Union
- Union ALL
Module 9: Teradata Basic Commands
- HELP
- SHOW
- EXPLAIN
- COLLECT STATISTICS
Module 10: Teradata objects
- Tables
- SET table
- Multi Set table
- Volatile tables
- Global Temporary tables
- Derived tables
- Views
- Macros
- Stored procedures
- Triggers
Module 11: Teradata Locking
- READ
- WRITE
- EXCLUSIVE
- ACCESS
Module 12: Teradata spaces
- PERM space
- SPOOL space
- TEMPORARY space
- Teradata User
Module 13: Teradata OLAP Functions
- Cumulative SUM
- Difference SUM
- Moving SUM
- Moving AVG
- Qualify
- Row Number
Module 14: Teradata Built in Functions
- DATE
- TIME
- CURRENT_DATE
- CURRENT_TIMESTAP
- LIKE
- SUBSTRING
- POSITION
Module 15: Teradata Transaction Modes
- BTET
- ANSI
- Interactive
- Batch
Module 16: Load and Unload Utilities & Tools
Teradata Sql Assistant (Queryman)
- SQL Assistant Tool Hands On with all the features
- Importing data SQL Assistant
- Exporting data SQL Assistant
Teradata BTEQ
- Batch Scripts with samples
- Branching and Looping
- Importing data through scripts
- Exporting data through scripts
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
- Applying various operations
- Sample Scripts
Teradata TPump
- Various Phases of TPump
- Limitations of TPump
- Applying various operations
- Sample Scripts
Teradata Fast Export
- Fast Export with multiple tables
- Sample Scripts