Course Outline
Introduction to Teradata
- Background
- Reasons to utilise Teradata
- User scalability
Relational Concepts
- Overview of RDBMS
- Warehousing principles
Setup and Installation
- Installation procedures
- Tools and utilities, including BTEQ
Teradata Architecture
- Components
- Node
- Parsing Engine
- Message Parsing Layer - BYNET
- Access Module Processor
- Storage architecture
- Retrieval architecture
- Architectural summary
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 and time handling
- Built-in and aggregate functions
- Joins and subqueries
- Indexes
- Primary
- Secondary
Teradata Advanced Concepts
- Case statements
- Coalesce function
- Macros
- Stored procedures
- Space management
- Temporary
- 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 training combines theoretical instruction with practical exercises; active participation from attendees in the provided tasks is highly recommended.
Requirements
While a foundational grasp of SQL and database systems is advantageous, core principles will be thoroughly covered throughout the training session.
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.
