About us   Registration   Site map    
 
         
   
      New user|Forgot password  
 
   
 
 
Select Your Country to check the Schedule for this Course
Country:  
Time Zone:
   
PAYMENT METHODS
PAYPAL GOOGLE CHECKOUT
Course Name Course Code
Teradata 97
Course Contents

 

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 Administrator

                    1. How to increase spaces.

                    2. To grant permissions.

                    3. To create table.

Chapter 17: Performance monitoring (PMON)

 

PAYMENT METHODS
PAYPAL GOOGLE CHECKOUT