Important information

Typology

Course

Methodology

Online

Course

Online

Description

Edureka's Teradata development, will introduce the participants to work with Teradata. The course will cover in detail about Teradata Architecture, Indexing mechanism and how data is stored and retrieved. It will cover basic and advanced SQL operations in Teradata. It will also cover various utilities provided by Teradata to process, import and export data. Participants will also get to implement one project towards the end of the course. This course will also train you for TEO-141 and TEO-142 certifications.

Course programme

1. Teradata - An Overview

Learning Objectives - In this module, you will understand basic relational concepts and overview of Teradata such as its History, Comparison with other RDBMS, Architecture, Components (PE, BYNET, AMP), Interaction between components, Storage and Retrieval architecture, Connectivity with Mainframe and advanced architecture.

Learning Objectives- In this module, you will learn about various indexing concepts in Teradata and how they affect storage and retrieval of data. You will understand the importance of Primary index and how it affects the storage of data, Use of secondary and Partition Primary index in fast retrieving data. You will also learn the hashing algorithm in detail and various join strategies used by Teradata to join tables.

Topics- Difference between Primary Key and Primary Index, Primary Index and types, How primary index is used in data distribution and retrieval, Secondary index and its types, Data retrieval using secondary Index, Partition primary index and its types, Advantage of PPI , Join strategies, How data is redistributed for Join processing.

3. Teradata SQL

Learning Objectives- In this module, you will learn about SQL commands used in Teradata. You will learn to create/alter/drop database objects and perform various SQL operations on the data stored in Teradata tables.

Learning Objectives - In this module, you will learn about various data protection mechanism provided in Teradata. You will learn how AMP failure, Node failure, Transaction failure and Disk failures are handled.

Learning Objectives - In this module, you will learn more about SQL Commands in Teradata. You will learn how to use sub queries, using OLAP functions, Transaction modes and temporary tables. You will learn to understand Explain statement and collect statistics.

Learning Objectives - In this module, you will learn about some of the Application utilities provided by Teradata. You will learn how FastLoad and MultiLoad are used to import data into Teradata. Also, you will understand using BTEQ to submit SQL queries.

Topics - What is FastLoad, How FastLoad loads data, How to restart failed FastLoad jobs, What is MultiLoad and how MultiLoad works, Using MultiLoad to insert/update/delete data from Teradata tables , Using BTEQ to import/export data.

8. Teradata Utilities - FastExport,TPT

Learning Objectives - In this module, you will learn about the FastExport and TPT utilities