Teradata Fundamentals Training Course

Introduction to Teradata

• Background Context
• Reasons for Selecting Teradata
• User Scalability

Relational Concepts

• RDBMS Fundamentals
• Data Warehousing Principles

Setup and Installation

• Installation Process
• Key Tools and Utilities, including BTEQ

Teradata Architecture

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

Teradata Basic Concepts - SQL

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

Teradata Advanced Concepts

• CASE Statements
• Coalesce
• Macros
• Stored Procedures
• Space Management
  • Temp Space
  • Spool Space
  • Permanent Space
• Join Strategies
• Statistics
• Compression
• Hashing Algorithm
• OLAP Functions
• User Management

Teradata Additional Concepts

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

Note: The training comprises a blend of theoretical instruction and practical exercises. Active participation from delegates in the assigned activities is recommended.