1-6001 – Vertica Essentials

Target group

Database Administrators

Course structure

Module 1: Course Introduction

• Overview of course structure
• How to request a training lab environment
• Contact information

Module 2: 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 3: Vertica Overview

• Describe the building blocks of the Vertica platform

Module 4: Introduction to Projections

• Identify basic projection types
• Read a projection DDL to determine its structure
• Describe the benefits of projections

Module 5: 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
• Contrast data loading in Enterprise and Eon mode

Module 6: Query Execution

• Generate a query plan
• Time a query
• Profile a query
• Identify the database epochs

Module 7: Optimizing Database Design

• Create a comprehensive database design using Management Console

Module 8: Partitioning Table Data

• Introduction to partitioning
• Create partitioned tables
• Load data into partitions
• Move partitioned data into archive tables
• Hierarchical partitioning

Module 9: Removing Data

• Remove data by dropping and truncating tables
• Bulk delete data from tables
• Purge delete vectors
• Remove data by dropping partitions

Module 10: Database User Management

• Create new database users
• Create new database user roles
• Assign a role to a user
• Create a role hierarchy

Module 11: 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 12: Resource Management

• The importance of resource management
• How Vertica allocates resources to queries
• The built-in resource pools
• The resource pool parameters

Module 13: Database Backup and Restore

• Create a backup configuration file
• Back up and restore the database
• Monitor database backups
• Replicating objects
• Duplicating a cluster

Module 14: Flex Tables and Semi-Structured Data

• Define and describe semi-structured data
• Create flex tables and their supporting objects
• Load data in different formats into flex tables
• Explore data stored in flex tables
• Creating views
• Updating attributes