Course Overview
This two-day course teaches students how to manually build projections that aggregate or rearrange data on disk, thereby improving performance of queries that reference aggregated data. These projection types are not created by the Database Designer.
- The course uses videos and a series of hands-on labs to teach the course material.
- The intended audience for this course includes database administrators, product managers, and quality assurance team members. The course assumes students have the attained, at a minimum, the knowledge contained in the Vertica Essentials course; information contained in the Projection Tuning course would also be helpful.
- The content in this course is covered in the Vertica Analyst certification exam.
Highlights
- How to build and test the following projection types:
- Projections with expressions
- Live aggregate projections
- TopK projections
- Partition range projections
- The advantages and disadvantages of each of these projection types
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
- Completion of Projection Tuning (OnDemand or Instructor-led) would be helpful, but not required
- A basic knowledge of SQL
Course Objectives
<p>On completion of this course, participants should be able to:
- Manually build and test the following projection types:
- Projections with expressions
- Live aggregate projections
- TopK projections
- Partition range projections
- Describe the advantages and limitations of each of these projection types
Course Content
Module 1: Course Overview
- Introduction to the course
- How to request a lab environment
Module 2: The Lab Environment
- Access the training environment
- Review the environment configuration
- Using the valab utility
- Using the Management Console
Module 3: Overview: Aggregate Projection Types
- Describe the manual projection types, and the scenarios they address
Module 4: Projections With Expressions
- Build and test a projection that includes mathematical expressions
- Identify system table structures for projections with expressions
Module 5: Live Aggregate Projections
- Build and test a projection that uses aggregate functions
- Identify system table structures for live aggregate projections
Module 6: TopK Projections
- Build and test a projection that returns a data subset per analytic function
- Identify system table structures for TopK projections
Module 7: Choosing the Right Projection Type
- Find the most performant projection type for a query
Module 8: Partition Range Projections
- Build and test projections containing a subset of partitioned data
- Identify system table structures for partition range projections
English