Szkolenia Micro Focus

Cel szkolenia szkolenie zdalne - dlearning

kod: VT320-90 | wersja: 9.0

The Query Performance Tuning course provides an in-depth architectural review of the architecture of Vertica projections, and how they can be configured to provide optimal query performance

Upon successful completion of this course, you should be able to:

  • Optimize your database for your most commonly-run queries
  • Analyze your queries and your environment for potential performance bottlenecks
  • Tune your environment for query execution
  • Manually build and test advanced projection types

Audience/Job Roles

This course is intended for database administrators and software integrators.

Plan szkolenia Rozwiń listę

  1. The Vertica Training Environment
    • Log in to the training environment
    • Review the training environment configuration
    • Start and stop a database
  2. Introduction to Database Design
    • Identify common query performance issues
    • Become familiar with the database environment
  3. Projection Design
    • Review the definition of a projection
    • Describe the configuration of a projection DDL
    • Explain how DDL configuration impacts performance
  4. Query Execution
    • Time a query
    • Generate and evaluate a query plan
    • Profile a query and evaluate the output
  5. Optimizing the Database
    • Describe the function of the Database Designer
    • Create and deploy a comprehensive projection design
    • Create and deploy an incremental projection design
  6. Profile Analysis
    • Uniquely identify a profiled query
    • Identify the events, operators, and counters for a profiled query
  7. Denormalizing Using Flattened Tables
    • Create a flattened table
    • Populate the table with default and derived values
  8. Directed Queries
    • Create an Optimizer-generated directed query
    • Create a custom directed query
  9. Projections with Expressions
    • Define a projection containing an expression
  10. Aggregate Projection Types
    • Describe the functionality and limitations of live aggregate projections
    • Build and test a live aggregate projection
    • Describe the functionality and limitations of TopK projections
    • Build and test a TopK projection
  11. Resource Management
    • Review the resource pool parameters
    • Create and troubleshoot a resource pool
    • Monitor resource pool activity
  12. Next Steps
    • Accessing Micro Focus Software's additional training offerings
    • Additional information located in the MyVertica portal
Pobierz konspekt szkolenia w formacie PDF

Dodatkowe informacje

Wymagania wstępne

To be successful in this course, you should have the following prerequisites or knowledge:

  • A basic understanding of UNIX (finding and changing directories, listing directory contents, editing files, etc.)
  • Intermediate understanding of SQL (creating tables, loading data, selecting specific data from a table, common column data types, SQL join functionality, etc.)
  • Familiarity with Vertica's projection definitions (segmentation, encoding, K-safety, etc.)
Poziom trudności
Czas trwania 3 dni

The participants will obtain certificates signed by Micro Focus (course completion).


Authorized Micro Focus Trainer.

Pozostałe szkolenia Micro Focus | Vertica & IDOL

Szkolenia powiązane tematycznie

Cloud Computing

Analiza danych

Big Data

Analiza Big Data

Formularz kontaktowy

Prosimy o wypełnienie poniższego formularza, jeśli chcą Państwo uzyskać więcej informacji o powyższym szkoleniu.

* pola oznaczone (*) są wymagane

Informacje o przetwarzaniu danych przez Compendium – Centrum Edukacyjne Spółka z o.o.


Najbliższe szkolenia Micro Focus

Harmonogram szkoleń Micro Focus