TERADATA DBA HANDS-ON LIVE ONLINE TRAINING,CORPORATE TRAINING,INTERVIEW & JOB SUPPORT BY SOFTWARE EXPERTS

FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in

TERADATA Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided

Course Outline (we can customize the course agenda as per your requirements)

TERADATA DBA 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



FOR More Details contact us at:
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in