Course Outline
Introduction to Teradata
- Background
- Reasons to adopt Teradata
- User Scalability
Relational Concepts
- Introduction to RDBMS
- Warehousing Concepts
Setup and Installation
- Installation Process
- 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
- Interacting with Data - CRUD Operations (DDL and DML)
- Logical and Conditional Operators
- SET Operators
- String Manipulation
- Date/Time
- Built-in and Aggregate Functions
- Joins and Subqueries
- Indexes
- Primary
- Secondary
Teradata Advanced Concepts
- CASE Statements
- COALESCE
- Macros
- Stored Procedures
- Space Management
- Temp
- Spool
- Permanent
- Join Strategies
- Statistics
- Compression
- Hashing Algorithms
- OLAP Functions
- User Management
Teradata Additional Concepts
- Utilities
- FastLoad
- MultiLoad
- FastExport
- BTEQ
- Data Protection Methodologies
- Optimization Strategies
Note: The course combines theoretical instruction with hands-on exercises. Active participation from participants is encouraged to maximize learning outcomes.
Requirements
A foundational understanding of SQL and database systems is advantageous; however, core principles will be reviewed during the course.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 4800 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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.
