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 Context and Background
- Key Benefits of Adopting Teradata
- Scalability for Users
Relational Concepts
- Overview of RDBMS
- Data Warehousing Principles
System 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
- Data Retrieval Architecture
- High-Level Architectural Overview
Teradata Basic Concepts - SQL
- Data Types
- Table Management
- Permanent Tables
- Volatile Tables
- Global Temporary Tables
- Derived Tables
- Set v/s Multiset Tables
- Data Manipulation - CRUD Operations [DDL and DML]
- Logical and Conditional Operators
- SET Operators
- String Manipulation Techniques
- Date and Time Handling
- Built-in and Aggregate Functions
- Joins and Subqueries
- Indexing
- Primary Keys
- Secondary Indexes
Teradata Advanced Concepts
- Case Statements
- Coalesce Function
- Macros
- Stored Procedures
- Space Management
- Temporary Space
- Spool Space
- Permanent Space
- Join Strategies
- Statistics and Analysis
- Compression Techniques
- Hashing Algorithms
- OLAP Functions
- User Administration
Teradata Additional Concepts
- Data Utilities
- FastLoad
- MultiLoad
- FastExport
- BTEQ
- Data Protection Methodologies
- Optimization Strategies
Please Note: This training combines theoretical instruction with practical, hands-on exercises. Active participant engagement during these exercises is highly encouraged.
Requirements
While foundational knowledge of SQL and Database Systems is beneficial, the course curriculum covers these essentials, so prior expertise is not strictly required.
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.
