Teradata DBA Online Training
Duration: 25 Hours
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.
Module4: (Access Rights, Roles, Profiles)
Access rights (Auto,implicit,Explicit Rights)
Roles and Profiles
Creating Roles and Profiles
DBC.RoleInfo and DBC.ProfileInfo
Module 5: (DBSize Control)
DBS Control record –General Fields
DBS Control record — File system Fields
DBS Control record — Performance Fields
DBS Control record — Performance Columns
Module 6: (Query analysis and Tools)
Database Query Log (DBQL)
DBQL Tables and Views
Access Logging
Statistics Wizard
Index Wizard
TSET
Module 7: (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 8: (Priority Scheduler)
PS(Priority Scheduler) Partition Hierarchy
PSH Def
Resource Partition Examples
Multiple resource Partition Example
Scheduling Policies
Performance Periods
Module 9: (TD Manager)
TD Manager Apps
TD Dashboard
Priority Scheduler Admin
TD Manager Service
Starting TD Manager
Enable Data Collection
Module 10: (Monitoring tools)
Performance Monitor
PMON Main window
PMON sessions Screen
TD Administrator
TD manager Dynamic Utilization Charting
Alert Facility and Viewer
Locking Logger
Module 11: (TD Remote Console Utilities)
Starting DB Window
QRYCONFIG
QRYSESSN
RCVMANAGER
SHOWLOCKS
VPROCMANAGER
SHOWSPACE
SHOWBLOCKS
PACKDISK
SCANDISK
Module 12: (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 13 (Restoring data)
Restore
COPY
Copying Tables
BUILD
RELEASE LOCK
Other Features We provide:
FAQS
Concentration on performance tuning
Real time scenarios
Certification guidance
Resume preparation
Sample resumes
Interview & certification FAQS
How to face the interview
Class notes which is useful for who is trying for job
Project preparation
Teradata DBA Online Training
Click here to know more details on Teradata DBA online training