Embedded Files
TeraData Training online course makes you an expert in using teradata and how to control database space, business analytics solutions, bigdata analytics, integrated data warehousing, advanced teradata sql concepts, etc.
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: https://best-online-it-training-institute.blogspot.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
Google Sites
Report abuse