Teradata Certification Training

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.

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.  

Topics - Data types, DDL Statements (CREATE, ALTER, DROP) , DML Statements (Insert, Delete, Update), DCL Statements (Grant, Revoke), Order by, Group by, Distinct, SET Operators, Logical & Conditional Operators, String functions, Cast & Format functions, HELP and Show Functions, Date Functions, Built-In Functions, Aggregation, Joins (INNER and OUTER).

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. 

Topics - Transaction locks, Fallback tables, Clusters, Permanent Journal, Down AMP Recovery Journal, Transient Journal, Cliques, Hot Standby nodes, RAID 1 & RAID 5, Data Dictionary.

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. 

Topics - Sub queries, Upsert, Case, Coalesce, Nullif, OLAP Functions, Rank & Row Number, Transaction Modes, Temporary Tables (Derived, Volatile and Global Temporary), Explain, Collect Statistics.

Learning Objectives - In this modules, you will learn about additional database objects such as views, Macros, Stored Procedure and Join Index. You will also explore common performance tuning options. 

Topics - Views, Macros, Stored Procedure, Join Index, Performance Tuning tips.

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

Topics - FastExport Exporting data from Teradata , TPT overview, TPT Export, TPT SQL Selector, TPT Load, TPT Update Comparison of Load/Unload Utilities.

After the completion of the Mastering Teradata course at Edureka, you will be able to:

The course is designed for all those who want to learn Teradata.

Teradata provides market leading data and analytics platform. Built from scratch using parallelism, Teradata has been a market leader for decades. It is used by world’s largest and competitive organizations to derive insights from their data and make decisions. In addition to its data warehousing platform, Teradata provides Analytics platform and connectors to integrate seamlessly with Hadoop.\nThe Teradata database management system can be applied in a number of areas. It can be used for enterprise or active data warehousing and even for customer relationship management in large scale organizations and MNCs that cater to a wide variety of clients at the same time.

Pre-requisites for this course include Basic Knowledge in SQL & General relational database along with basic unix commands.