Vertica Database 9.2.1 and MC Installation on CentOS Linux

Complete tutorial for Vertica single node cluster installation and administration with step by step hands on exercise

Created by: DataPad OÜ
Start your journey towards database and ETL world!

What Will I Learn?

• CentsOS download and installation in Virtualbox as a guest operating system
• CentOS configuration for Vertica installation
• Registration and download process of Vertica database and management console community edition software
• Single node Vertica database 9.2.1 database cluster installation and configuration in CentOS
• Detail navigation of Admin Tools for Vertica database administration from Linux command line
• Linux command line sql client usage for schema creation, user creation and grants
• GUI based sql client download, installation, jdbc driver configuration and sql usage
• Vertica Management Console 9.2.1 installation in CentOS
• HTTP port setting change in Firewall for Management Console UI access from host operating system
• Vertica Management Console configuration and detail navigation
• Importing already installed Vertica database cluster in Management Console and detail navigation
• Core DBA technology knowledge
• New trending topics will be added soon based on demand

Requirements

• Basic understanding of computers and networking
• Basic knowledge of SQL and Linux will be helpful but not required as detail instruction is present in course.
• Windows, Linux or Mac PC to complete hands on labs sessions.

Target audience

• Students looking for Vertica DBA as career in future
• Working IT professionals who wants to move in DBA track or change track from other database
• Anyone who is interested in understanding of data management and data security