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
- Benefits of using Teradata
- User Scalability
Relational Concepts
- Introduction to RDBMS
- Warehousing Concepts
Setup and Installation
- Installation Procedures
- Tools and Utilities, such as 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 Handling
- Built-in and Aggregate Functions
- Joins and Subqueries
- Indexes
- Primary
- Secondary
Teradata Advanced Concepts
- Case Statements
- Coalesce
- Macros
- Stored Procedures
- Storage Spaces
- 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 will combine theoretical instruction with practical exercises. Active participation from delegates in these exercises is encouraged.
Requirements
While the course will cover the basics, having a foundational understanding of SQL and database systems is beneficial.
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.
