Thanks for applying for scholarship test.
Our career counsellor will inform you soon regarding the test details.
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
|Mar 14 th||
|May 08 th||
Course Price at
Can’t find a batch you were looking for?
Your details have been successfully submitted. Our learning consultants will get in touch with you shortly.
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.
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.
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.
Edureka’s Data Warehousing Professional using Teradata Certificate Holders work at 1000s of companies like
Best in class-Learning. Edureka! I really donno what that name mean. But, This means a lot for Learners. i was working in a company(sorry i cant tell the name) they used to scold me that iam nothing as my skills are not upto date. I hold 8 years of experience and felt so shy to go for Trainings at some Locations. Edureka with there best support and service helped me to upgrade very easily. Thanks to them
I have taken two courses (Informatica and Teradata) through Edureka. I think this is best online training platform that I had ever taken. I am very happy for getting trained from EDUREKA. The overall course is very much organized (Awesome). All the labs were on real time solution. After the training, I was confident to pursue my career in informatica and with a month I got a full time opportunity as a informatica developer. There was separate interview preparation session which really helps me to crack the informatica interview. Next, I am planning to take Big Data class. My overall experience with the edureka was awesome. I highly recommend everyone to join Edureka whoever is interested in learning online. Thank you Edureka!!
Definitely there is no doubt in saying that all the instructors at Edureka are industry experienced and the support staff provides a quick response to the tickets you log whether it be Day or Night. I like the way the sessions have been organized, with the Pre-requisites required for the next session and the assignments, QUIZ post session etc...I like the LMS a lot, You can find enough of required information in the forums. They even share the video recordings of other instructors as well in the LMS. So that if one couldn't get the content clearly in your session, you can always refer to other instructors recordings shared in your LMS. This part helped me in understanding few concepts in a better way.
I have done Spring Framework and Hadoop framework training from Edureka. I am very happy with the training and help they are providing.The sessions were very informative. The instructors are highly knowledgeable.They provide a set of videos from a previous session, so you can watch the course before you participate. This way you can get the most out of the course.Excellent Customer Service starting with signing up of the course. I really appreciate Edureka Support team. They are really doing a fantastic job. All my queries were answered properly and promptly.You get recording of the classes, presentations and labs in LMS. And good feature is you have lifetime access to LMS of course you have taken, so you can refer, revise any topic when you want.I can safely say Edureka is one of the best training company.
Edureka has been an unique and fulfilling experience. The course contents are up-to-date and the instructors are industry trained and extremely hard working. The support is always willing to help you out in various ways as promptly as possible. Edureka redefines the way online training is conducted by making it as futuristic as possible, with utmost care and minute detailing, packaged into the a unique virtual classrooms. Thank you Edureka!
I have been using Edureka for learning different topics related to Big Data -Hadoop, PIG, HIVE, Cassandra. I am very happy with the training and the help they are providing and I feel better than another online training where I registered for Cassandra. One of great thing is we can download the videos and references for later use, I use these in my commute to work (usually spend 2.5 hrs in train). Thank you for being flexible and proving great opportunity to learn cutting edge technologies - Cheers
Get a Glimpse of the course