Teradata live online corporate training Support 8500122107

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