| Courses Basic Computer Training / Software Training / Application Programming | Locality Hitech City |
Teradata realtime online training, job Support & interview support by hands-on working faculty
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 : [email protected]
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : [email protected]
Blog: http://apex-it-online-trainings.blogspot.in
Website: www.apex-online-it-trainings.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