Vertica Database Administration Training

Live Online & Classroom Enterprise Training

This course provides comprehensive training on administering, monitoring, and optimizing Vertica databases. Learners gain hands-on skills to manage installations, ensure high availability, perform backups and recovery, and tune performance in enterprise data warehouse environments.

Looking for a private batch ?

REQUEST A CALLBACK

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is Vertica Database Administration Training about?

The Vertica Database Administration course equips professionals with practical knowledge to manage Vertica’s high-performance analytical database platform. It covers architecture, installation, cluster management, security, performance tuning, backup strategies, and troubleshooting. By the end of the course, learners will be able to confidently handle real-world administrative tasks in production environments.

What are the objectives of Vertica Database Administration Training ?

Understand Vertica architecture and components
Install and configure Vertica environments
Manage users, roles, and security
Perform backup, recovery, and monitoring
Optimize performance and troubleshoot issues

Who is Vertica Database Administration Training for?

Database Administrators (DBAs)
Data Engineers
System Administrators
BI / Analytics Professionals
IT Infrastructure Engineers

What are the prerequisites for Vertica Database Administration Training?

Prerequisites:

Basic SQL knowledge
Understanding of databases concepts
Familiarity with Linux commands
Knowledge of data warehousing basics
Basic networking concepts

Learning Path:

Vertica architecture fundamentals
Installation and cluster configuration
User, resource, and workload management
Monitoring, performance tuning, and optimization
Backup, recovery, and high availability

Related Courses:

Data Warehouse Fundamentals
Advanced SQL for Analytics
Linux Administration
Big Data Technologies (Hadoop/Spark)

Available Training Modes

Live Online Training

3 Days

Course Outline Expand All

Expand All

Module 1: The Vertica Training Environment

Review the training environment configuration

Associate the Management Console with a Vertica database

Start a database

Module 2: Managing Vertica Clusters

View the database state in the system tables

Shut down and restart a node in the Management Console

Manage system messages

Module 3: Loading Data

Load data into the database from a file

Identify and correct data parsing errors

Load semi-structured data

Correct a projection for data skew

Module 4: Monitoring Data

Monitor the ROS container count

Manually run the Tuple Mover tasks

Monitor DELETE VECTORS

PURGE deleted records

Update the database statistics

Module 5: Optimizing the Database Design

Create and deploy a comprehensive database design using admintools

Review Database Designer outputs from admintools and MC

Create and deploy an incremental database design using MC

Review the database logging tables

Identify concerns with DELETE optimization

Module 6: Epoch Management

Find and identify epochs using the SYSTEM table and database functions

Determine the duration that epochs can be used in a predicate

Find the epoch in which data has been loaded

Use historical queries to find data loaded at different epochs

Module 7: User Management

Create a new user password profile

Create new database users

Create new database user roles

Assign a role to a user

Create a role hierarchy

Module 8: Table Access Privileges

Assign inheritable privileges to a database schema

Limit access to database columns by role

Restrict non-administrative access to system tables

Module 9: Resource Management

Define the default resource pools

Describe the purpose of resource pool parameters

Create and modify a resource pool

Test the user access to the new resource pool

Analyze and correct a user resource issue

Module 10: Database Backup and Recovery

Determine the required backup disk storage space

Back up the database

Review the database backups

Restore the database

Module 11: Maintaining a Database and Cluster

Determine the required backup disk storage space

Back up the database

Review the database backups

Restore the database

Identify the Vertica database version

Estimate the database size

Audit and update an Vertica license

Add a host to a cluster

Add a node to a database

Module 12: The Catalog and Data Directories

Describe the contents of the Catalog and Data directories

View the vertica.log file in Management Console

Rotate the vertica.log file

Module 13: System Maintenance

Determine and modify the amount of system data maintained in a system table

Run the Workload Analyzer to find system tuning recommendations

Enable SNMP Traps and Syslog

Module 14: Next Steps

Accessing Micro Focus Software’s additional training offerings

Additional information located in the MyVertica portal

Who is the instructor for this training?

The trainer for this Vertica Database Administration Training has extensive experience in this domain, including years of experience training & mentoring professionals.

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree