Course ID 00787054
Course format ILT,SCA
Typical Course length 2 days
Delivery languages English
Related certifications
In preparation for these exams
Selected items from this course are included in these exams:
Register for this course.
Register with Vertica, an HPE Company.

Course description

This intensive course provides a deep dive into Vertica to learn how to diagnose and optimize query performance. This class combines lectures with hands on lab exercises performed in a live Vertica database cluster.

Ideal candidate for this course

The course is designed for experienced Vertica administrators who want a deep dive into Vertica to learn how to diagnose and optimize query performance and improve their analyzing, diagnosing, troubleshooting, tuning and optimizing skills.
This course is targeted at Vertica DBAs, who are familiar with basic operational tasks like running queries,
monitoring usage, and loading data, who want to take a further step in their career by improving their skills in
analyzing, diagnosing, troubleshooting, tuning and optimizing Vertica performance.


• Attendance at a Vertica Introduction class, or equivalent experience
• Intermediate experience running queries in Vertica Analytics Platform
• Intermediate experience with administration of Vertica Analytics Platform
For complete prerequisites and requirements to achieve any of the related certifications or upgrade paths, see the certification description on the Certification and Learning website.


After completing this course, you should be able to do the following:
  • Pinpoint longest running queries.
  • Analyze queries using system and data collector tables.
  • Manually tune projections to optimize query performance.
  • Modify settings that control resources dedicated to queries.
  • Update and monitor statistics.
  • Run Workload Analyzer and interpret output
  • Use the Database Designer (DBD) to tune query performance.

How to register

Click on this link to register for this course:

Policies, fees and cancellations

Course fees may vary and are established and collected by the training center delivering the course. Cancellation fees may apply. Contact your HPE Authorized Training Partner for their respective policies.

Learning resources that were developed before the Hewlett-Packard Company separation might contain some content and brand elements that have not been updated for Hewlett Packard Enterprise. Learning resources with the highest usage are updated.