Kód kurzu

teraintro

Doba trvání

21 hodiny obvykle 3 dny včetně přestávek

Požadavky

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.

Návrh Školení

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.

Reference

★★★★★

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.

Líbí se mi komplexní přístup k vyučovanému předmětu. Kurz byl strukturován, témata byla připravena a prezentována v dobrém pořádku, což nám pomohlo pochopit postupnou logiku toho, jak jednotlivé aspekty Teradata fungují. Obzvláště se mi líbí, že na téma indexů byl kladen velký dopad. Pablo je velmi sympatický člověk a dobrý učitel. Čas strávený na tomto školení byl rozhodně dobře strávený.

MicroStrategy Poland Sp. z o.o.

Machine Translated

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