Course code: VERTICA26003
This three-day course teaches students how Vertica executes queries, and how they can improve the performance of query execution by identifying execution issues in execution plans, and creating projection designs that address those issues.
The course includes a series of hands-on labs to teach the course material.
The content in this course is covered in the Vertica Analyst certification exam.
Professional
and certified lecturers
Internationally
recognized certifications
Wide range of technical
and soft skills courses
Great customer
service
Making courses
exactly to measure your needs
Starting date: 23.06.2025
Type: Virtual
Course duration: 3 days
Language: en
Price without VAT: 2 412 EUR
Starting date: Upon request
Type: In-person/Virtual
Course duration: 3 days
Language: en/cz
Price without VAT: 2 412 EUR
| Starting date |
Place |
Type | Course duration |
Language | Price without VAT | ||
|---|---|---|---|---|---|---|---|
| 23.06.2025 | Virtual | 3 days | en | 2 412 EUR | Register | ||
| Upon request | In-person/Virtual | 3 days | en/cz | 2 412 EUR | Register | ||
| G | Guaranteed course | ||||||
On completion of this course, participants should be able to:
• Interpret a query execution plan
• Optimize your database using the Database Designer
• Optimize database design for specific query execution
• Change table structures to optimize query execution
• Improve query execution by configuring database parameters
Database administrators, product managers, and quality assurance team members
Module 1: The Lab Environment
• Log in to the training environment
• Review the environment configuration
• Using the valab utility
• Using a database in the Management Console
Module 2: Introduction to Database Design
• Identify common query performance issues
• Become familiar with the database environment
Module 3: Projections in Vertica
• Review the definition and structure of a projection
• Explore a sample projection DDL
Module 4: Query Execution
• Time a query
• Generate and evaluate a query plan
• Profile a query and evaluate the output
Module 5: Optimizing the Database
• Describe the function of the Database Designer
• Create and deploy a comprehensive projection design
• Create and deploy an incremental projection design
Module 6: Profile Analysis
• Uniquely identify a profiled query
• Identify the events, operators and counters for a profiled query
Module 7: Query Profiling Parameters
• Identify and describe the profiling parameters
• Describe the behavior of each profile parameter
Module 8: Column Positioning
• How projection column positioning affects query performance
• How projection column encoding affects query performance
Module 9: Manual Projection Design
• Optimize projections for groups
• Optimize projections for joins
• Optimize projections for network operations
Module 10: Flattened Tables
• Create a flattened table
• Populate the table with default and derived values
Module 11: Partitioned Tables
• Create a partitioned table
• Load data into partitions
• Move and remove partitioned data
• Review hierarchical partitioning
Module 12: Directed Queries
• Create an Optimizer-generated directed query
• Create a custom directed query
Module 13: Next Steps
• Additional information located in the Vertica portal
