Teradata Fundamentals 교육 과정

  1. 빅 데이터 Training
  2. Teradata Training
  3. Teradata Fundamentals 교육 과정

Course Code

teraintro

Duration

21 hours (usually 3 days including breaks)

Requirements

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

Overview

Teradata 는 널리 사용되는 관계형 Database Management 시스템 중 하나입니다. 주로 대규모 데이터웨어 하우징 응용 프로그램을 작성하는 데 적합합니다. Teradata 는 이것을 병렬 처리의 개념으로 구현합니다.

이 과정에서는 Teradata 의 대표자를 소개합니다.

Machine Translated

Course Outline

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.

회원 평가

★★★★★
★★★★★

Related Categories

Related Courses

Oracle SQL LanguageMicrosoft Access - download the dataAdvanced SQL, Stored Procedures and Triggers for Microsoft SQL ServerORACLE PL/SQL FundamentalsOracle SQL AdvancedOracle SQL for beginnersORACLE SQL FundamentalsPostgreSQL Administration and DevelopmentSQL FundamentalsSQL in Microsoft AccessSQL in MySQLSQL Advanced in MySQLSQL in SQL ServerTransact SQL AdvancedTransact SQL Basic

코스 프로모션

Blockchain: Hyperledger Iroha for Mobile Applications

10/28/2019 - 09:30
JUNGANG-DONG CENTRE
Remote
₩3814200
₩3432780
 Classroom
₩3814200
₩3432780
Read more

OCEB2 OMG Certified Expert in BPM - Fundamental Exam Preparation

12/17/2019 - 09:30
스페이시즈 그랑 서울 업무공간
Remote
₩7628400
₩6865560
 Classroom
₩7628400
₩6865560
Read more

CRISC - Certified in Risk and Information Systems Control

02/03/2020 - 09:30
JUNGANG-DONG CENTRE
Remote
₩4841100
₩4356990
 Classroom
₩4841100
₩4356990
Read more

Data Visualization: Creating Captivating Reports

02/17/2020 - 09:30
JUNGANG-DONG CENTRE
Remote
₩5721300
₩5149170
 Classroom
₩5721300
₩5149170
Read more

고객 회사

is growing fast!

We are looking to expand our presence in South Korea!

As a Business Development Manager you will:

  • expand business in South Korea
  • 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!