Teradata Fundamentals Training Course

Introduction to Teradata

• Background
• Reasons for utilizing Teradata
• User Scalability

Relational Concepts

• Overview of RDBMS
• Warehousing Concepts

Setup and Installation

• Installation procedures
• Essential tools and utilities, including BTEQ

Teradata Architecture

• Key Components
  • Node
  • Parsing Engine
  • Message Parsing Layer - BYNET
  • Access Module Processor
• Storage Architecture
• Retrieval Architecture
• General Architectural Overview

Teradata Core Concepts - SQL

• Data Types
• Table Types
  • Permanent
  • Volatile
  • Global Temporary
  • Derived
  • Comparison of Set vs. Multiset Tables
• Data Interaction - CRUD Operations (DDL and DML)
• Logical and Conditional Operators
• SET Operators
• String Manipulation
• Date and Time Handling
• Integrated and Aggregate Functions
• Joins and Subqueries
• Indexes
  • Primary
  • Secondary

Teradata Advanced Concepts

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

Teradata Supplementary Concepts

• Specialized Utilities
  • FastLoad
  • MultiLoad
  • FastExport
  • BTEQ
• Data Protection Methodologies
• Optimization Strategies

Note: The course combines theoretical instruction with practical, hands-on exercises. Active participation from delegates in these activities is recommended for optimal learning.