Teradata Introduction

• Teradata Introduction
• Teradata Advantages
• RDBMS vs Data warehouse
• Teradata Tools & Utilities
• Teradata Installation

Teradata Architecture

• Teradata Components
• Storage & Retrieval architecture
• System architecture
• How parallelism works

Basic SQL

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

Indexes

• Primary Index
• Secondary Index
• Partition Primary Index

Teradata Objects

• Tables and its types
• Space concepts
• Views
• Macros
• Stored Procedures
• Join Index

Advanced SQL

• Sub queries
• Coalesce
• OLAP Functions
• Compression
• Collect Statistics
• DBC tables
• Explain plan

Utilities

• FastLoad
• MultiLoad
• BTEQ
• FastExport
• TPT

Data Protection

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

Performance Optimization

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

Optional

• Real time projects
• Interview questions