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
- Background
- Why use Teradata
- User Scalability
Relational Concepts
- Introduction to RDBMS
- Warehousing Concepts
Set Up and Installation
- Installation
- Tools and Utilities like 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 Type
- Tables
- Permanent
- Volatile
- Global Temporary
- Derived
- Set v/s Multiset Tables
- Playing 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
- Coalesce
- Macros
- Stored Procedures
- Space
- Temp
- Spool
- Permanent
- Join Strategies
- Statistics
- Compression
- Hashing Algorithm
- OLAP Functions
- User Management
Teradata Additional Concepts
- Utilities
- FastLoad
- MultiLoad
- FastExport
- BTEQ
- Data Protection Methodologies
- Optimization Strategies
Note: This training combines theoretical instruction with hands-on exercises. Participants are encouraged to actively engage in the practical components to maximize learning outcomes.
Requirements
While a foundational understanding of SQL and database systems is beneficial, the course covers essential basics to ensure all participants are prepared for the training.
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.
