Teradata Fundamentals培訓

課程代碼

teraintro

課程時長

21 時間：同常來說包括休息是 3天

最低要求

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

概觀

Teradata是流行的關係Database Management系統之一。它主要適用於構建大規模數據倉庫應用程序。 Teradata通過並行概念實現了這一目標。

本課程向Teradata的代表介紹。

Machine Translated

課程簡介

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.

客戶評論

★★★★★

★★★★★

很好, 教練很有説明。我也認為教練在第一天后對我們的知識有些適應。

Capgemini Polska sp. z o.o.

Machine Translated

培訓師的熱情和精力

Capgemini Polska sp. z o.o.

Machine Translated

提高性能的提示

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.

我喜歡針對所教主題的綜合方法。該課程結構合理，主題準備得井井有條，並以良好的順序進行了介紹，有助於我們逐步了解Teradata特定方面的工作原理。特別是我喜歡在索引主題上產生很多影響。巴勃羅是一個非常可愛的人，也是一位好老師。花費在這次培訓上的時間肯定花得很不錯。

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

x

Maastricht University | UMIO

New learned skills

Maastricht University | UMIO

The enthusiasm of the trainer

Maastricht University | UMIO

解釋嘗試通過SQL回答問題時採取的步驟

Maastricht University | UMIO

Machine Translated

課程分類

相關課程

促銷課程

ELK: Elasticsearch, Logstash and Kibana for Administrators

10/22/2019 - 09:30

The Hsinchu Wishun centre

更多

Artificial Intelligence Overview

10/29/2019 - 09:30

The Hsinchu Wishun centre

更多

Blockchain Development with Coinbase

10/30/2019 - 09:30

The Hsinchu Wishun centre

更多

Zeppelin for Interactive Data Analytics

01/09/2020 - 09:30

The Hsinchu Wishun centre

更多

Signavio Process Manager

01/30/2020 - 09:30

台北, Concord

更多

我們的客戶

ibm business consulting services

nexsan technologies canada

avid technology

toyota bank polska

santander consumer bank

european space agency (esa)

thomson reuters corporation

universal music publishing group

zf friedrichshafen

european organization for nuclear research (cern)

avon products, inc

royal dutch shell

procter & gamble (p&g)

the emirates group

environmental protection agency (epa) ireland

nokia siemens networks

starnet telecom

aviva commercial union

société générale

schneider electric

phoenix geophysics

ibm business consulting services

nexsan technologies canada

avid technology

toyota bank polska

santander consumer bank

european space agency (esa)

thomson reuters corporation

universal music publishing group

zf friedrichshafen

european organization for nuclear research (cern)

avon products, inc

royal dutch shell

procter & gamble (p&g)

the emirates group

environmental protection agency (epa) ireland

nokia siemens networks

starnet telecom

aviva commercial union

société générale

schneider electric

phoenix geophysics

is growing fast!

We are looking to expand our presence in Taiwan!

As a Business Development Manager you will:

expand business in Taiwan
recruit local talent (sales, agents, trainers, consultants)
recruit local trainers and consultants

We offer:

Artificial Intelligence and Big Data systems to support your local operation
high-tech automation
continuously upgraded course catalogue and content
good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.