Detailed Course Outline
Module 1: Introduction to the Training Environment
- Log in to the training environment
- Review the training environment configuration
- Introduction to Management Console
- Using the valab utility
Module 2: Vertica Overview
- Describe the building blocks of the Vertica platform
Module 3: Introduction to Projections
- Identify basic projection types
- Read a projection DDL to determine its structure
- Describe the benefits of projections
Module 4: Loading Data
- Review the structure of tables and projections
- Load data using the COPY command
- Manually run the Tuple Mover mergeout task
- Monitor data loads using Management Console and vsql
Module 5: Query Execution
- Generate a query plan
- Time a query
- Profile a query
- Identify the database epochs
Module 6: Optimizing Database Design
- Create a comprehensive database design using Management Console
Module 7: Removing Data
- Remove data by dropping and truncating tables
- Bulk delete data from tables
- Purge delete vectors
Module 8: Database User Management
- Create new database users
- Create new database user roles
- Assign a role to a user
- Create a role hierarchy
Module 9: Table Access Privileges
- Assign inheritable privileges to a database schema
- Limit access to database columns and rows by role
- Restrict non-administrator access to system tables
Module 10: Database Backup and Restore
- Create a backup configuration file
- Back up and restore the database
- Monitor database backups
- Replicating objects
- Duplicating a cluster