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
- Historical Background
- Benefits of Using Teradata
- User Scalability
Relational Concepts
- Introduction to RDBMS
- Data Warehousing Principles
Setup and Installation
- Installation Process
- Tools and Utilities, Including BTEQ
Teradata Architecture
- Key Components
- Node
- Parsing Engine
- Message Parsing Layer - BYNET
- Access Module Processor
- Storage Architecture
- Data Retrieval Architecture
- Architectural Overview
Teradata Basic SQL Concepts
- Data Types
- Table Types
- Permanent
- Volatile
- Global Temporary
- Derived
- Set vs. Multiset Tables
- Data Manipulation - 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
- Secondary
Advanced Teradata Concepts
- CASE Statements
- COALESCE Function
- Macros
- Stored Procedures
- Storage Management
- Temporary
- Spool
- Permanent
- Join Strategies
- Statistics
- Compression Techniques
- Hashing Algorithms
- OLAP Functions
- User Management
Additional Teradata Concepts
- Utilities
- FastLoad
- MultiLoad
- FastExport
- BTEQ
- Data Protection Methodologies
- Optimization Strategies
Note: The training combines theoretical instruction with practical exercises. Active participation in these exercises is highly recommended.
Requirements
A foundational understanding of SQL and database systems is beneficial, although fundamental concepts will be reviewed during the training.
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.
