+91 8142000093 info@tanviinfo.com

Teradata DBA

TIS_Teradata DBA

Teradata DBA

Course Duration : 40 Hours
Course Delivery : Classroom, Online, Weekends

Course Content

TERADATA Architecture
• Parsing Engine(PE)
• Request and Response Parcel
• Access Module Processors (AMPs)
• Bynet
• Data access Handling
• TD Config Utilities
• Config and Reconfig
TERADATA Database Space
• Permanent Space
• Spool Space
• Temp Space
• Indexes
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.

Access Rights, Roles, Profiles
• Access rights (Auto,implicit,Explicit Rights)
• Roles and Profiles
• Creating Roles and Profiles
• DBC.RoleInfo and DBC.ProfileInfo
Query analysis and Tools
• Database Query Log (DBQL)
• DBQL Tables and Views
• Access Logging
System Access Control Level
• 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
TD Manager
• TD Manager Apps
• TD Dashboard
• Priority Scheduler Admin
• TD Manager Service
• Starting TD Manager

Monitoring tools
• Performance Monitor
• PMON Main window
• PMON sessions Screen
• TD Administrator
• TD manager Dynamic Utilization Charting
• Locking Logger
TD Remote Console Utilities
• Starting DB Window
• QRYCONFIG
• QRYSESSN
• RCVMANAGER
• SHOWLOCKS
• VPROCMANAGER
• SHOWSPACE
• SHOWBLOCKS
• PACKDISK
• SCANDISK
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
Restoring data
• Restore
• COPY
• Copying Tables
• BUILD