Course Code

teraintro

Duration

21 hours (usually 3 days including breaks)

Requirements

Basic knowledge of SQL and Database Systems would be helpful, although the basics will be covered during the training course.

Overview

Teradata is one of the popular Relational Database Management System. It is mainly suitable for building large scale data warehousing applications. Teradata achieves this by the concept of parallelism.

This course introduces the delegates to Teradata.

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

Note: The Training will be a mix of theory and hands on exercises, and it would be helpful if the delegates actively particpate in the given exercises.

Testimonials

★★★★★

Excercises were good, trainer was helpful. I also assume that trainer adapted a little to our knowledge after first day.

Capgemini Polska sp. z o.o.

Trainer's enthusiasm and energy

Capgemini Polska sp. z o.o.

Tips to improve performance

Capgemini Polska sp. z o.o.

the good energy of the trainer, he explained everything clearly and precisely

MicroStrategy Poland Sp. z o.o.

Materials (code, presentation) were good

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.

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.

interaction

Maastricht University | UMIO

Discussing many examples.

Emily Chesworth - Maastricht University | UMIO

exercises & subquery

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

passionate trainer

Sylvia Baniak - Maastricht University | UMIO

Maastricht University | UMIO