Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 57 Minute(s)
Language
English
Taught by
DataPad OÜ
Rating
Course Overview
Complete tutorial for Vertica single node cluster installation and administration with step by step hands on exercise
PLEASE NOTE THIS IS A VERY HANDS ON COURSE. IF YOU ARE LOOKING FOR COURSE THAT TALKS TO SLIDES, THIS IS NOT FOR YOU.
Course targeted to anyone who wants to start their carrier in Vertica Database administration.
Following topics are covered in the course
CentsOS installation in Virtualbox
CentOS Basic Commands, Navigation, Shutdown
Vertica Software installation
Vertica configuration and database creation
Virtual machine resolution change
Schema and user creation from vsql prompt
Squirrel GUI sql client usage
Vertica Management Console installation and configuration
Importing Vertica database cluster in Management Console
Course Content
- 7 section(s)
- 12 lecture(s)
- Section 1 Introduction
- Section 2 CentOS installation in Virtualbox
- Section 3 Vertica installation and configuration
- Section 4 Vertica SQL from CLI and GUI
- Section 5 Vertica Management Console installation and configuration
- Section 6 Database cluster import in Management Console
- Section 7 Thank You
What You’ll 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
Skills covered in this course
Reviews
-
VVinai Kumar
Yes, As i was need to learn Vertca DBA. So,It's matching and learnt about vertica dba and SQL queries and configuration. Thankyou!
-
AAkash Ramdas Bhonde
Good
-
SSurya Sekhar bhattacharya
Excellent Step by Step guide..Perfect for a newcomer.
-
SSameer K Mohammed
amazing content
