TERADATA Course

by Vibrant Technologies & Computers

Module

Title

Contents

Module 1:

TERADATA Architecture

Parsing Engine(PE)
Request and Response Parcel
Access Module Processors (AMPs)
Bynet
Data access Handling
TD Config Utilities
Config and Reconfig

Module 2:

TERADATA Database Space

Permanent Space
Spool Space
Temp Space
Indexes

Module 3:

DBC Dictionary Tables

Data dictionary
Parsing Engine
System Views
Database Views
DBC Users View
Indices View
All Temp Tables View
Using DBC AMP Usage
Using DBC Table Size
Logon and Logoff Tracking.

Module 4:

Access Rights, Roles, Profiles

Access rights (Auto, implicit, Explicit Rights)
Roles and Profiles
Creating Roles and Profiles
DBC.RoleInfo and DBC.ProfileInfo

Module 5:

Query analysis and Tools

Database Query Log (DBQL)
DBQL Tables and Views
Access Logging

Module 6:

System Access Control Levels

TD Password Encryption
Password Security Features
Host Logon Processing
GRANT/REVOKE LOGON
Session Related Views
DBC.sessionInfo Info View
Data Access Info Views
Access LogRules Views
Access Log Views

Module 7:

TD Manager

TD Manager Apps
TD Dashboard
Priority Scheduler Admin
TD Manager Service
Starting TD Manager

Module 8:

Monitoring tools

Performance Monitor
PMON Main window
PMON sessions Screen
TD Administrator
TD manager Dynamic Utilization Charting
Locking Logger

Module 9:

TD Remote Console Utilities

Starting DB Window
QRYCONFIG
QRYSESSN
RCVMANAGER
SHOWLOCKS
VPROCMANAGER
SHOWSPACE
SHOWBLOCKS
PACKDISK
SCANDISK

Module 10:

Archiving Data

Archive and Recovery Statements
Recovery vs. FastLoad
Invoking Archive
Restart Log
ANALYZE Statement
Archive
Database DBC Archive
Indexes option
Database DBC Archive
Archive and Recovery (ARC) Examples

Module 11:

Restoring data

Restore
COPY
Copying Tables