Teradata Online Training

Course Duration : 40 Hrs

Teradata Course Content

Introduction

• What is Teradata
• Overview Of Teradata
• Data warehouse concepts

Teradata Architecture and Components

• Teradata Architecture
• SMP/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 / Secondary Index
• Unique / Non Unique Index
• Partitioned
• Hash, Join, Value Ordered
• Accessing Records via Primary Index
• Accessing records via Secondary Index
• Keys Vs Indexes
• Explanation with Full Real time scenarios

Teradata Sql Reference

• 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
• Product Join
• Practices of this section

Teradata Basic Commands

• 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 Basic Commands

• HELP
• SHOW
• EXPLAIN
• COLLECT STATISTICS

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 and Transaction modes

• PERM space
• SPOOL space
• TEMPORARY space
• Practical Examples
• BTET / ANSI / Interactive / Batch

Teradata Sql Assistant (Queryman)

• How to use Sql Assistant
• Query Processing
• Importing and exporting

Teradata Utilities

• 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