Stepleaf'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.
Jul 25 | Sat,Sun (6 Weeks) Weekend Batch | Filling Fast 03:00 PM 05:00 PM |
Can't find a batch you were looking for?
Stepleaf'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 Objectives
After the completion of the Mastering Teradata course at Stepleaf, 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.
Who should go for this training?
The course is designed for all those who want to learn Teradata.
Pre-requisites
Pre-requisites for this course include Basic Knowledge in SQL & General relational database along with basic unix commands.
etc., RDBMS, Teradata, PE, BYNET, AMP, Teradata Indexes, Join Strategies, Teradata SQL, Data Protection, SQL Advanced, performance optimization, Teradata Utilities, FastLoad, BTEQ, FastExport, TPT
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.
Structure your learning and get a certificate to prove it.
What are the system requirements for this course?
RAM of 4 GB and Disk Space of 10GB with dual core CPU.
How will I execute the practicals?
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.
Which Case-studies will be a part of the course?
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:
All the instructors at StepLeaf are practitioners from the Industry with minimum 10-12 yrs of relevant IT experience. They are subject matter experts and are trained by StepLeaf for providing an awesome learning experience to the participants.