Teradata Fundamentals Training Course

Introduction to Teradata

• Background
• Reasons for adopting Teradata
• User Scalability

Relational Concepts

• Introduction to RDBMS
• Warehousing Concepts

Setup and Installation

• Installation Procedures
• Tools and Utilities such as BTEQ

Teradata Architecture

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

Teradata Basic Concepts - SQL

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

Teradata Advanced Concepts

• Case Statements
• Coalesce Functions
• Macros
• Stored Procedures
• Space Management
  • Temp
  • Spool
  • Permanent
• 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 combines theoretical instruction with hands-on exercises. Active participation in the provided exercises by all delegates is strongly encouraged.