Teradata Fundamentals Training Course

Introduction to Teradata

• Historical Context
• Advantages of Teradata
• User Scalability

Relational Concepts

• Overview of RDBMS
• Data Warehousing Principles

Configuration and Deployment

• Installation Procedures
• Essential Tools and Utilities, including BTEQ

Teradata Architecture

• Core Components
  • Node
  • Parsing Engine
  • Message Parsing Layer - BYNET
  • Access Module Processor
• Storage Design
• Data Retrieval Design
• System Architectural Overview

Teradata Core Concepts - SQL

• Data Types
• Table Structures
  • Permanent
  • Volatile
  • Global Temporary
  • Derived
  • Set vs. Multiset Tables
• Data Manipulation - CRUD Operations [DDL and DML]
• Logical and Conditional Operators
• SET Operators
• String Processing
• Date and Time Handling
• Native and Aggregate Functions
• Joins and Subqueries
• Indexing
  • Primary
  • Secondary

Teradata Advanced Topics

• Case Statements
• Coalesce
• Macros
• Stored Procedures
• Space Management
  • Temp
  • Spool
  • Permanent
• Join Strategies
• Statistics
• Compression Techniques
• Hashing Algorithms
• OLAP Functions
• User Administration

Additional Teradata Insights

• Utility Tools
  • FastLoad
  • MultiLoad
  • FastExport
  • BTEQ
• Data Security Approaches
• Performance Optimization Strategies

Note: This program combines theoretical instruction with practical, hands-on exercises. Active participation from delegates in these exercises is encouraged to maximize learning outcomes.