Teradata Online Training Course Content | Teradata online classes

Teradata Online Training Course Content | Teradata online classes

Teradata Online Training – TD 14

Session 1 – Teradata Introduction and Architecture 

This session is the introductory session which also covers the Logical and Advanced architecture of Teradata.

Duration – 2 Hrs

·         What is Teradata

·         Advantages of Teradata

·         Relational Database

·         TD Logical Architecture

·         PE(Parsing Engine)

·         AMP(Access Module Processing)

·         BYNET

·         TD Advanced Architecture

·         VPROCS(Virtual Processor)

·         VDISK(Virtual Disk)

·         PDE(Parallel Database Extension)

·         TDP(Teradata Directory Program)

·         CLI(Call Level Interface)

·         TPA(Trusted Parallel Application)

·         SMP & MPP Architecture

·         Download/Installation of Teradata Database.

Session 2 – TD Space Management and Data Protection (TD 14 Topics Added)

This session is for DBA role which covers topics about space and different Fault Tolerance feature of Teradata. From the DBA or Developer point of view, these features are the backbone of any database.

Duration – 2 Hrs

·         PERM Space

·         SPOOL Space

·         TEMP Space

·         Types of Tables (Volatile table & Global Temporary Table)

·         Teradata User and Database

·         Types of LOCKS in Teradata

·         RAID Protection (RAID 1 & RAID 5)

·         Transient Journal

·         CLIQUES

·         HSN (Hot Standby Node)

·         FallBack

·         FallBack Clusters

·         DOWN AMP Recovery Journal

·         Permanent Journal

·         Achieving and Recovery Data

Session 3 – Teradata Data Distribution (TD 14 Topics Added)

This session deals with data distribution in Teradata and its main indexes i.e. Primary Index and Secondary Index.

Duration – 4Hrs

·         Data Distribution in Teradata –

·         Row Hash & Row ID

·         Hashing Algorithm –

·         Hash Map and Hash Bucket

·         Uniqueness Value in Teradata

·         Primary index in Teradata

·         UPI (Unique Primary Index)

·         NUPI (Non-Unique Primary Index)

·         Data Retrieval using PI & NUPI

·         Primary Key Versus Primary Index

·         Secondary Index in Teradata

·         USI (Unique Secondary Index)

·         NUSI (Non-Unique Secondary Index)

·         Data Retrieval using USI & NUSI

·         NOPI

Session 4 – Teradata Other Index & Explain Plan (TD 14 Topics Added)

This session covers other important indexes in Teradata and will also look into the reading of Explain Plan which is one of the most important aspects in Teradata Development Projects.

Duration – 3Hrs

·         PPI (Partition Primary Index)

·         MLPPI (Multi Level PPI)

·         Join Index

·         Single table Join Index

·         Multi table Join Index

·         Aggregate Join Index

·         Sparse Index

·         Explain Plan

·         How to Read Explain Plan

·         Main Key words in Explain Plan

Session 5 – Teradata Join Strategy  & Collect Stats 

This session covers how Teradata deals with different types of Joins in SQL. Performance tuning of queries or optimization in Teradata will be covered in this session

Duration – 2 Hrs

·         Inner join

·         Outer Join (Left, Right, Full)

·         Cross Join

·         Data Redistribution

·         Types of Join in Teradata

·         Merge Join

·         Nested Join

·         Row Hash Join

·         Product Join

·         Collect Stats

·         High, Low & No Confidence

·         Teradata SQL Performance Tuning.

Session 6 – Teradata SQL 

This session deals with SQL which we used in Teradata. Major emphasis will be on the SQL or functions which is specific to Teradata and helps in writing a complex and fine tune query.

Duration – 2 Hrs

·         Data Types

·         String Functions

·         Format Functions

·         Cast Functions

·         Date Functions

·         Coalesce

·         Group & Aggregate Functions

·         Qualify

·         Row Number & Rank

·         Partition By

 Session 7 – Teradata Utilities 

This session covers main utilities of Teradata. These utilities are extensively used in any Teradata development project for ETL jobs.

Duration – 4 Hrs

·         BTEQ

·         Fastload

·         Multiload

·         Fastexport

·         TPUMP

·         TPT

·         Advantage/Disadvantage of each utility.

·         Practical session with each utility.

·         Hands on Questions

 Session 8 – Teradata best Practices

After finishing full training in Teradata, in this session will provide best practices going on in Teradata.

Duration – 1Hrs

·         Best Practices in Teradata ·         Some few important Topics

Share this post

Leave a Reply

Your email address will not be published. Required fields are marked *