TERADATA Online Training

• admin
• 9 years ago
• Categories: Datawarehousing Online Training & Placements on VelocityInfo

TERADATA Online Training

TERADATA Online Training Course Content :

Introduction

• What is Teradata?
• Teradatav12 & versions Other versions
• Overview OF Teradata
• Teradata warehouse
• Teradata in the Enterprise
• Teradata Users & Scalability
• interview Q&A and Certification queries

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

• Why for locks &how to release
• Various locks for simultaneous access
• RAID 1&RAID 5
• Disk Arrays
• Fall Back
• Clique
• AMP Clustering
• Types OF Journals
• Recovery Journal
• Trasient Journal
• Permanent Journal
• Before Journal
• After Journal
• How & where is used journals
• 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

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

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