2-6003 - Vertica Projection Tuning

218786

Intermediate Instructor led (ILT) and Virtual (VILT)

OpenText | OpenText Community

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.

2 views

Details

Related products

Vertica

Description
Suggested courses
Details

Have questions about this course?

Contact us

Description

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

Suggested courses

OpenText COMMUNITY

Universal CMDB 10.3 Interactive Training by ART

OpenText

OpenText COMMUNITY

Securing Workstations Using ZENworks Endpoint Security Management 11.x

OpenText

This course focuses on how Endpoint Security Management can be used to secure your company's workstations and provides an extensive discussion of the product's features. The hands-on exercises teach you how to use the ZENworks Control Center (ZCC) to configure and publish Security Policies that control access to USB ports and removable media devices, provide for data encryption and application control, and demonstrate the location awareness capability of ZENworks 11.x Configuration Management.

OpenText COMMUNITY

FT120 - Fortify SAST and DAST for Developers (ILT/VILT) (Previous)

OpenText

This is a two day training that explores how the Fortify product suite Static Application Security Testing (SAST) and Dynamic Application Security Testing (DAST) scans applications for security vulnerabilities.

OpenText COMMUNITY

Managing Assets with ZENworks Asset Management 11.x

OpenText

This course presents a comprehensive look at how to use Micro Focus ZENworks 11.x Asset Management. The course begins with a review of software asset management techniques applicable to any enterprise using any asset management tool. Then, students are introduced to the ZENworks Control Center and learn how to navigate and configure the application. The course then presents the features of ZENworks Asset Management: usage monitoring, document and contract management, and software license management, in detail.

OpenText COMMUNITY

ACM250 - Access Manager Certified Professional Exam

OpenText

This exam is used for Professional Certification in Access Manager. The exam contains a mixture of multiple-choice and true/false questions.

OpenText COMMUNITY

Service Manager 9.50 Interactive Training Created by ART

OpenText

OpenText COMMUNITY

PLS270-2019.8 – PlateSpin Migrate Administration (Custom)

OpenText

This course teaches you how to use PlateSpin Migrate to perform physical and virtual machine migrations. You will learn how to migrate Windows and Linux workloads on-premise and to the cloud. The course discusses workload relocation solutions and addresses

OpenText COMMUNITY

Network Automation Certified Professional Exam

OpenText

This exam tests your ability to: describe the basic components and functions of NA, add and delete devices, create groups for device Management, run tasks against devices and groups, create and use policies for compliance, and plan for NA installation.

OpenText COMMUNITY

Predictive Analytics Using Machine Learning (Digital Learning)

OpenText

Machine learning is used to discover trends, uncover patterns, peel back layers and detect relationships over large volumes of data. Once put to work, predictive models will identify insights and predict where projects or opportunities will lead. We have incorporated machine learning algorithms into Vertica, enabling in-database prediction-based machine learning over very large data sets and at high speed. During this course, you will learn: How to prepare your data for model development How to create and evaluate regression, classification, and regression algorithms How to manage existing database models

Details

Course

2-6003 -233

More info Less info

Details

Related products

OpenText Analytics Database

23.3

Course outline

DURATION: 3 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

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