Teradata Fundamentals Training Course

Introduction to Teradata

• Historical Background
• Rationale for Utilizing Teradata
• User Scalability Considerations

Relational Concepts

• Overview of RDBMS
• Foundations of Data Warehousing

Setup and Installation

• Installation Procedures
• Essential Tools and Utilities, such as BTEQ

Teradata Architecture

• Core Components
  • Node
  • Parsing Engine
  • Message Parsing Layer - BYNET
  • Access Module Processor
• Storage Architecture
• Retrieval Architecture
• High-Level Architectural Overview

Teradata Fundamental Concepts - SQL

• Data Types
• Table Structures
  • Permanent Tables
  • Volatile Tables
  • Global Temporary Tables
  • Derived Tables
  • Comparison of Set vs Multiset Tables
• Data Manipulation - CRUD Operations [DDL and DML]
• Logical and Conditional Operators
• SET Operators
• String Manipulation Techniques
• Date/Time Handling
• Built-in and Aggregate Functions
• Joins and Subqueries
• Indexing Strategies
  • Primary Indexes
  • Secondary Indexes

Teradata Advanced Concepts

• CASE Expressions
• Coalesce Functionality
• SQL Macros
• Stored Procedures
• Space Management
  • Temp Space
  • Spool Space
  • Permanent Space
• Join Strategies
• Statistics Collection and Usage
• Data Compression
• Hashing Algorithms
• OLAP Functions
• User Management

Teradata Supplementary Concepts

• Advanced Utilities
  • FastLoad
  • MultiLoad
  • FastExport
  • BTEQ
• Data Protection Methodologies
• Performance Optimization Strategies

Note: The training combines theoretical instruction with hands-on exercises. It is highly recommended that participants actively engage with the practical activities to maximize their learning experience.