Sub-Pages

Teradata Online Training

Teradata Online Training

 

Tera Data Course Content

Mantra Online Trainings provide the complete training in Tera Data. The trainers will cover all the concepts in the course. Below are the Tera Data course details.

 

Tera Data 12:
Teradata Warehouse and Competitiveness

• What is Teradata-RDBMS
• Teradata 12 Vs Other versions
• Teradata History
• Teradata in the Enterprise
• Teradata Users & Scalability
• Teradata competitiveness with other RDBMS
• (Oracle, SqlServer etc)
• Teradata Warehouse
• Discussion on interview and certification questions

 

Teradata Architecture and Components

• PDE(Parallel Data Extension)
• Vprocs(Virtual Processors)
• 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 Architectures

• Node Architecture(Shared Nothing)
• SMP Architecture
• MPP Architecture
• Parallelism Architecture
• Benefits and Types

 

Data Recovery and Protection

• Object Locks
• Various locks for simultaneous access
• RAID 1
• RAID 5
• Disk Arrays
• Fall Back
• Clique
• AMP Clustering
• Journals
• Recovery Journal
• Trasient Journal
• Permanent Journal
• Before Journal
• After Journal
• Answering various recovery questions

 

Teradata Storage and Retrival Architectures

• Request Processing
• Syntaxer
• Resolver
• Security Module
• Optimizer
• Step Generator
• GNC Apply
• Dispatcher
• Primary Index
• Hash algorithm
• Row Hash
• DSW
• Hash Map
• Hash Bucket
• Reaching V disk

 

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

• Fundamentals
• Data Types and Literals
• Data Definition Statements
• Data Manipulation Statements
• 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

• Implicit Transaction
• Explicit Transaction

 

Performance Tuning and Explain Utility

• Explain Usage
• Collecting Statistics
• Tuning SQL Performance
• Usage of PMON
• Explaining various SQL statements

 

Joins and Unions

• Inner Join
• Left Outer Join
• Right Outer Join
• Full Outer Join
• Detailed explanation

 

Join Strategies

• Product Join
• Merge Join
• Hash Join
• Nested 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

 

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
• Error handling

 

Explanation with proper debugging

• Teradata Fast Load
• Various Phases of Fast Load
• Advantages and Process
• Limitations of Fast Load
• Sample Scripts

 

Real time Issues and resolving it

• Teradata Multi Load
• Various Phases of Multi Load
• Limitations of Multi Load
• Working with multiple tables
• Applying various operations
• Sample Scripts

 

Real time Issues and solving it
Teradata Parallel Data Pump

• Limitations of TPump
• Overview of TPump
• Sample Scripts

 

Teradata Fast Export

• Exporting Data
• Passing Parameters
• OUTMODS
• Sample Scripts
• Utility Vs Parallelism

 

Introduction to

• Answering AD-hoc queries and FAQs
• Covering DBA Concepts