VERTPTMFOpenTextMF-VERTPT23.3<p>On completion of this course, participants should be able to:</p> <ul> <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><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>A basic knowledge of SQL</li></ul><p>Database administrators, product managers, and quality assurance team members</p><ul> <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><h5>Module 1: The Lab Environment</h5><ul> <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> <li>Identify common query performance issues</li><li>Become familiar with the database environment</li></ul><h5>Module 3: Projections in Vertica</h5><ul> <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> <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> <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> <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> <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> <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> <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> <li>Create a flattened table</li><li>Populate the table with default and derived values</li></ul><h5>Module 11: Partitioned Tables</h5><ul> <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> <li>Create an Optimizer-generated directed query</li><li>Create a custom directed query</li></ul><h5>Module 13: Next Steps</h5><ul> <li>Additional information located in the Vertica portal</li></ul>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 parametersTo be successful in this course, you should have the following prerequisites or knowledge: - Completion of Vertica Essentials (OnDemand or Instructor-led) or equivalent experience - A basic knowledge of SQLDatabase administrators, product managers, and quality assurance team members- Module 1: The Lab Environment - Module 2: Introduction to Database Design - Module 3: Projections in Vertica - Module 4: Query Execution - Module 5: Optimizing the Database - Module 6: Profile Analysis - Module 7: Query Profiling Parameters - Module 8: Column Positioning - Module 9: Manual Projection Design - Module 10: Flattened Tables - Module 11: Partitioned Tables - Module 12: Directed Queries - Module 13: Next StepsModule 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 portal3 jours2400.00