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
Requirements
Basic knowledge of SQL and Database Systems would be helpful, although the basics will be covered during the training course.
Testimonials
Explaining the step to take when trying to answer a question via the SQL
Maastricht University | UMIO
The enthusiasm of the trainer
Maastricht University | UMIO
New learned skills
Maastricht University | UMIO
passionate trainer
Sylvia Baniak - Maastricht University | UMIO
I liked the depth of the training. I was able to understand most of it and definitely learned from this training
Maastricht University | UMIO
Discussing many examples.
Emily Chesworth - Maastricht University | UMIO
I like the comprehensive approach to the subject taught. The course was well-structured, the topics were prepared and presented in a good order, helping us understand step-by-step logic how particular aspects of Teradata work. Especially I like that a lot of impact was put on the topic of indices. Pablo is a very likeable person and a good teacher. The time spent on this training was definitely spent well.
MicroStrategy Poland Sp. z o.o.
Nice training, full of interesting topics. After each topic helpful examples were provided.
Pawel Wojcikowski - MicroStrategy Poland Sp. z o.o.
Materials (code, presentation) were good
MicroStrategy Poland Sp. z o.o.
the good energy of the trainer, he explained everything clearly and precisely
MicroStrategy Poland Sp. z o.o.
Tips to improve performance