Vertica is a cluster-based, column-oriented analytics platform for managing large and fast growing data volumes. It features fast query performance, standard SQL interface, compression, and support for standard programming interfaces. The biggest advantage of Vertica is the raw speed. It is extremely fast when compared to other analytical databases, and it boasts features that make joins extremely fast. One of the key assets in Vertica architecture is the fact that it will take a mass of data and apply all types of encoding such as RLE encoding and compression so that the footprint will be as small as possible.
Program Highlights
Instructor Led Live Online Batches:
Week-end Batches | |||
7th Apr | Sat - Sun | 6 Weeks | 11:30 AM - 02:30 PM (IST) |
7th Apr | Sat - Sun | 6 Weeks | 07:30 PM - 10:30 PM (IST) |
Can’t find convenient schedule? Let us know.
Key Objectives
Upon successful completion of this course, you will be able to:
Describe Vertica’s database and data storage structures

Load and remove data from Vertica database

Optimize the database to improve query performance

Create and manage database users and resources

Backup and restore Vertica database

Find additional information and resources for working with Vertica

Comprehensive understanding of general SQL analytics

Diagnose and optimize query performance within an HP Vertica deployment

Tune and simplify database queries

Why Learn Vertica?
-
This course provides you with an in-depth introduction and hands-on experience with Vertica Analytics tools and concepts. The course provides a comprehensive understanding of general SQL analytics, as well as a comprehensive introduction to the Vertica-specific analytic functions (including event based windowing, gap filling and interpolation, event series joins, and pattern matching). This class combines lectures with hands-on laboratory exercises performed in a live Vertica database cluster.
-
This course provides an intensive deep-dive into the process of diagnosing and optimizing query performance within a Vertica deployment. You will learn how to tune and simplify database queries, modify resource settings, monitor and update statistics, and interpret the output of the Workload Analyzer.
Who should go for this course?
-
Database Administrators, Database Architects, Data Analysts, and Application Developers
Pre-requisites:
To be successful in this course, you should have the following prerequisites or knowledge.
-
Intermediate knowledge of RDBMS concepts (understanding databases and schemas, database normalization, etc.)
-
Basic understanding of SQL (familiarity with basic SQL syntax, ability to troubleshoot syntax errors, etc.)
-
Basic experience with the Linux operating system (how to change directories and list the contents, how to view and edit files, etc.
FAQ’s
Our 24 x 7 support team will guide & assist you for hands off experience on virtual cloud environment. Will also assist you in installation & configuration of Teradata.
All our instructors are working professionals from the Industry and have at least ten years of relevant experience in various domains and have extensive functional expertise in the field they train. They are trained by our mentors for providing online training so that participants get a great learning experience.
Requesting for a support session is a very simple process. As soon as you join the course, the contact number and email-id of the support team will be available in your LMS. Just a phone call or email will solve the purpose.
These classes will be completely Online Live Instructor-led Interactive sessions. You will have chat option available to discuss your queries with instructor during a class.
We offer this training in the following modes: 1. Live Virtual Classroom or Online Classroom: With online classroom training, you have the option to attend the course remotely from your desktop via video conferencing. This format saves productivity challenges and decreases your time spent away from work or home. 2. Online Self-Learning: In this mode, you will receive the lecture videos and you can go through the course as per your convenience.
Yes, you can cancel your enrolment if necessary. We will refund the course price after deducting an administration fee. To learn more, you can view our Refund Policy.
Our 24 x 7 support team will guide & assist you for hands off experience on virtual cloud environment. Will also assist you in installation & configuration of Teradata.
All our instructors are working professionals from the Industry and have at least ten years of relevant experience in various domains and have extensive functional expertise in the field they train. They are trained by our mentors for providing online training so that participants get a great learning experience.
Requesting for a support session is a very simple process. As soon as you join the course, the contact number and email-id of the support team will be available in your LMS. Just a phone call or email will solve the purpose.
These classes will be completely Online Live Instructor-led Interactive sessions. You will have chat option available to discuss your queries with instructor during a class.
We offer this training in the following modes: 1. Live Virtual Classroom or Online Classroom: With online classroom training, you have the option to attend the course remotely from your desktop via video conferencing. This format saves productivity challenges and decreases your time spent away from work or home. 2. Online Self-Learning: In this mode, you will receive the lecture videos and you can go through the course as per your convenience.
Yes, you can cancel your enrolment if necessary. We will refund the course price after deducting an administration fee. To learn more, you can view our Refund Policy.