FOR FREE DEMO contact :
India(M): +91-8500-122-107 ,(whats app)
Land line +919988663117
Gtalk: raavi.sriraja@gmail.com
Email: raj@apexonlinetraining.com
WebSite:www.apexonlinetraining.com
Teradata DBA Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided
TERADATA DBA COURSE OUTLINE / SYLLABUS
(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
No comments:
Post a Comment