Course Overview
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.
Highlights:
- Reading and interpreting a query execution plan
- Automatic projection optimization using the Database Designer
- Manual table and projection design to optimize for specific query execution
- Overriding default configurations to improve query performance
Who should attend
Database administrators, product managers, and quality assurance team members
Prerequisites
To be successful in this course, you should have the following prerequisites or knowledge:
- Completion of Vertica Essentials (OnDemand or Instructor-led) or equivalent experience
- A basic knowledge of SQL
Course Objectives
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
Course Content
- Module 1: The Lab Environment
- Module 2: Introduction to Database Design
- Module 3: Projections in Vertica
- Module 4: Query Execution
- Module 5: Optimizing the Database
- Module 6: Profile Analysis
- Module 7: Query Profiling Parameters
- Module 8: Column Positioning
- Module 9: Manual Projection Design
- Module 10: Flattened Tables
- Module 11: Partitioned Tables
- Module 12: Directed Queries
- Module 13: Next Steps
English