TeraData Training
This Teradata training is designed to illustrate the fundamentals of the Teradata database. The participants can learn about parallel processing, AMPs and PEPs, how Teradata lays out data evenly, Primary Index use, hashing, Perm and Spool Space, and protection features.
Few of the clients we have served across industries are:
DHL | PWC | ATOS | TCS | KPMG | Momentive | Tech Mahindra | Kellogg's | Bestseller | ESSAR | Ashok Leyland | NTT Data | HP | SABIC | Lamprell | TSPL | Neovia | NISUM and many more.
MaxMunus has successfully conducted 1000+ corporate training in India, Qatar, Saudi Arabia, Oman, Bangladesh, Bahrain, UAE, Egypt, Jordan, Kuwait, Srilanka, Turkey, Thailand, HongKong, Germany, France, Australia and USA.
Course Information
Teradata Training Duration: 30 Hours
Teradata Training Timings: Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day
Teradata Training Method: Online/Classroom Training
Teradata Training Study Material: Soft Copy
Course Content
Introduction
- What is Teradata
- Overview Of Teradata
- Data warehouse concepts
Teradata Architecture and Components
- Teradata Architecture
- SMP Architecture
- MPP Architecture
- AMP(Access Module Processing)
- TDP(Teradata Directory Program)
- CLI(Call Level Interface)
- TPA(Trusted Parallel Application)
- Parallelism Architecture
- Benefits and Types
Data Recovery and Security
- locks
- RAID 1&RAID 5
- Disk Arrays
- Fall Back
- Clique
- AMP Clustering
- Journaling
- Answering various recovery questions
Teradata Indexes
- Primary Index
- Unique
- Non unique
- Partitioned
- Secondary Index
- Unique
- NonUnique
- Hash, Join, Value Ordered
- Skewness
- Secondary Index Sub table
- Accessing Records via Primary Index
- Accessing records via Secondary Index
- Keys Vs Indexes
- Full Real time scenarios and explaining
Teradata Sql Reference
- SQL Fundamentals
- Data Types and Literals
- Data Definition Statements(DDL)
- Data Manipulation Statements(DML)
- Explaining with proper examples
Teradata Functions and Operators
- String Functions
- Format Function
- Cast Functions
- Group & Aggregate Functions
- With & with by clauses
- Practices of this section
Teradata Transactions
- Joins and Unions
- Inner Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
- Detailed explanation
- Join Strategies
- Product Join
- Merge Join
- Questions of this section
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
- Practices and FAQs of this session
Teradata spaces
- PERM space
- SPOOL space
- TEMPORARY space
- Teradata User and managing
- Practical Examples
Teradata Transaction Modes
- BTET
- ANSI
- Interactive
- Batch
Teradata Sql Assistant (Queryman)
- How to use Sql Assistant
- Query Processing
- Importing and exporting
Teradata Utilities
BTEQ
- Teradata BTEQ
- Batch Scripts with samples
- Branching and Looping
- Importing data through scripts
- Exporting data through scripts
- Error handling
- Explanation with proper debugging
Fast Load
- Teradata Fast Load
- Various Phases of Fast Load
- Advantages and Process
- Limitations of Fast Load
- Sample Scripts
Multi Load
- Teradata Multi Load
- Various Phases of Multi Load
- Advantages and Process
- Limitations of Multi Load
- Working with multiple tables
- Applying various operations
- Sample Scripts
Fast Export
- Teradata Fast Export
- Advantages and Process
- Limitations of Fast Export
- Sample Scripts
T-Pump
- Advantages and Process
- Teradata Parallel Data Pump
- Limitations of TPump
- Overview of TPump
- Sample Scripts
- Utility Vs Parallelism
- Difference between Multi load and T pump
Performance Tuning
- Performance Tuning and Explain Utility
- Explain Usage
- Collecting Statistics
- Tuning SQL Performance
- Explaining various SQL statements
Real time scenarios and Project Architecture
- Retail or Banking or Health care Project Architecture
- Teradata relation with Informatica
- How to run Teradata scripts in Unix
- Sample Real time scripts walk thru.
- Interview guidance.