Courseware: TERADATA                                           Sessions: 25hrs

Chapter 1: Introduction to Teradata

1.   What is Teradata

2.   Advantages and Features of Teradata

3.   Core components of Teradata

4.   SMP (Symmetric Multi processing)

5.   MPP (Massive Parallel Processing)

6.   Teradata Operating systems

7.   PDE

8.   BYNET

a.    Features

b.    Communication Methods

9.   VProcs

10.                AMP

11.                PE

12.                TDP

13.                CLI

14.                ODBC

15.                Versions

a.    S/w versions

b.    H/w versions

Chapter 2: Making virtual disks

1.   LUN

2.   PDISK

3.   VDISK

4.   RAID

5.   RAID 5

6.   RAID1

Chapter 3: Fault tolerance

1.   Soft faults

2.   Hardware faults

3.   Dual Bynet

4.   Fallback

5.   Vproc migration

6.   Amp clustering

7.   Clique

8.   Journaling

                                         i.    Down amp journal

                                        ii.    Transient journal

                                       iii.    Permanent journal

9.   Rollback

Chapter 4: Transaction processing

1.   User query & ODBC/CLI

2.   Parsing engine

                                    a.    Syntaxer

                                    b.    Resolver

                                    c.    Security module

                                   d.    Optimizer

1.      Rule based

2.      Cost based

                                    e.    Step generator

                                     f.    GMC apply

                                   g.    Dispatcher

3.   Explain

      4.   Collect Statistics

Chapter 5: Data distribution and storage

1.   Primary key

2.   Primary index

                                    a.    UPI

                                    b.    NUPI

3.   Hashing algorithm

4.   Skew factor

5.   Secondary Index

                                    c.    USI

                                   d.    NUSI

6.   Example secondary index access

7.   Partition primary index

                                    e.    RANGE_N

                                     f.    CASE_N

Chapter 7: Teradata Objects

1.   DBC

2.   Dictionary objects

3.   Teradata spaces

a.    PERM

b.    SPOOL

c.    TEMP

4.   Teradata tables

a.    SET

b.    MULTISET

c.    GTT

d.   Volatile tables

e.    Derived tables

5.   VIEWS

a.    Updatable

b.    Non updatable

6.   TERADATA SQL

             1. Select

                               2. Help

                               3. Show

                               4. DDl, DML, DCL

Chapter 8: Explanation plan

Chapter 9: Statistics

Chapter 10

Transactions modes

1.   ANSI

2.   BTET

3.   SET SESSION TRANS

Teradata Requests

4.   Single statement request

5.   Multi statement request

6.   Implicit Trans

7.   Explicit Trans

8.   Macros

9.   Parameterized macros

Chapter 11: Join indexes

12: BTEQ

1.   Implementation of business logic

2.   Session control

3.   File control

4.   Sequence control

5.   Format control

6.   BTEQ Exports and imports

7.   BTEQ defaults

Chapter 13: Fast Load

                1. Inserting data to Target from single flat file.

                2. Inserting data to Target from Multiple flat files.                                                                                                                       

Chapter14: Multi Load

                     1. Inserting data to single Target.

                     2. Inserting data to multiple targets

                     3. Diff b/w Error tables and Work table.

Chapter 15: Fast Export

                     1. How to Export data by using single table.

                     2. How to Export data by using multiple tables.

            3. How to write script.

Chapter 16: Teradata Dba Concepts

                    1. How to allocate space to user and database.

                    2. To grant permissions and increase perm space.

                    3. To create table with diff Indexes, Views   and Temporary tables.

                    4. Different Dbc queries to monitor space.

                    5. Dbc tables.

                    6. Teradata Index Wizard.

                    7. To create database with User Defined Journal.

                    8. To drop no of tables at a time by scripting.

                    9.  Performance monitoring (PMON).

                   10.Creation of database by Query and by teradata administrator tool