Kurskode

teraintro

Varighet

21 timer (vanligvis 3 dag inkludert pauser)

Krav

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

Oversikt

Teradata er en av de populære Relational Database Management System. Den er hovedsakelig egnet for å bygge applikasjoner i stor skala. Teradata oppnår dette ved begrepet parallellisme.

Dette kurset introduserer delegatene til Teradata .

Machine Translated

Kursplan

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

★★★★★

Trening var bra, trener var nyttig. Jeg antar også at trener tilpasset litt kunnskapen vår etter første dag.

Capgemini Polska sp. z o.o.

Machine Translated

Treners entusiasme og energi

Capgemini Polska sp. z o.o.

Machine Translated

Tips for å forbedre ytelsen

Capgemini Polska sp. z o.o.

Machine Translated

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.

Jeg liker den omfattende tilnærmingen til emnet som læres. Kurset var godt strukturert, emnene ble utarbeidet og presentert i en god orden, noe som hjalp oss med å forstå trinnvis logikk hvordan spesielle sider ved Teradata fungerer. Spesielt liker jeg at det ble lagt mye inntrykk på temaet indekser. Pablo er en veldig sympatisk person og en god lærer. Tiden brukt på denne treningen ble definitivt brukt godt.

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