VERTAPDMFOpenTextMF-VERTAPD23.3<p>&lt;p&gt;On completion of this course, participants should be able to:</p> <ul> <li>Manually build and test the following projection types: <ul> <li>Projections with expressions</li><li>Live aggregate projections</li><li>TopK projections</li><li>Partition range projections</li></ul></li><li>Describe the advantages and limitations of each of these projection types</li></ul><p>To be successful in this course, you should have the following prerequisites or knowledge:</p> <ul> <li>Completion of Vertica Essentials (OnDemand or Instructor-led) or equivalent experience</li><li>Completion of Projection Tuning (OnDemand or Instructor-led) would be helpful, but not required</li><li>A basic knowledge of SQL</li></ul><p>Database administrators, product managers, and quality assurance team members</p><h5>Module 1: Course Overview</h5><ul> <li>Introduction to the course</li><li>How to request a lab environment</li></ul><h5>Module 2: The Lab Environment</h5><ul> <li>Access the training environment</li><li>Review the environment configuration</li><li>Using the valab utility</li><li>Using the Management Console</li></ul><h5>Module 3: Overview: Aggregate Projection Types</h5><ul> <li>Describe the manual projection types, and the scenarios they address</li></ul><h5>Module 4: Projections With Expressions</h5><ul> <li>Build and test a projection that includes mathematical expressions</li><li>Identify system table structures for projections with expressions</li></ul><h5>Module 5: Live Aggregate Projections</h5><ul> <li>Build and test a projection that uses aggregate functions</li><li>Identify system table structures for live aggregate projections</li></ul><h5>Module 6: TopK Projections</h5><ul> <li>Build and test a projection that returns a data subset per analytic function</li><li>Identify system table structures for TopK projections</li></ul><h5>Module 7: Choosing the Right Projection Type</h5><ul> <li>Find the most performant projection type for a query</li></ul><h5>Module 8: Partition Range Projections</h5><ul> <li>Build and test projections containing a subset of partitioned data</li><li>Identify system table structures for partition range projections</li></ul>On completion of this course, participants should be able to: - Manually build and test the following projection types: - Projections with expressions - Live aggregate projections - TopK projections - Partition range projections - Describe the advantages and limitations of each of these projection typesTo 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 SQLDatabase administrators, product managers, and quality assurance team membersModule 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 projections2 jours1600.00