After the completion of the Mastering Teradata course at Lemuria, you will be able to:
- Teradata Architecture
- Teradata SQL and Advanced SQL.
- Teradata application utilities.
- Teradata Application performance turning techniques
The course is designed for all those who want to learn Teradata.
1. Developers.
2. Designers.
3. Analytics Managers .
1. Teradata provides market leading data and analytics platform with Parallel Architecture.
2. Teradata Database is Market Leaders in store (Petabytes) and reteriving Structured Data faster.
3. Teradata provides Analytics platform and connectors to integrate seamlessly with Hadoop.
The pre-requisites for this course include basic Knowledge in SQL, General relational database knowledge and basic unix commands
1. Introduction to the Teradata Database
2. Teradata SQL & Advanced SQL
3. Teradata Application Utilities
Duration : 20 Hours
Module OverviewIntended for technical audiences, this Module provides a detailed overview of the features, functions and benefits of the Teradata database. Among the topics taught are data distribution, access, storage, and data protection methods.
Module ObjectivesAfter successfully completing this Module, you will be able to:
• Describe the purpose and function of the Teradata Database • Understand relational table structures using Primary Keys and Foreign Keys • List the principal components of the Teradata Database and describe their functions • Understand the hierarchy of database objects and space management • Describe the function of the Primary Index and the Secondary Index • Know how data distribution and data access mechanics work in the Teradata Database • Describe the Teradata Database features that provide fault tolerance
Module 2: Teradata SQL& Advanced SQLDuration : 20 Hours
Module OverviewThis Module offers practical, hands-on experience with retrieving and manipulating data with Teradata Structured Query Language (SQL) using both ANSI standard conventions and Teradata extensions to the language and Performance Tuning
Module ObjectivesAfter successfully completing this Module, you will be able to:
• Use Teradata’s HELP facilities to retrieve information about your company’s data structures • Write SELECT statements using inner and outer joins • Write SELECT statements using correlated and noncorrelatedsubqueries • Write queries in the SQL programming language that access single and multiple tables • Understand and use Date, Time and Timestamp • Understand and be able to work with Teradata data types • Write SQL to produce totals and subtotals in reports using aggregation operators • Create and use temporary data structures , Use various forms of derived, volatile and global temporary tables • Work with the Window Aggregate and Extended Grouping functions • Use the ANSI Merge syntax to merge data from source to target • Write SQL using the RANK, QUANTILE and WIDTH_ BUCKET analytic functions • Explain Terminology and Performance Tuning
Module 3: Teradata Application UtilitiesDuration : 20 Hours
Module OverviewThis practical Module explores the concepts and use of BTEQ, FastLoad, MultiLoad, TPump and FastExport, including writing scripts for importing and exporting data in a Teradata environment. These utilities include performing SELECT, INSERT, UPDATE, DELETE and UPSERT operations in batch and real-time environments using the Teradata application utilities for maximum performance and efficiency. Extensive hands-on labs help reinforce learning.
Module ObjectivesAfter successfully completing this Module, you will be able to:
• Identify and state the purpose, features and usage of each data LOAD utility (BTEQ, FastLoad, MultiLoad, and TPump) • Identify and state the purpose, features and usage of each data UNLOAD utility (BTEQ and FastExport) Identify where the Application utilities should be installed and configured on a Teradata system • Code batch scripts to IMPORT data into the Teradata Database and EXPORT data to the host from the Teradata Database using BTEQ • Features, benefits and usage of the Support Environment commands that are used with the MultiLoad, TPump, and FastExport utilities • Know the ETL role of TPT in loading/unloading a Teradata database • Understand the basic statements of a TPT script, such as: DEFINE JOB, DEFINE OPERATOR, DEFINE SCHEMA, and APPLY Define all TPT
At the end of your course, you will work on a real time Project. You will receive a Problem Statement along with a dataset to work.
Once you are successfully through with the project (reviewed by an expert), you will be awarded a certificate with a performance based grading.
If your project is not approved in 1st attempt, you can take additional assistance to understand the concepts better and reattempt the Project free of cost.
At the end of your course, you will work on a real time Project. You will receive a Problem Statement along with a dataset to work.
Once you are successfully through with the project (reviewed by an expert), you will be awarded a certificate with a performance based grading.
If your project is not approved in 1st attempt, you can take additional assistance to understand the concepts better and reattempt the Project free of cost.