Vertica

Training

Get Real-Time Big Data Analytics BDC_sidebanner

Who's Winning With Vertica?

Watch the videos below to hear some of the success stories from the game changing community of Vertica users.





Classes Offered

Vertica Essentials

(previously Vertica Introduction)

Duration: 3 days of live classroom instruction
Cost (U.S.): $2000
Target Audience: System Administrators, Database Analysts, Application Developers

Course Description:

Get started with Vertica by taking our Essentials course. Over three days, you will receive comprehensive training to maximize your understanding and usage of the Vertica Analytics Platform. Vertica has been designed from the ground-up using a columnar orientation, rather than a row-based orientation; you will see the advantages of this integration in every facet of our platform. This class combines lectures with hands-on lab exercises performed in a live Vertica database cluster.

Topics covered include:

  • Overview of the platform architecture
  • Installing the Vertica Analytics Platform
  • Creating and populating a Vertica database containing multiple schemas
  • Using the Database Designer to optimize design
  • Loading data into the Vertica database
  • Permanently removing data from the Vertica database
  • Backing up, restoring and recovery of the Vertica database
  • Optimizing query performance by managing the Vertica resources
  • Monitoring and troubleshooting performance issues

Prerequisite knowledge and experience:

  • Intermediate knowledge of RDBMS concepts
  • Basic understanding of SQL
  • Basic experience with use of the Linux operating system (helpful)

Download the course data sheet (.pdf)

Vertica Advanced Analytics

Duration: 2 days of live classroom instruction
Cost (U.S.): $1500
Target Audience: Data Analysts, Business Analysts, Application Developers

Course Description:

This course provides a comprehensive understanding of general SQL analytics, and the specialized analytics capabilities of the Vertica Analytics Platform. This class combines lectures with hands-on lab exercises performed in a live Vertica database cluster.

Topics covered include:

  • Introduction to the use of SQL Analytics in Vertica
  • Optimizing SQL Analytics in Vertica
  • Using and defining event-based windows
  • Determining gaps in time-based data and interpolating the missing values
  • Finding recurring patterns in your data

Prerequisite knowledge and experience:

  • Attendance at a Vertica Essentials class, or equivalent experience
  • Basic usage of the Vertica Analytics Platform to run queries
  • Basic understanding of analytics concepts (helpful)
  • Intermediate understanding of SQL

Download the course data sheet (.pdf)

Vertica Advanced Performance Tuning

Duration: 2 days of live classroom instruction
Cost (U.S.): $1500
Target Audience: System Administrators, Application Developers

Course Description:

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.

Topics covered include:

  • Pinpointing your longest running queries
  • Analyzing queries using system and data collector tables
  • Manually tuning projections to optimize query performance
  • Modifying settings that control resources dedicated to queries
  • Updating and monitoring statistics
  • Running Workload Analyzer and interpreting output
  • Using the Database Designer (DBD) to tune query performance

Prerequisite knowledge and experience:

  • Attendance at a Vertica¬†Essentials class, or equivalent experience
  • Intermediate experience running queries in Vertica Analytics Platform
  • Intermediate experience with administration of Vertica Analytics Platform

Download the course data sheet (.pdf)

Web-Based Training

Vertica offers free access to web-based training courseware located here. Content is organized into modules that cover architectural concepts, installation, maintenance, management console, and much more.


Additional Training Resources

Private onsite and virtual classroom training sessions can be provided upon request.