Kód kurzu: VERTICA26004
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.
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: Na vyžiadanie
Forma: Prezenčná/Virtuálna
Dĺžka kurzu: 2 dni
Jazyk: en/cz
Cena bez DPH: 1 448 EUR
| Počiatočný dátum |
Miesto konania |
Forma | Dĺžka kurzu |
Jazyk | Cena bez DPH | ||
|---|---|---|---|---|---|---|---|
| Na vyžiadanie | Prezenčná/Virtuálna | 2 dni | en/cz | 1 448 EUR | Registrovať | ||
| G | Garantovaný kurz | ||||||
On completion of this course, participants should be able to:
• Manually build and test the following projection types:
o Projections with expressions
o Live aggregate projections
o TopK projections
o Partition range projections
• Describe the advantages and limitations of
each of these projection types
Database administrators, product managers, and quality assurance team members
Module 1: Course Overview
• Introduction to the course
• How to request a lab environment
Module 2: The Lab Environment
• Access the training environment
• Review the environment configuration
• Using the valab utility
• Using the Management Console
Module 3: Overview: Aggregate Projection Types
• Describe the manual projection types, and the scenarios they address
Module 4: Projections With Expressions
• Build and test a projection that includes mathematical expressions
• Identify system table structures for projections with expressions
Module 5: Live Aggregate Projections
• Build and test a projection that uses aggregate functions
• Identify system table structures for live aggregate projections
Module 6: TopK Projections
• Build and test a projection that returns a data subset per analytic function
• Identify system table structures for TopK projections
Module 7: Choosing the Right Projection Type
• Find the most performant projection type for a query
Module 8: Partition Range Projections
• Build and test projections containing a subset of partitioned data
• Identify system table structures for partition range projections
To be successful in this course, you should have the following prerequisites or knowledge:
• Completion of Vertica Essentials (OnDemand or Instructor-led) or equivalent experience
• Completion of Projection Tuning (OnDemand or Instructor-led) would be helpful, but not required
• A basic knowledge of SQL
pruduktová podpora
