Kód kurzu: VERTICA26003
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.
Odborní
certifikovaní lektoři
Mezinárodně
uznávané certifikace
Široká nabídka technických
a soft skills kurzů
Skvělý zákaznický
servis
Přizpůsobení kurzů
přesně na míru
Počáteční datum: 23.06.2025
Forma: Virtuální
Délka kurzu: 3 dny
Jazyk: en
Cena bez DPH: 57 750 Kč
Počáteční datum: Na vyžádání
Forma: Prezenční/Virtuální
Délka kurzu: 3 dny
Jazyk: en/cz
Cena bez DPH: 57 750 Kč
| Počáteční datum |
Místo konání |
Forma | Délka kurzu |
Jazyk | Cena bez DPH | ||
|---|---|---|---|---|---|---|---|
| 23.06.2025 | Virtuální | 3 dny | en | 57 750 Kč | Registrovat | ||
| Na vyžádání | Prezenční/Virtuální | 3 dny | en/cz | 57 750 Kč | Registrovat | ||
| G | Garantovaný kurz | ||||||
On completion of this course, participants should be able to:
• Interpret a query execution plan
• Optimize your database using the Database Designer
• Optimize database design for specific query execution
• Change table structures to optimize query execution
• Improve query execution by configuring database parameters
Database administrators, product managers, and quality assurance team members
Module 1: The Lab Environment
• Log in to the training environment
• Review the environment configuration
• Using the valab utility
• Using a database in the Management Console
Module 2: Introduction to Database Design
• Identify common query performance issues
• Become familiar with the database environment
Module 3: Projections in Vertica
• Review the definition and structure of a projection
• Explore a sample projection DDL
Module 4: Query Execution
• Time a query
• Generate and evaluate a query plan
• Profile a query and evaluate the output
Module 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
Module 6: Profile Analysis
• Uniquely identify a profiled query
• Identify the events, operators and counters for a profiled query
Module 7: Query Profiling Parameters
• Identify and describe the profiling parameters
• Describe the behavior of each profile parameter
Module 8: Column Positioning
• How projection column positioning affects query performance
• How projection column encoding affects query performance
Module 9: Manual Projection Design
• Optimize projections for groups
• Optimize projections for joins
• Optimize projections for network operations
Module 10: Flattened Tables
• Create a flattened table
• Populate the table with default and derived values
Module 11: Partitioned Tables
• Create a partitioned table
• Load data into partitions
• Move and remove partitioned data
• Review hierarchical partitioning
Module 12: Directed Queries
• Create an Optimizer-generated directed query
• Create a custom directed query
Module 13: Next Steps
• Additional information located in the Vertica portal
produktová podpora
