1.    Introduction to Teradata

            What is Data Warehousing?

            OLTP,OLAP

            What is Active Data Warehousing?

            Data Mart, Independent, Dependent, Logical

            What makes Teradata Unique? Key Features

            What is RDBMS?

2.     Teradata Architecture

            Components of Teradata

-         Node

-         Bynet

-         AMP

-         Parsing Engine

-         PDE

-         Teradata Gateway

-         Channel Driver

-         Application

-         Vdisk

-         Host Channel Adapter

-         Ethernet Card

-         OS

            SMP

            MPP

            AWS

            TPA

            VPROC

            Clique

            Cluster

            Fallback

3.    Teradata Indexes

            Primary Indexes—UPI,NUPI

            Secondary Indexes –USI,NUSI, Join Indexes, Sparse Indexes, Hash Index

4.    Teradata Administrative Tools

            Teradata Manager

            Teradata Dynamic Query Manager(TDQM)

            Teradata Analyst Pack

5.    Teradata objects

            Database

            Users

            Tables

            Macros

            Procedures

            Triggers

6.    Logical Database Hierarchy

            Access Rights

            Perm Space

            Spool Space

            Temp Space

            Database Crashdumps

            User System FE

            User SysAdm

7.    Teradata Load/Unload Utilities

            BTEQ

            Fastload

            Multiload

            TPUMP

            FastExport

8.    Teradata Specific Features

            Explain Feature

            Collect Statistics

            Permanent Journal

            PPI

9.    Teradata SQL

          9.1  OLAP Functions  

          9.2   Reporting Totals and Subtotals

          Totals and Subtotals
          Totals (WITH)
          Subtotals (WITH…BY)
          Multiple Subtotals on a Single Break
          Multiple Subtotal Breaks

10.                        Teradata Query Optimization

      11.  Performance Tunning