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
- Reasons to Adopt Teradata
- User Scalability
Relational Concepts
- Introduction to RDBMS
- Concepts of Data Warehousing
Setup and Installation
- Installation Process
- Essential Tools and Utilities, Including BTEQ
Teradata Architecture
- System Components
- Node
- Parsing Engine
- Message Parsing Layer - BYNET
- Access Module Processor
- Storage Architecture
- Retrieval Architecture
- Architectural Overview
Fundamental Concepts - SQL in Teradata
- Data Types
- Table Types
- Permanent Tables
- Volatile Tables
- Global Temporary Tables
- Derived Tables
- Set vs. 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
Advanced Teradata Concepts
- Case Statements
- COALESCE Function
- Macros
- Stored Procedures
- Space Management
- Temporary Space
- Spool Space
- Permanent Space
- Join Strategies
- Statistics
- Compression
- Hashing Algorithm
- OLAP Functions
- User Management
Additional Teradic Concepts
- Utilities
- FastLoad
- MultiLoad
- FastExport
- BTEQ
- Data Protection Methodologies
- Optimization Strategies
Note: The training combines theoretical instruction with practical exercises. Active participation in these exercises is highly recommended for delegates.
Requirements
While foundational knowledge of SQL and Database Systems is beneficial, it is not mandatory as the basics will be thoroughly covered during the course.
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.
