Vertica Advanced Performance Tuning

Popis kurzu

Over 2 days this intensive course is designed for experienced Vertica administrators who want 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. Some topics include: pinpointing and analyzing queries using system and data collector tables, running Workload Analyzer and using the Database Designer (DBD) to tune query performance.

Over 2 days this intensive course is designed for experienced Vertica administrators who want 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. Some topics include: pinpointing and analyzing queries using system and data collector tables, running Workload Analyzer and using the Database Designer (DBD) to tune query performance.

Určeno pro

System Administrators, Database Administrators, and Application Developers

Obsah kurzu

The Vertica Advanced Performance Tuning course provides an intensive deep-dive into the process of diagnosing and optimizing query performance within an Vertica deployment. You will learn how to tune and simplify database queries, modify resource settings, monitor and update statistics, and interpret the output of the Workload Analyzer. This class combines lectures with hands-on laboratory exercises performed in a live Vertica database cluster.

Předpoklady

To be successful in this course, you should have the following prerequisites or knowledge.

• Vertica Essentials, or equivalent experience with the Vertica Analytics platform


• Intermediate experience running queries in Vertica Analytics


• Intermediate experience administrating Vertica Analytics


• Intermediate knowledge of SQL

Studijní materiály