Demo Video

watch TeraData Demo Video

About Trainer

  • Trainer Information
  • Teradata Architect with 13+ Years of experience in information technology with exposure to Data warehousing, Mainframes, Unix and Big Data
  • 9 years of extensive experience in data warehousing with primary focus on Teradata
  • Have worked with Accenture and Wipro for clients from USA, Singapore, UK and Australia
  • Have worked in USA for 6 years and currently working for a major bank in Sydney, Australia
  • Core Concepts of Teradata online course:
  • Memory Spaces
  • Transaction Modes
  • Performance Tuning
  • Teradata Utilities and Tools

Course Outlines

TeraData Course Curriculum

Click Here for a Complete Course Contents

  • Course Duration : 25 Hours
1. Teradata Introduction
  • Teradata Introduction
  • Teradata Advantages
  • Teradata Tools & Utilities
  • Teradata Installation
  • Teradata Tools & Utilities Installation

2. RDBMS/Data warehousing Basics

  • RDBMS Basic Concepts (Tables/Rows/Columns/Primary Key/Foreign Key)
  • What is data warehouse
  • OLTP Vs Data warehouse
  • Data warehouse Architecture

3. Teradata Architecture

  • Teradata Components (Parsing Engine, BYNET, Access Module Processor)
  • How Teradata components interact with each other
  • Storage & Retrieval architecture
  • System architectures
  • What is a Node

4. Basic SQL

  • Data types
  • DDL statements(CREATE,DROP,ALTER)
  • DML statements (SELECT, INSERT,UPDATE,DELETE)
  • SET Operators(UNION , UNION ALL, INTERSECT, MINUS)
  • Logical & Conditional Operators
  • String Manipulation
  • Date & Time Manipulation
  • Joins
  • Built-in functions
  • Aggregates
  • Explain plan

5. Indexes

  • Primary Index (UPI, NUPI)
  • Secondary Index (USI, NUSI)
  • Partition Primary Index

6. Teradata Objects

  • SET vs MULTISET tables
  • Derived Tables
  • Volatile Tables
  • Global Temporary Tables
  • Views
  • Macros
  • Stored Procedures
  • Single Table Join Index
  • Multi Table Join Index
  • Aggregate Join Index
  • Space concepts (Perm, Spool, Temp)
  • Triggers

7. Advanced SQL

  • Subqueries
  • Coalesce
  • OLAP Functions (Rank, Row_Number, Qualify, Partition by, Rows Unbounded preceding/following)
  • Compression
  • Collect Statistics
  • DBC tables
  • Teradata Transaction Modes

8. Utilities

  • FastLoad
  • MultiLoad
  • BTEQ
  • FastExport
  • TPT

9. Data Protection

  • Fallback
  • Clusters
  • Clique
  • RAID

10. Performance Optimization

  • Join Strategies
  • Confidence levels
  • Statistics collection process
  • Performance tuning techniques

11. Interview Questions

Course Info

  • Training is provided in Teradata 15 versions
  • Training covers using Teradata within both Windows and Unix environment
  • In addition to live training, participants will get the recorded session
  • Participants will get Teradata installation document, SQL Assistant user guide, Teradata SQL document covering syntax and examples, Teradata utilities document covering Fastload, Multiload, FastExport, BTEQ and TPT with comprehensive examples

Learn TeraData

TeraData Job Trends

TeraData USA Job Trends
TeraData India Job Trends