HOT LINE:

+919019191856

+1 (201) 720-5410 (USA)

My Cart

0

Teradata

 

We're here to help you. Drop Us a Query !


  

Training Mode: Class Room / Live Online


Need Help? please call us on +919019191856 or Click Here to send us an Enquiry

QUICK OVERVIEW

Teradata Training in Bangalore - Live Online & Classroom

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.

myTectra the Market Leader in Teradata training in bangalore

myTectra offers Teradata training using Class Room. myTectra offers Live Online Teradata training Globally.

 

Course Objectives
After the completion of the Mastering Teradata training course at myTectra, 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 Course?
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.
Why learn Mastering Teradata?
Teradata provides market leading data and analytics platform. Built from scratch using parallelism, Teradata has been 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.
What are the pre-requisites for this Course?
The pre-requisites for this course include basic Knowledge in SQL, General relational database knowledge and basic unix commands.
Which Case-Studies will be a part of the Course?
Towards the end of the Course, you will be working on a live project where you will be using the provided datasets to build Customer Segmentation application.
Project #1 : Customer Segmentation Application Industry : Retail Data : Sales Data, Customer Data Problem Statement : Creation of Fastload/MultiLoad/TPT/BTEQ scripts to build Customer segmentation application

1. Teradata - An Overview
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.
2. Teradata Indexes and Join Strategies
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.
3. Teradata SQL
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).
4. Data Protection
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.
5. SQL Advanced
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.
6. Advanced Database objects and performance optimization
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.
7. Teradata Utilities - FastLoad, MultiLoad, BTEQ
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.
8. Teradata Utilities - FastExport,TPT
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.

To Learn Live Online Teradata training Globally and Teradata training in Bangalore using Class Room, ENROLL TODAY at myTectra.


Customer Reviews

1 Item(s)

per page
Good institute Review by Sadegh
Price
Quality
Value
I completed Teradata course in mytectra. The faculties are experts in teaching.

1 Item(s)

per page

Only registered users can write reviews. Please, log in or register

brand
myTectra Stands for Quality Training and provides training using Experienced professionals on the Respective Technologies and who has a good teaching expertise.


We're here to help you. Drop Us a Query !


  

WHY DO YOU AWAIT FOR FIXED SCHEDULES ? CHOOSE MYTECTRA LEARN AT YOUR CONVENIENT TIME

myTectra flexible batch schedules enables you to start your class at your convenient date and time.


1. All the enrolled candidates must start the class by any date within 30 days from the date of enrollment.
2. Maximum of 3 Days will be taken by myTectra to schedule the batches from the date of schedule request from the candidate.
3. Individual Focus - Maximum 5 candidates allowed per batches
4. The candidate can request any one of the batch time slot from the below list
Batch Type Time Slab Hours/Day Time Zone Days
Regular Morning 6.30 AM - 9.30 AM Anytime Maximum 2 Hrs IST Monday-to-Friday
Regular Evening 6.30 PM - 9.30 PM Anytime Maximum 2 Hrs IST Monday-to-Friday
Week End 6.30 AM - 9.30 PM Anytime Maximum 3 Hrs IST Saturday,Sunday
Fast Track-Morning 6.30 AM - 9.30 AM Anytime Maximum 2 Hrs IST Monday-to-Saturday
Fast Track-Evening 6.30 PM - 9.30 PM Anytime Maximum 2 Hrs IST Monday-to-Saturday
Customized Batch Customized Timing Customized Hrs IST Customized Days

Note : We can schedule your batch anytime on Saturday and Sunday between 6.30 AM 9.30 PM at your convenient time


Do you have any questions ? please call us on +919019191856 or email to [email protected]