Teradata DBA Training

Velgro Academy offers best Teradata DBA Training in Chennai with most experienced professionals. Our Instructors are working in Teradata DBA and related technologies for more years in MNC’s.

We aware of industry needs and we are offering Teradata DBA Training in Chennai in more practical way. Our team of Teradata DBA trainers offers Teradata DBA in Classroom training, Teradata DBA Online Training and Teradata DBA Corporate Training services.

We framed our syllabus to match with the real world requirements for both beginner level to advanced level. Our training will be handled in either weekday or weekend’s program depends on participant’s requirement. We do offer Fast-Track Teradata DBA Training in Chennai and One-to-One Teradata DBA Training in Chennai.

Here are the major topics we cover under this Teradata DBA course Syllabus TERADATA Architecture, TERADATA Database Space, DBC Dictionary Tables, Access Rights, Roles, Profiles, Query analysis and Tools, System Access Control Level, TD Manager, Monitoring tools, TD Remote Console Utilities, Archiving Data, Restoring data.

Teradata DBA Training Syllabus:

• TERADATA Architecture
• Parsing Engine(PE)
• Request and Response Parcel
• Access Module Processors (AMPs)
• Bynet
• Data access Handling
• TD Config Utilities
• Config and Reconfig
• TERADATA Database Space
• Permanent Space
• Spool Space
• Temp Space
• Indexes
• 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.
• Access Rights, Roles, Profilest
• Access rights (Auto, implicit, Explicit Rights)
• Roles and Profiles
• Creating Roles and Profiles
• DBC.RoleInfo and DBC.ProfileInfo
• Query analysis and Tools
• Database Query Log (DBQL)
• DBQL Tables and Views
• Access Logging
• System Access Control Level
• 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
• TD Manager
• TD Manager Apps
• TD Dashboard
• Priority Scheduler Admin
• TD Manager Service
• Starting TD Manager
• Monitoring tools
• Performance Monitor
• PMON Main window
• PMON sessions Screen
• TD Administrator
• TD manager Dynamic Utilization Charting
• Locking Logger
• TD Remote Console Utilities
• Starting DB Window
• QRYCONFIG
• QRYSESSN
• RCVMANAGER
• SHOWLOCKS
• VPROCMANAGER
• SHOWSPACE
• SHOWBLOCKS
• PACKDISK
• SCANDISK
• 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
• Restoring data
• Restore
• COPY
• Copying Tables
• BUILD