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)
|
