Vertica Instructor-Led Courses

Write your awesome label here.
PUBLIC INSTRUCTOR-LED
ONSITE INSTRUCTOR-LED
REMOTE INSTRUCTOR-LED
ACCREDITATIONS AND CERTIFICATIONS

Instructor Led Training 

Each course provides students with hands-on experience and is lab-based to keep learning practical. The class experience offers students the opportunity to personally interact with one of our certified instructors who has extensive experience and industry knowledge. We have a range of courses designed to accommodate both beginner and advanced students. To ensure that adequate attention is provided to each student attending an instructor-led class, Vertica Education maintains class sizes up to twelve participants. 

Vertica Essentials

OVERVIEW
The Vertica Essentials course offers a high-level introduction to the architecture and capabilities of the Vertica Analytics Platform. This course is a prerequisite to all advanced courses and will prepare you for the operational success of your deployment.
Write your awesome label here.

Course Topics

  • Vertica Overview
  • Introduction to Projections
  • Loading Data
  • Query Execution
  • Optimizing the Database
  • Partitioning Data
  • Remove Data
  • Database User Management
  • Table Access Privileges
  • Resource Management
  • Database Backup and Restore

Course Objectives

Upon successful completion of this course, you should be able to: 
  • Describe Vertica’s database and data storage structures
  • Load and remove data from a Vertica database
  • Optimize the database to improve query performance
  • Create and manage database users and resources
  • Backup and restore a Vertica database

Pre-requisites

To be successful in this course, you should have the following prerequisites or knowledge:
  • Knowledge of RDBMS concepts (understanding databases and schemas, database normalization, etc.)
  • Familiarity with basic SQL syntax, ability to troubleshoot syntax errors, etc.
  • Experience with the Linux operating system (how to change directories and list the contents, how to view and edit files, etc.)

Usual Audience

This course is intended for database administrators, database architects, data analysts, and application developers.

Duration

4 Days

Cost

To request a personalized quote, please contact vertica.academy@microfocus.com 

Max Number of Attendees per Class

12

Vertica Query Performance Tuning

OVERVIEW
The Vertica Academy Query Performance Tuning ILT course provides an in-depth review of the architecture of Vertica projections, and how they can be configured to provide optimal query performance.
Write your awesome label here.

Course Topics

  • Introduction to Database Design
  • Projection Design
  • Query Execution
  • Optimizing the Database
  • Profile Analysis
  • Denormalizing Using Flattened Tables
  • Directed Queries
  • Projections with Expressions
  • Aggregate Projection Types

Course Objectives

Upon successful completion of this course, you should be able to: 
  • Optimize your database for your most commonly run queries
  • Analyze your queries and your environment for potential performance bottlenecks
  • Manually build and test advanced projections

Pre-requisites

To be successful in this course, you should have the following prerequisites or knowledge:
  • Successful completion of the Vertica Essentials Certification course (mandatory), which equips you with a basic understanding of UNIX
  • Intermediate understanding of SQL (creating tables, loading data, selecting specific data from a table, common column data types, SQL join functionality, etc.)

Usual Audience

This course is intended for database administrators and software integrators.

Duration

4 Days

Cost

To request a personalized quote, please contact vertica.academy@microfocus.com 

Max Number of Attendees per Class

12