Teradata Online Training Course Content

Teradata introduction

• Teradata Introduction
• Teradata Advantages
• Teradata Tools & Utilities

RDBMS/Data warehousing Basics

• RDBMS Basic Concepts (Tables/Rows/Columns/Primary Key/Foreign Key)
• What is data warehouse
• OLTP Vs Data warehouse
• Data warehouse Architecture

Teradata Architecture

• Teradata Components (Parsing Engine, BYNET, Access Module Processor)
• How Teradata components interact with each other
• Storage & Retrieval architecture
• System architecture
• What is a Node

Basic SQL

• Data types
• DDL statements(CREATE,DROP,ALTER)
• DML statements (SELECT, INSERT,UPDATE,DELETE)
• SET Operators(UNION , UNION ALL, INTERSECT, MINUS)
• Logical & Conditional Operators
• String Manipulation
• Date & Time Manipulation
• Joins
• Built-in functions
• Aggregates

Indexes

• Primary Index (UPI, NUPI)
• Secondary Index (USI, NUSI)
• Partition Primary Index

Teradata Objects

• SET vs MULTISET tables
• Derived Tables
• Volatile Tables
• Global Temporary Tables
• Views
• Macros
• Stored Procedures
• Single Table Join Index
• Multi Table Join Index
• Aggregate Join Index
• Space concepts (Perm, Spool, Temp)
• Triggers

Advanced SQL

• Subqueries
• Coalesce
• OLAP Functions (Rank, Row_Number, Qualify, Partition by, Rows Unbounded preceding/following)
• Compression
• Collect Statistics
• DBC tables
• Teradata Transaction Modes

Utilities

• FastLoad
• MultiLoad
• BTEQ
• FastExport
• TPT

Data Protection

• Fallback
• Clusters
• Clique
• Permanent Journals
• Hot Standby Nodes
• RAID

Performance Optimization

• Explain Plan
• Join Strategies
• Confidence levels
• Statistics collection process
• Performance tuning techniques

Case-studies and Mock Project

• Decoding common errors
• Best Practices
• Sample Mock Projects

We are providing Teradata Online Training in Ameerpet Hyderabad. We are one of best Institute to provide Best High Quality Teradata online training all over India. The IT Professionals and Students from India and abroad who are unable to attend regular classes can attend our Teradata online training from their home in their convenient timings. For more details on Teradata Online Training please call to 9290971883, / 9247461324, or drop a mail to revanthonlinetraining@gmail.com

Teradata online training institute address : B1, 3rd Floor, Eureka Court, Near Image Hospital, Ameerpet, Hyderabad, India