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í lektori
Mezinárodne
uznávané certifikácie
Široká ponuka technických
a soft skills kurzov
Skvelý zákaznicky
servis
Prispôsobenie kurzov
presne na mieru
Počiatočný dátum: 23.06.2025
Forma: Virtuálna
Dĺžka kurzu: 3 dni
Jazyk: en
Cena bez DPH: 2 412 EUR
Počiatočný dátum: Na vyžiadanie
Forma: Prezenčná/Virtuálna
Dĺžka kurzu: 3 dni
Jazyk: en/cz
Cena bez DPH: 2 412 EUR
| Počiatočný dátum |
Miesto konania |
Forma | Dĺžka kurzu |
Jazyk | Cena bez DPH | ||
|---|---|---|---|---|---|---|---|
| 23.06.2025 | Virtuálna | 3 dni | en | 2 412 EUR | Registrovať | ||
| Na vyžiadanie | Prezenčná/Virtuálna | 3 dni | en/cz | 2 412 EUR | Registrovať | ||
| 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
pruduktová podpora
