Course Outline
Introduction to Teradata
- Background
- Rationale for using Teradata
- User Scalability
Relational Concepts
- Introduction to RDBMS
- Warehousing Concepts
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 Overview
Teradata Basic Concepts - SQL
- Data Types
- Tables
- 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/Time Functions
- Built-in and Aggregate Functions
- Joins and Subqueries
- Indexes
- Primary
- Secondary
Teradata Advanced Concepts
- CASE Expressions
- COALESCE
- 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 consists of a mix of theoretical instruction and hands-on exercises. Active participation from delegates in these exercises is highly recommended.
Requirements
While fundamental SQL and database system concepts are covered during the training, having basic prior knowledge of these areas is beneficial.
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.
