Detailed Course Outline
Module 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 portal