FOR FREE DEMO contact :



Email : info@ibasetraining.com



Phone/WhatsApp : +91-8106721223



USA Number : +1-650-993-1007



Gtalk : ibasetraining@gmail.com



WebSite: http://www.ibasetraining.com



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

TERADATA DBA COURSE OUTLINE / AGENDA
(the course content can be modified as per your requirements):

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 the following content please follow the link: http://ibasetraining.com/teradata-hands-on-online-training-job-support-from-india/