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

课程分类

相关课程

促销课程

Docker管理与开发集成

10/21/2019 - 09:30

广东国际大厦

查看更多

Automation Anywhere for End Users

10/28/2019 - 09:30

北京 - 创而新大厦

查看更多

Automation Anywhere for End Users

10/31/2019 - 09:30

北京 - 创而新大厦

查看更多

Docker和Kubernetes：构建和缩放容器化应用程序

11/04/2019 - 09:30

上海 - 上海中区广场

查看更多

Kubernetes：基础到高级

11/18/2019 - 09:30

浙江 - 外经贸广场

查看更多

Docker (introducing Kubernetes)

11/25/2019 - 09:30

深圳 - 新世界中心

查看更多

我们的客户

mizuho corporate bank

axel springer se

ibm business consulting services

european molecular biology laboratory (embl)

european organization for nuclear research (cern)

nintendo of europe

avid technology

aviva commercial union

seagate technology

embassy of the united states of america

glaxosmithkline

international air transport association (iata)

pearson education

emc corporation

fiat automobiles

royal dutch shell

emerson electric

universal mccann

mizuho corporate bank

axel springer se

ibm business consulting services

european molecular biology laboratory (embl)

european organization for nuclear research (cern)

nintendo of europe

avid technology

aviva commercial union

seagate technology

embassy of the united states of america

glaxosmithkline

international air transport association (iata)

pearson education

emc corporation

fiat automobiles

royal dutch shell

emerson electric

universal mccann

is growing fast!

We are looking to expand our presence in China!

As a Business Development Manager you will:

expand business in China
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.