Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to Teradata
- Background Context
- Rationale for Using Teradata
- User Scalability Considerations
Relational Concepts
- Foundations of RDBMS
- Data Warehousing Principles
Setup and Installation
- Installation Process
- Essential Tools and Utilities, including BTEQ
Teradata Architecture
- Key Components
- Node Structure
- Parsing Engine Functionality
- Message Parsing Layer (BYNET)
- Access Module Processor
- Storage Architecture Details
- Retrieval Architecture Mechanisms
- Comprehensive Architectural Overview
Core Teradata Concepts - SQL
- Data Types and Structures
- Table Categories
- Permanent Tables
- Volatile Tables
- Global Temporary Tables
- Derived Tables
- Comparison of Set vs. Multiset Tables
- Data Manipulation and CRUD Operations (DDL and DML)
- Use of Logical and Conditional Operators
- Implementation of SET Operators
- Techniques for String Manipulation
- Handling Date and Time Data
- Application of Built-in and Aggregate Functions
- Execution of Joins and Subqueries
- Indexing Strategies
- Primary Indexes
- Secondary Indexes
Advanced Teradata Concepts
- Usage of Case Statements
- Application of Coalesce Functions
- Definition and Use of Macros
- Development of Stored Procedures
- Space Management
- Temp Space
- Spool Space
- Permanent Space
- Optimization of Join Strategies
- Generation and Use of Statistics
- Data Compression Techniques
- Understanding Hashing Algorithms
- Implementation of OLAP Functions
- User Management Protocols
Additional Teradata Concepts
- Utility Tools
- FastLoad Implementation
- MultiLoad Processes
- FastExport Operations
- BTEQ Usage
- Data Protection Methodologies
- Query and System Optimization Strategies
Note: This training combines theoretical instruction with practical hands-on exercises. Active participation in these activities is recommended for the best learning experience.
Requirements
While familiarity with SQL and database systems is beneficial, the course is designed to be accessible; fundamental concepts will be reviewed and reinforced throughout the training sessions.
21 Hours
Testimonials (3)
passionate trainer
Sylvia Baniak - Maastricht University | UMIO
Course - Teradata Fundamentals
Discussing many examples.
Emily Chesworth - Maastricht University | UMIO
Course - Teradata Fundamentals
Nice training, full of interesting topics. After each topic helpful examples were provided.
