Course Overview
The Vertica Essentials course covers the architecture and capabilities of Vertica Analytics in Enterprise mode. This course is a prerequisite to all advanced courses and will prepare you for the operational success of your deployment.
Highlights:
- Describe the Vertica data architecture
- Manage data within a Vertica database, including loading and removing data
- Describe how SQL queries are executed
- Modify the database structure for optimal query execution
- Manage database users
Who should attend
Database Administrators
Prerequisites
To be successful in this course, you should have the following prerequisites or knowledge:
- Knowledge of RDBMS concepts (understanding databases and schemas, database normalization, etc.)
- Familiarity with basic SQL syntax, ability to troubleshoot syntax errors, etc.
- Experience with the Linux operating system (how to change directories, list directory contents, view and edit files, etc.)
Course Objectives
On completion of this course, participants should be able to:
- Describe Vertica’s database and data storage structures
- Load and remove data from a Vertica database
- Optimize the database to improve query performance
- Create and manage database users
- Back up and restore a Vertica database
Course Content
- Module 1: Introduction to the Training Environment
- Module 2: Vertica Overview
- Module 3: Introduction to Projections
- Module 4: Loading Data
- Module 5: Query Execution
- Module 6: Optimizing Database Design
- Module 7: Removing Data
- Module 8: Database User Management
- Module 9: Table Access Privileges
- Module 10: Database Backup and Restore
English