Tera Data Certification Training

Teradata Solutions Architect Training

OL Tech Edu 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.

Sports, Citrix, UST Global, Mindtree, TCS, Wipro, Infosys & other MNC's use Azure across industries.

Microsoft Aims for $20 Billion Cloud Sales Run Rate in 2018 - Satya Nadella, CEO.

Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Teradata Certification Training UpComing Batches

Nov-22 - Jan-03

Weekend
SOLD OUT

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Nov-15 - Dec-27

Weekday
SOLD OUT

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Dec-04 - Jan-15

Weekend
FILLING FAST

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Dec-11 - Jan-22

Weekday
FILLING FAST

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Dec-18 - Jan-29

Weekend

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Dec-25 - Feb-05

Weekday

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now
Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Course Curriculum

Teradata Certification Training

SELF PACED

OL Tech Edu'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.

  • WEEK 5-6
  • 10 Modules
  • 6 Hours
Developing Data Warehousing Applications

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.

Program Syllabus

Curriculum

You can also view the program syllabus by downloading this program Curriculum.

Course Description

Course Certification

OL Tech Edu’s Certificate Holders work at top 500s of companies like

certificate

Features

Explore step by step paths to get started on your journey to Jobs of Today and Tomorrow.

Instructor-led Sessions

30 Hours of Online Live Instructor-Led Classes.
Weekend Class : 10 sessions of 3 hours each.

Real Life Case Studies

Real-life Case Studies

Live project based on any of the selected use cases, involving implementation of the various real life solutions / services.

Assignments

Assignments

Each class will be followed by practical assignments.

24 x 7 Expert Support

24 x 7 Expert Support

We have 24x7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.

Certification

Certification

Towards the end of the course, OL Tech Edu certifies you for the course you had enrolled for based on the project you submit.

Course FAQ's

Enroll, Learn, Grow, Repeat! Get ready to achieve your learning goals with OL Tech Edu View All Courses

© 2015 - 2021 OL Tech Edu. All Rights Reserved.
Designed, Developed & Powered by MNJ SOFTWARE

The website is best experienced on the following version (or higher) of Chrome 31, Firefox 26, Safari 6 and Internet Explorer 9 browsers