TERADATA DBA ONLINE TRAINING
TERADATA DBA ONLINE TRAINING
Course Duration:
30 Hours
Delivery type: Instructor-led online training
FOR FREE DEMO contact us at:
Email: info@apex-online-it-training.com
ABOUT THE TRAINER
- 8 YEARS OF INDUSTRY EXPERIENCE
- 5 YEARS OF EXPERIENCE IN ONLINE AND CLASSROOM TRAINING
TERADATA DBA Course ONLINE TRAINING COURSE CONTENT
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: (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
·
Ø BUILD