Vertica Database Administration 9.0 (VT200)


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.


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

Preise & Trainingsmethoden

Online Training

4 Tage

Preis (exkl. MwSt.)
  • 1.751,– €
Classroom Training

4 Tage

Preis (exkl. MwSt.)
  • Deutschland: 1.751,– €
  • Schweiz: 1.751,– €

Derzeit gibt es keine Trainingstermine für diesen Kurs.