myVertica  

Web Based Training

Welcome to Vertica’s online training site. Members of the Vertica Community have free access to our growing collection of web-based training content. Content is organized into multiple modules that enable you to access and view the content of interest to you.


Overview

Vertica Advantages

YouTube icon Learn about the physical architecure of a Vertica cluster and the foundational elements of Vertica that make it a unique and powerful platform.

Data Management

Introduction to Projections

YouTube icon This overview describes the Vertica projections, which define how data will be stored and optimized for performance.

Data Loading

YouTube icon Learn how Vertica’s Hybrid Storage Model is used to speed the loading of data; how to monitor a data load in progress; and how to troubleshoot data loading issues.

Query Planning and Execution

YouTube icon Learn how queries are managed by Vertica’s distributed database, using the least resource-intensive method to execute them quickly and efficiently.

The Database Designer

YouTube icon Vertica’s Database Designer (DBD) simplifies the creation of an optimized database design based on your most commonly executed queries, thereby increasing the performance of those queries.

Vertica Analytics Functions

Introduction to Analytics

Learn how to structure an analytic query, and become acquainted with the advantages of analytic queries; understand the order in which analytic functions process database information.

Event-Based Analytics

Event-based analytics functions are Vertica-proprietary extensions beyond the ANSI-99 supported analytics tools. Learn about the features, benefits, and usage of Vertica’s event-based analytics functions to evaluate data.

Timeseries Analytics

When data with a timestamp is gathered, it often has gaps between events. Vertica provides analytic tools that allow you to interpolate values of missing data. Learn how Vertica interpolates the intervals and values for missing time series data.

Vertica Workload Management

The Vertica Resource Manager

In order to most efficient process queries, Vertica assigns each query to a built-in resource pool. Learn about how query workloads are managed used the built-in pools, and the configuration parameters for each of these pools.

User-Defined Resource Pools

Learn how to create a new resource pool, and how to assign the queries from specific users to a particular pool. We recommend you first take the Vertica Resource Manager web-based module.


Looking for more? Attend a Live Training course.