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.

客户评论

★★★★★
★★★★★

课程分类

促销课程

订阅促销课程

为尊重您的隐私,我公司不会把您的邮箱地址提供给任何人。您可以享有优先权和随时取消订阅的权利。

我们的客户

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.

Apply now!