IT Training /Certification /Consulting - Bangalore

Growmind Solutions

TERADATA Course

ModuleTitleContents
Module 1: TERADATA ArchitectureParsing Engine(PE)
Request and Response Parcel
Access Module Processors (AMPs)
Bynet
Data access Handling
TD Config Utilities
Config and Reconfig
Module 2: TERADATA Database SpacePermanent Space
Spool Space
Temp Space
Indexes
Module 3: DBC Dictionary TablesData 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.
Module 4: Access Rights, Roles, ProfilesAccess rights (Auto, implicit, Explicit Rights)
Roles and Profiles
Creating Roles and Profiles
DBC.RoleInfo and DBC.ProfileInfo
Module 5: Query analysis and ToolsDatabase Query Log (DBQL)
DBQL Tables and Views
Access Logging
Module 6: System Access Control LevelsTD 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 ManagerTD Manager Apps
TD Dashboard
Priority Scheduler Admin
TD Manager Service
Starting TD Manager
Module 8: Monitoring toolsPerformance Monitor
PMON Main window
PMON sessions Screen
TD Administrator
TD manager Dynamic Utilization Charting
Locking Logger
Module 9: TD Remote Console UtilitiesStarting DB Window
QRYCONFIG
QRYSESSN
RCVMANAGER
SHOWLOCKS
VPROCMANAGER
SHOWSPACE
SHOWBLOCKS
PACKDISK
SCANDISK
Module 10: Archiving DataArchive 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

For more details contact us
Information Helpdesk
918884851579 / +918026542131
www.growmind.co.in / www.facebook.com/growmind
Authorized training and certification center from 'EC-Council', USA
Autorirized training and certification center from 'Peoplecert' USA