Course Outline
Introduction to Teradata
- Historical background
- Rationale for using Teradata
- User scalability capabilities
Relational Concepts
- Overview of RDBMS
- Data warehousing principles
Setup and Installation
- Installation procedures
- Essential tools and utilities, including BTEQ
Teradata Architecture
- Core components
- Node
- Parsing Engine
- Message Parsing Layer (BYNET)
- Access Module Processor
- Storage architecture
- Data retrieval architecture
- Architectural overview
Teradata Basic Concepts - SQL
- Data types
- Tables
- Permanent
- Volatile
- Global Temporary
- Derived
- Set vs. Multiset Tables
- Manipulating data - 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
- 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
Please note: The training combines theoretical instruction with practical exercises. Active participation from delegates in these exercises is highly encouraged.
Requirements
While a foundational understanding of SQL and database systems is advantageous, the core concepts will be thoroughly covered during the training sessions.
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 3900 € + 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.
