Course Description
This course will introduce you to the fundamentals of working with Teradata. In this, you will learn about Teradata architecture, the indexing mechanism and the various SQL queries that will allow you to retrieve and perform manipulations on your data. You will also learn about the various Teradata utilities such as Fast Load and Multi Load and how they are used to import data into Teradata.
Prerequisites
Participants are expected to have basic Knowledge in SQL, general relational database knowledge and basic Unix commands.
Target Audience
The following job roles will be benefited from this training:
- Developers/Designers who want to gain acceleration in their careers as a Teradata Developer/Designer.
- Analytics Managers
- Enterprise Business Intelligence Professionals
Learning Objectives
Upon accomplishment of this training, you will be able to:
- Comprehend Teradata architecture and indexing mechanisms
- Comprehend the competitive advantages of Teradata over other RDBMSs
- Use Teradata application utilities for importing/exporting data
- Understand how to process data in Teradata tables utilizing SQL processes
- Implement performance tuning techniques and optimize queries
Content Outline
- What is Teradata
- Overview of Teradata
- Data warehouse concepts
- Teradata Architecture
- SMP Architecture
- MPP Architecture
- AMP(Access Module Processing)
- TDP(Teradata Directory Program)
- CLI(Call Level Interface)
- TPA(Trusted Parallel Application)
- Parallelism Architecture
- Benefits and Types
- RAID 1&RAID 5
- Disk Arrays
- Fall Back
- Clique
- AMP Clustering
- Journaling
- Answering various recovery questions
- Primary Index
- Unique
- Non unique
- Partitioned
- Secondary Index
- Unique
- NonUnique
- Hash, Join, Value Ordered
- Skewness
- Secondary Index Sub table
- Accessing Records via Primary Index
- Accessing records via Secondary Index
- Keys Vs Indexes
- Full Real time scenarios and explaining
- SQL Fundamentals
- Data Types and Literals
- Data Definition Statements(DDL)
- Data Manipulation Statements(DML)
- Explaining with proper examples
- Format Function
- Cast Functions
- Group & Aggregate Functions
- With & with by clauses
- Practices of this section
- Inner Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
- Detailed explanation
- Join Strategies
- Product Join
- Merge Join
- Questions of this section
- HELP
- SHOW
- EXPLAIN
- COLLECT STATISTICS
- Tables
- SET table
- Multi Set table
- Volatile tables
- Global Temporary tables
- Derived tables
- Views
- Macros
- Stored Procedures
- Triggers
- Practices and FAQs of this session
- PERM space
- SPOOL space
- TEMPORARY space
- Teradata User and managing
- Practical Examples
- BTET
- ANSI
- Interactive
- Batch
- How to use Sql Assistant
- Query Processing
- Importing and exporting
- Teradata BTEQ
- Batch Scripts with samples
- Branching and Looping
- Importing data through scripts
- Exporting data through scripts
- Error handling
- Explanation with proper debugging
- Teradata Fast Load
- Various Phases of Fast Load
- Advantages and Process
- Limitations of Fast Load
- Sample Scripts
- Teradata Multi Load
- Various Phases of MultiLoad
- Advantages and Process
- Limitations of Multi Load
- Working with multiple tables
- Applying various operations
- Sample Scripts
- Teradata Fast Export
- Advantages and Process
- Limitations of Fast Export
- Sample Scripts
- Advantages and Process
- Teradata Parallel Data Pump
- Limitations of TPump
- Overview of TPump
- Sample Scripts
- Utility Vs Parallelism
- Difference between Multiload and T pump
- Performance Tuning and Explain Utility
- Explain Usage
- Collecting Statistics
- Tuning SQL Performance
- Explaining various SQL statements
- Retail or Banking or Health care Project Architecture
- Teradata relation with Informatica
- How to run Teradata scripts in Unix
- Sample Real time scripts walk through.
- Interview guidance.
FAQs
To attend the training session you should have an operational Desktops or Laptops with required specification along with good internet connection to access the labs.
We would always recommend you to attend the live session to practice & clarify the doubts instantly and get more value from your investment. However, due to some contingency if you have to skip the class Radiant Techlearning would help you with the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption and NOT for distribution or any commercial use.
Radiant Techlearning has a data center containing the Virtual Training environment for the purpose of participant’s hand-on-practice.
Participants can easily access these labs over Cloud with the help of remote desktop connection.
Radiant virtual labs provide you the flexibility to learn from anywhere in the world and in any time zone.
The learners will be enthralled as we engage them in real world and industry Oriented projects during the training program. These projects will improve your skills and knowledge and you will gain better experience. These real time projects, they will help you a lot in your future tasks and assignments.