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.
Duration 21 hours
Course Outline
Introduction to Teradata
- Background
- Rationale for selecting Teradata
- User Scalability
Relational Concepts
- Overview of RDBMS
- Data Warehousing Principles
Set Up and Installation
- Installation process
- Tools and Utilities including BTEQ
Teradata Architecture
- Key Components
- Node
- Parsing Engine
- Message Parsing Layer - BYNET
- Access Module Processor
- Storage Architecture
- Retrieval Architecture
- Architectural Overview
Teradata Basic Concepts - SQL
- Data Types
- Table Varieties
- Permanent
- Volatile
- Global Temporary
- Derived
- Set vs. Multiset Tables
- Data Interaction - 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 Statements
- Coalesce
- Macros
- Stored Procedures
- Space Management
- Temp
- 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 combines theoretical instruction with practical exercises, so it is recommended that participants actively engage with the provided tasks.
Requirements
A foundational understanding of SQL and Database Systems is advantageous, although the fundamental concepts will be addressed during the course.
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.
