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 background
- Benefits of choosing Teradata
- Scalability for users
Relational Concepts
- Overview of RDBMS
- Data warehousing principles
Set Up and Installation
- Installation process
- Essential tools and utilities, such as BTEQ
Teradata Architecture
- Core components
- Node
- Parsing Engine
- Message Parsing Layer - BYNET
- Access Module Processor
- Storage architecture
- Retrieval architecture
- General architectural overview
Teradata Basic Concepts - SQL
- Data types
- Tables
- Permanent
- Volatile
- Global Temporary
- Derived
- Set vs Multiset Tables
- Data manipulation exercises - CRUD Operations [DDL and DML]
- Logical and conditional operators
- SET operators
- String manipulation techniques
- Date/Time handling
- Built-in and aggregate functions
- Joins and subqueries
- Indexes
- Primary
- Secondary
Teradata Advanced Concepts
- Case statements
- Coalesce functions
- Macros
- Stored procedures
- Space management
- Temp
- Spool
- Permanent
- Join strategies
- Statistics
- Compression techniques
- 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. Participants are encouraged to actively engage in the assigned tasks.
Requirements
While a foundational understanding of SQL and database systems is advantageous, the course covers the necessary basics, ensuring participants are well-prepared from the start.
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.
