Várjuk 2025-ben is tanfolyamainkon és vizsgáinkon!

Teradata Certification Training

TCT-HV
6 nap
737 590 Ft + ÁFA
tanfolyamkezdési időpontok:
Jelentkezem!
oktatók:

A tanfolyamról

What organizations need today is seamless management of their ever-growing data. Teradata is a fully scalable relational database management system that is used to store, retrieve and manipulate big data. Its advantages lie in the fact that it leads to performance advantages in terms of querying, scanning, sorting and manipulation of data.
This highly interactive and comprehensive Teradata training will introduce you to the fundamentals of working with Teradata. You will learn about Teradata architecture, the indexing mechanism and the various SQL queries that will allow you to retrieve and perform manipulations on your data. You will learn about the various Teradata utilities such as Fast Load and Multi Load and how they are used to import data into Teradata. The workshop also covers in-depth advanced database objects used for performance optimization.

Who Should Attend This Training

  • Database Administrators
  • Developers
  • Data Analysts
  • Business Intelligence Professionals

What You Will Learn

  • Fundamentals of Teradata
    All about Teradata, its architecture, and components and how it compares to RDBMS
  • ​Index Mechanism
    Understand the Teradata indexing mechanism and handling and manipulation of data
  • Advanced SQL
    Learn all about Advanced SQL operations and using sub-queries, OLAP functions and others
  • Database projects
    Work on Advanced Database objects and use them to perform performance tuning and optimization
  • Tools and Techniques
    Learn all the application utilities provided by Teradata such as FastLoad and MultiLoad
  • Data Protection
    Understand how to protect data in Teradata, along with how to apply it in your teams

We provide the course in English.

Tematika

Curriculum

Module 1: Introduction to Teradata

  • Introduction
  • Fundamentals of Teradata

Module 2: Teradata Indexes and Join Strategies

  • Introduction to Indexes
  • Joining Strategies

Module 3: Teradata SQL

  • What is SQL
  • Understanding Teradata SQL

Module 4: Data Protection

  • Introduction to Data Protection
  • Fundamentals of Data Protection
  • Importance of Data Protection

Module 5: SQL Advanced

  • Introduction to SQL Advanced
  • Fundamentals of SQL Advanced

Module 6: Advanced Database objects and performance optimization

  • Introduction to Advanced Database Objects
  • Understanding Performance Optimization

Module 7: Teradata Utilities - FastLoad, MultiLoad, BTEQ

  • Introduction to Teradata Utilities
  • Understanding FastLoad
  • Understanding MultiLoad
  • Understanding BTEQ

Module 8: Teradata Utilities - FastExport,TPT

  • What are the objectives of Teradata Utilities
  • Understanding FastExport
  • Understanding TPT

Kinek ajánljuk

Előfeltételek

Prerequisites

Basic Knowledge in SQL, general relational database knowledge and basic Unix commands.

Kapcsolódó tanfolyamok



Ajánlja másoknak is!