Description

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

Suggested courses

Suggested courses are based on product compatibility, popularity, and newness.

Details

Course
2-6004 -233
More info Less info
Related products
Course outline

DURATION: 2 Days

DELIVERY TYPE: Instructor Led (ILT) and Virtual Instructor Led (VILT)

ROLE/LEVEL: Analyst

AUDIENCE: Database administrators, product managers, and quality assurance team members

Languages
English

Unsubscribe from notifications

You are receiving release updates for this course because you have subscribed to the following products:
If you unsubscribe, you will no longer receive any notifications for these products.
Tip: to update your subscription preferences, go to Manage Subscriptions from your Dashboard, uncheck the products you no longer want to receive notifications for, and click 'Save'.

Marketplace Terms of Service

In order to continue, you must accept the updated Marketplace Terms of Service
Since you are downloading an app from the OpenText Marketplace, you need to accept the updated Marketplace Terms of Service before you can continue. Use the link to review the Marketplace Terms of Service. Once complete check the, "I accept the Marketplace Terms of Service" box below and click accept to continue your download.


Your download has begun...

Your download has begun

Related content and resources

Your browser is not supported!

Please upgrade to one of the following broswers: Internet Explorer 11 (or greater) or the latest version of Chrome or Firefox

release-rel-2025-2-1-6322 | Wed Feb 5 16:30:41 PST 2025