Training Index – TD 14 Topics Included

Session 1 – Teradata Introduction and Architecture 

This session is the introductory session which also cover the Logical and Advanced architecture of Teradata. In this session we share the step by step procedure to download and install the Teradata Database from teradata website.

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 cover topics about space and different Fault Tolerance feature of Teradata. From the DBA or Developer point of view, these features are 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 2 of its main indexes i.e. Primary Index and Secondary Index.

Duration – 3 Hrs

  • 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 cover other important indexes in Teradata and will also look into the reading of Explain Plan which is one of the most important aspect in Teradata Development Projects.

Duration – 2 Hrs

  • 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 development Project. 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. Will cover each utility with full hands on and practical sessions.

Duration – 4 Hrs

  • Fastload
  • Multiload
  • BTEQ
  • Fastexport
  • TPT *New
  • 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 real time Teradata Development Project across globe. Also will cover the complete solution of case study.

Duration – 2 Hrs

  • Best Practices in Teradata development project
  • Real life DW project examples
  • Case Study Solution

 

Total Training Hours with Live trainer support – 20 Hrs.