Course code: VERTICA26004
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.
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: Upon request
Type: In-person/Virtual
Course duration: 2 days
Language: en/cz
Price without VAT: 1 448 EUR
| Starting date |
Place |
Type | Course duration |
Language | Price without VAT | ||
|---|---|---|---|---|---|---|---|
| Upon request | In-person/Virtual | 2 days | en/cz | 1 448 EUR | Register | ||
| G | Guaranteed course | ||||||
On completion of this course, participants should be able to:
• Manually build and test the following projection types:
o Projections with expressions
o Live aggregate projections
o TopK projections
o Partition range projections
• Describe the advantages and limitations of
each of these projection types
Database administrators, product managers, and quality assurance team members
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
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
