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
- Rationale for using Teradata
- User Scalability
Relational Concepts
- Introduction to RDBMS
- Data Warehousing Concepts
Setup and Installation
- Installation Process
- Tools and Utilities, including BTEQ
Teradata Architecture
- 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 Tables
- Volatile Tables
- Global Temporary Tables
- Derived Tables
- Set versus Multiset Tables
- Data Manipulation - 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 Indexes
- Secondary Indexes
Teradata Advanced Concepts
- Case Statements
- Coalesce Functions
- Macros
- Stored Procedures
- Space Management
- Temporary Space
- Spool Space
- Permanent Space
- 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: This training combines theoretical instruction with hands-on exercises. Active participation from delegates in these exercises is highly encouraged.
Requirements
While the course covers foundational concepts, having a basic understanding of SQL and database systems will be beneficial for participants.
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.
