Vertica Instructor-Led Courses
Write your awesome label here.

PUBLIC INSTRUCTOR-LED

ONSITE INSTRUCTOR-LED

REMOTE INSTRUCTOR-LED

ACCREDITATIONS AND CERTIFICATIONS
Instructor Led Training
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
10
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
10