Course Content

1.Intoduction
What is DWH and Applications
Role of Teradata In DWH
Advantages of Terada over other RDBMS
Evolution of Teradata
2.RDBMS Concepts
TD Instalation
RDBMS Concepts
3.Architecture
Hardware components
Node Architecture(Shared Architecture)
SMP Architecture
MPP Architecture
Parsing engine(PE) Architecture
AMP Architecture &uses
Bynet Benefits &types
Parallel data extension(PDE)
Teradata directory program(TDP)
Call level interface(CLI)
Trusted parallel application(TPA)
Virtual processors
Parallism Architecture
Perm,spool,temp spaces
4.TERADATA INDEXES
Types of indexes in Teradata
Primary indexes(unique, non- unique, NO PI)
Secondary indexes(unique, non- unique)
Partition Primary Indexes
Join indexes
Skew factor
5.Data protection
Fallback
Clique
Cluster
Journals
Locks
Raid
6.Teradata SQL
Teradata Objects
Teradata Extensions
Operators and expressions
Functions
SET operators
Datatype conversions
7.Advanced SQL
Ranking
Qualify
Case
Coalesce
8.Utilities
Sql Assistant
Bteq
Fastload
Fast Export
Multi load
TPT
9.Database Adminstration
Space mangement
User management
Roles/accessrights management
Profiles management
Quering DBC tables
10.Performance monitoring
Tdmanager
Pmon
11.Tools
Teradata Adminstrator
stats wizard
Index wizard
DBQL
12.Backup/Restore
Arcmain
Backups
Restores
Copy
13.Performace Tuning
Explain
Stats
Troubleshooting