{"course":{"productid":34938,"modality":6,"active":true,"language":"fr","title":"Vertica Projection Tuning","productcode":"VERTPT","vendorcode":"MF","vendorname":"OpenText","fullproductcode":"MF-VERTPT","courseware":{"has_ekit":false,"has_printkit":true,"language":""},"url":"https:\/\/portal.flane.ch\/course\/opentext-vertpt","objective":"<p>On completion of this course, participants should be able to:<\/p>\n<ul>\n<li>Interpret a query execution plan<\/li><li>Optimize your database using the Database Designer<\/li><li>Optimize database design for specific query execution<\/li><li>Change table structures to optimize query execution<\/li><li>Improve query execution by configuring database parameters<\/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>A basic knowledge of SQL<\/li><\/ul>","audience":"<p>Database administrators, product managers, and quality assurance team members<\/p>","contents":"<ul>\n<li>Module 1: The Lab Environment<\/li><li>Module 2: Introduction to Database Design<\/li><li>Module 3: Projections in Vertica<\/li><li>Module 4: Query Execution<\/li><li>Module 5: Optimizing the Database<\/li><li>Module 6: Profile Analysis<\/li><li>Module 7: Query Profiling Parameters<\/li><li>Module 8: Column Positioning<\/li><li>Module 9: Manual Projection Design<\/li><li>Module 10: Flattened Tables<\/li><li>Module 11: Partitioned Tables<\/li><li>Module 12: Directed Queries<\/li><li>Module 13: Next Steps<\/li><\/ul>","outline":"<h5>Module 1: The Lab Environment<\/h5><ul>\n<li>Log in to the training environment<\/li><li>Review the environment configuration<\/li><li>Using the valab utility<\/li><li>Using a database in the Management Console<\/li><\/ul><h5>Module 2: Introduction to Database Design<\/h5><ul>\n<li>Identify common query performance issues<\/li><li>Become familiar with the database environment<\/li><\/ul><h5>Module 3: Projections in Vertica<\/h5><ul>\n<li>Review the definition and structure of a projection<\/li><li>Explore a sample projection DDL<\/li><\/ul><h5>Module 4: Query Execution<\/h5><ul>\n<li>Time a query<\/li><li>Generate and evaluate a query plan<\/li><li>Profile a query and evaluate the output<\/li><\/ul><h5>Module 5: Optimizing the Database<\/h5><ul>\n<li>Describe the function of the Database Designer<\/li><li>Create and deploy a comprehensive projection design<\/li><li>Create and deploy an incremental projection design<\/li><\/ul><h5>Module 6: Profile Analysis<\/h5><ul>\n<li>Uniquely identify a profiled query<\/li><li>Identify the events, operators and counters for a profiled query<\/li><\/ul><h5>Module 7: Query Profiling Parameters<\/h5><ul>\n<li>Identify and describe the profiling parameters<\/li><li>Describe the behavior of each profile parameter<\/li><\/ul><h5>Module 8: Column Positioning<\/h5><ul>\n<li>How projection column positioning affects query performance<\/li><li>How projection column encoding affects query performance<\/li><\/ul><h5>Module 9: Manual Projection Design<\/h5><ul>\n<li>Optimize projections for groups<\/li><li>Optimize projections for joins<\/li><li>Optimize projections for network operations<\/li><\/ul><h5>Module 10: Flattened Tables<\/h5><ul>\n<li>Create a flattened table<\/li><li>Populate the table with default and derived values<\/li><\/ul><h5>Module 11: Partitioned Tables<\/h5><ul>\n<li>Create a partitioned table<\/li><li>Load data into partitions<\/li><li>Move and remove partitioned data<\/li><li>Review hierarchical partitioning<\/li><\/ul><h5>Module 12: Directed Queries<\/h5><ul>\n<li>Create an Optimizer-generated directed query<\/li><li>Create a custom directed query<\/li><\/ul><h5>Module 13: Next Steps<\/h5><ul>\n<li>Additional information located in the Vertica portal<\/li><\/ul>","summary":"<p>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.<\/p>\n<ul>\n<li>The course includes a series of hands-on labs to teach the course material.<\/li><li>The content in this course is covered in the Vertica Analyst certification exam.<\/li><\/ul><p>Highlights:<\/p>\n<ul>\n<li>Reading and interpreting a query execution plan<\/li><li>Automatic projection optimization using the Database Designer<\/li><li>Manual table and projection design to optimize for specific query execution<\/li><li>Overriding default configurations to improve query performance<\/li><\/ul>","objective_plain":"On completion of this course, participants should be able to:\n\n\n- Interpret a query execution plan\n- Optimize your database using the Database Designer\n- Optimize database design for specific query execution\n- Change table structures to optimize query execution\n- Improve query execution by configuring database parameters","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- A basic knowledge of SQL","audience_plain":"Database administrators, product managers, and quality assurance team members","contents_plain":"- Module 1: The Lab Environment\n- Module 2: Introduction to Database Design\n- Module 3: Projections in Vertica\n- Module 4: Query Execution\n- Module 5: Optimizing the Database\n- Module 6: Profile Analysis\n- Module 7: Query Profiling Parameters\n- Module 8: Column Positioning\n- Module 9: Manual Projection Design\n- Module 10: Flattened Tables\n- Module 11: Partitioned Tables\n- Module 12: Directed Queries\n- Module 13: Next Steps","outline_plain":"Module 1: The Lab Environment\n\n\n- Log in to the training environment\n- Review the environment configuration\n- Using the valab utility\n- Using a database in the Management Console\nModule 2: Introduction to Database Design\n\n\n- Identify common query performance issues\n- Become familiar with the database environment\nModule 3: Projections in Vertica\n\n\n- Review the definition and structure of a projection\n- Explore a sample projection DDL\nModule 4: Query Execution\n\n\n- Time a query\n- Generate and evaluate a query plan\n- Profile a query and evaluate the output\nModule 5: Optimizing the Database\n\n\n- Describe the function of the Database Designer\n- Create and deploy a comprehensive projection design\n- Create and deploy an incremental projection design\nModule 6: Profile Analysis\n\n\n- Uniquely identify a profiled query\n- Identify the events, operators and counters for a profiled query\nModule 7: Query Profiling Parameters\n\n\n- Identify and describe the profiling parameters\n- Describe the behavior of each profile parameter\nModule 8: Column Positioning\n\n\n- How projection column positioning affects query performance\n- How projection column encoding affects query performance\nModule 9: Manual Projection Design\n\n\n- Optimize projections for groups\n- Optimize projections for joins\n- Optimize projections for network operations\nModule 10: Flattened Tables\n\n\n- Create a flattened table\n- Populate the table with default and derived values\nModule 11: Partitioned Tables\n\n\n- Create a partitioned table\n- Load data into partitions\n- Move and remove partitioned data\n- Review hierarchical partitioning\nModule 12: Directed Queries\n\n\n- Create an Optimizer-generated directed query\n- Create a custom directed query\nModule 13: Next Steps\n\n\n- Additional information located in the Vertica portal","summary_plain":"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.\n\n\n- The course includes a series of hands-on labs to teach the course material.\n- The content in this course is covered in the Vertica Analyst certification exam.\nHighlights:\n\n\n- Reading and interpreting a query execution plan\n- Automatic projection optimization using the Database Designer\n- Manual table and projection design to optimize for specific query execution\n- Overriding default configurations to improve query performance","skill_level":"Intermediate","version":"23.3","duration":{"unit":"d","value":3,"formatted":"3 jours"},"pricelist":{"List Price":{"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":2400}}},"lastchanged":"2025-07-29T12:18:36+02:00","parenturl":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-course-schedule\/34938","source_lang":"fr","source":"https:\/\/portal.flane.ch\/swisscom\/fr\/json-course\/opentext-vertpt"}}