DBA’s are the crucial part of any successful organization, They play a critical role in providing Organization data security, Integrity and smooth functioning of organization by providing continuous data availability.
To access the complete Teradata DBA training Material : Click here
Teradata DBA Functionalities and Responsibilities
- Important Data Dictionary view’s and Table’s
- Important DBA querie’s handbook
- Advanced Concept for Workload Analyzer (TWA) – Workload Drill-Down
- Teradata Performance Optimiation & SQL Tuning
Teradata Architecture
- Architecture Overview
- Exploring AMP’s
- Exploring PE’s
- Exploring BY-NET
- Exploring Disk Array’s
Teradata Tools and Utilities
- Teradata Viewpoint explained
- Teradata Index Wizard
- Teradata Statistics Wizard
- Teradata Visual Explain
- Teradata System Emulation Tool
Operation DBA Activities
- Query Tuning
- Space Issues
- Performance Monitoring
- Work Load Management
- Troubleshooting
- Backup and Recovery
Application DBA Activities
- Database Object Design
- Index selection & creation
- Database Modelling
Security DBA Activities
- Creating User’s
- Granting and Revoking Access
- User Access Logging
- Tracking Log on/off