Home All Courses Business Intelligence & Visualization Teradata Certification Training

Teradata Certification Training

Edureka's Teradata Training will help you become an expert in developing Data Warehousing applications using Teradata while working on real time use cases and projects. After this training, you can clear TEO-141 and TEO-142 Teradata certification.


Watch the demo class

Why this course ?

  • Teradata : Leader in 2016 Gartner Magic Quadrant for Data Warehouse & Data Management Solutions for Analytics (14 Times)
  • Cisco, Dell, Boeing, P&G, Netflix, Siemens, Volvo & other Fortune 500 companies use Teradata
  • Teradata professionals earn upto $110,000 per year - PayScale.com
  • 2K + satisfied learners. Reviews

Instructor-led live online classes

19

Aug
Sat - Sun ( 4 Weeks )
11:00 AM - 02:00 PM ( EDT )
10% Off
17995
16195

22

Sep
Fri - Sat ( 4 Weeks )
09:30 PM - 12:30 AM ( EDT )
10% Off
17995
16195

Edureka For Business

Train your employees with exclusive batches and offers and track your employee's progress with our weekly progress report.

Instructor-led Sessions

24 Hours of Online Live Instructor-led Classes. 
Weekend class : 8 sessions of 3 hours each.

Real-life Case Studies

At the end of the course, you will work on a live project where you will use datasets to build Customer Segmentation application.

Assignments

Each class will be followed by practical assignments which aggregates to minimum 40 hours.

Lifetime Access

Lifetime access to Learning Management System (LMS) which has class presentations, quizzes, installation guide & class recordings.

24 x 7 Expert Support

Lifetime access to our 24x7 online support team who will resolve all your technical queries, through ticket based tracking system.

Certification

Edureka certifies you as a 'Data Warehousing Professional using Teradatabased on your project performance, reviewed by our expert panel.

Forum

Access to global community forum for all our users that further facilitates learning through peer interaction and knowledge sharing.

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.

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

1. Understand Teradata's competitive advantage over other RDBMSs. 

2. Understand Teradata Architecture and Indexing mechanism. 

3. Use SQL to process data stored in Teradata tables. 

4. Use Teradata application utilities to import/export data. 

5. Apply various performance turning techniques to optimize the queries.

Teradata is one of the largest players in the data warehousing market.

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.

The 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. 

Read More on The Growing Prominence Of Teradata Among Data Enthusiasts

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

1. Developers/Designers who want to gain acceleration in their careers as an Teradata Developer/Designer. 

2. Analytics Managers who are subject matter experts, leading a team of analysts. 

3. Individual Contributors in the field of Enterprise Business Intelligence.

Read more on Everything you wanted to know about a career in Teradata

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

RAM of 4 GB and Disk Space of 10GB with dual core CPU. 
Installation & Configuration is part of the curriculum hence the session will show hands on Installation & Configuration guide. The detailed installation guides are also provided in the LMS for setting up the environment.

The software can be downloaded from the Teradata website, where candidates can create a login id and download the required software.  

In case you come across any doubt, the 24*7 support team will promptly assist you.
At the end of the course, you will work on a Live project using Teradata. 

The project should be able to segment the banking customers according to the business rules defined. 

It should:

  • Segment the customers who hold Saving Accounts, Credit Card accounts and Mortgage accounts & exclude other accounts.
  • Segment the customers based on their balance held in the accounts.
  • Build a target table that contains customers and their corresponding segments. 

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. 

Topics - Basic Relational Concepts, What is Teradata, Competitive advantages over other RDBMS, Teradata Architecture, Teradata Components, How components Interact with each other, How Data is stored and Retrieved, Connectivity with Mainframe and Network Applications, Tools & Utilities, Teradata Unified Data 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.

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 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.

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.

You will never miss a lecture at edureka! You can choose either of the two options:
  • View the recorded session of the class available in your LMS.
  • You can attend the missed session in any other live batch.
edureka is committed to provide you an awesome learning experience through world-class content and best-in-class instructors. We will create an ecosystem through this training, that will enable you to convert opportunities into job offers by presenting your skills at the time of an interview. We can assist you in resume building and also share important interview questions once you are done with the training. However, please understand that we are not into job placements.
We have limited number of participants in a live session to maintain the quality standards. So, unfortunately participation in a live class without enrolment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in the class.
All instructors at edureka are senior industry practitioners with minimum 10 - 12 years of relevant IT experience. They are subject matter experts who trained by edureka to provide impeccable learning experience to all our global users.
You can Call us at +91 90660 20867 /1844 230 6362 ( US Tollfree ) OR Email us at sales@edureka.co . We shall be glad to assist you. 

  • Once you are successfully through the project (Reviewed by a edureka expert), you will be awarded with 'Data Warehousing Professional using Teradata' certificate by Edureka.
  • edureka certification has industry recognition and we are the preferred training partner for many MNCs including e.g. Cisco, Ford, Mphasis, Nokia, Wipro, Accenture, IBM, Philips, Citi, Ford, Mindtree, BNYMellon etc