{"course":{"productid":34939,"modality":6,"active":true,"language":"en","title":"Vertica Aggregate Projection Design","productcode":"VERTAPD","vendorcode":"MF","vendorname":"OpenText","fullproductcode":"MF-VERTAPD","courseware":{"has_ekit":false,"has_printkit":true,"language":""},"url":"https:\/\/portal.flane.ch\/course\/opentext-vertapd","objective":"<p>&lt;p&gt;On completion of this course, participants should be able to:<\/p>\n<ul>\n<li>Manually build and test the following projection types:\n<ul>\n<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>","essentials":"<p>To be successful in this course, you should have the following prerequisites or knowledge:<\/p>\n<ul>\n<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>","audience":"<p>Database administrators, product managers, and quality assurance team members<\/p>","contents":"<h5>Module 1: Course Overview<\/h5><ul>\n<li>Introduction to the course<\/li><li>How to request a lab environment<\/li><\/ul><h5>Module 2: The Lab Environment<\/h5><ul>\n<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>\n<li>Describe the manual projection types, and the scenarios they address<\/li><\/ul><h5>Module 4: Projections With Expressions<\/h5><ul>\n<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>\n<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>\n<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>\n<li>Find the most performant projection type for a query<\/li><\/ul><h5>Module 8: Partition Range Projections<\/h5><ul>\n<li>Build and test projections containing a subset of partitioned data<\/li><li>Identify system table structures for partition range projections<\/li><\/ul>","summary":"<p>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.<\/p>\n<ul>\n<li>The course uses videos and a series of hands-on labs to teach the course material.<\/li><li>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.<\/li><li>The content in this course is covered in the Vertica Analyst certification exam.<\/li><\/ul><p>Highlights<\/p>\n<ul>\n<li>How to build and test the following projection types:\n<ul>\n<li>Projections with expressions<\/li><li>Live aggregate projections<\/li><li>TopK projections<\/li><li>Partition range projections<\/li><\/ul><\/li><li>The advantages and disadvantages of each of these projection types<\/li><\/ul>","objective_plain":"On completion of this course, participants should be able to:\n\n\n- Manually build and test the following projection types:\n\n- Projections with expressions\n- Live aggregate projections\n- TopK projections\n- Partition range projections\n- Describe the advantages and limitations of each of these projection types","essentials_plain":"To be successful in this course, you should have the following prerequisites or knowledge:\n\n\n- Completion of Vertica Essentials (OnDemand or Instructor-led) or equivalent experience\n- Completion of Projection Tuning (OnDemand or Instructor-led) would be helpful, but not required\n- A basic knowledge of SQL","audience_plain":"Database administrators, product managers, and quality assurance team members","contents_plain":"Module 1: Course Overview\n\n\n- Introduction to the course\n- How to request a lab environment\nModule 2: The Lab Environment\n\n\n- Access the training environment\n- Review the environment configuration\n- Using the valab utility\n- Using the Management Console\nModule 3: Overview: Aggregate Projection Types\n\n\n- Describe the manual projection types, and the scenarios they address\nModule 4: Projections With Expressions\n\n\n- Build and test a projection that includes mathematical expressions\n- Identify system table structures for projections with expressions\nModule 5: Live Aggregate Projections\n\n\n- Build and test a projection that uses aggregate functions\n- Identify system table structures for live aggregate projections\nModule 6: TopK Projections\n\n\n- Build and test a projection that returns a data subset per analytic function\n- Identify system table structures for TopK projections\nModule 7: Choosing the Right Projection Type\n\n\n- Find the most performant projection type for a query\nModule 8: Partition Range Projections\n\n\n- Build and test projections containing a subset of partitioned data\n- Identify system table structures for partition range projections","summary_plain":"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.\n\n\n- The course uses videos and a series of hands-on labs to teach the course material.\n- 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.\n- The content in this course is covered in the Vertica Analyst certification exam.\nHighlights\n\n\n- How to build and test the following projection types:\n\n- Projections with expressions\n- Live aggregate projections\n- TopK projections\n- Partition range projections\n- The advantages and disadvantages of each of these projection types","skill_level":"Intermediate","version":"23.3","duration":{"unit":"d","value":2,"formatted":"2 days"},"pricelist":{"List Price":{"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":1600}}},"lastchanged":"2025-07-29T12:18:36+02:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/en\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course-schedule\/34939","source_lang":"en","source":"https:\/\/portal.flane.ch\/swisscom\/en\/json-course\/opentext-vertapd"}}