Course Overview
This course provides details regarding typical periodic maintenance and management tasks employed by Vertica Database Administrators, including:
- Monitoring
- Database Design
- Backup and Restore
- Workload Analysis
- Modifying the size of a Vertica cluster
The hands-on labs for this course use version 9.0 of the Vertica software.
Who should attend
This course is intended for:
- Database Administrators
- System Administrators
- Other personnel responsible for the maintenance, monitoring and configuration of the Vertica database.
Prerequisites
To be successful in this course, you should have the following prerequisites or knowledge:
- An understanding of the Vertica database functionality and architecture as typically acquired via three-six months of usage and administration of a Vertica database
- Ideally have attended the Vertica 9.x Essentials (VT120) class to obtain core knowledge
Course Objectives
Upon successful completion of this course, you should be able to:
- Plan for ALM implementation
- Manage a Vertica cluster
- Perform day-to-day Vertica database management tasks
- Create and maintain database users
- Collect and manage database performance metrics
Course Content
- Module 1: The Vertica Training Environment
- Module 2: Managing Vertica Clusters
- Module 3: Loading Data
- Module 4: Monitoring Data
- Module 5: Optimizing the Database Design
- Module 6: Epoch Management
- Module 7: User Management
- Module 8: Table Access Privileges
- Module 9: Resource Management
- Module 10: Database Backup and Recovery
- Module 11: Maintaining a Database and Cluster
- Module 12: The Database Directory
- Module 13: System Maintenance
- Module 14: Next Steps