What is Vertica, Why we use Vertica :

Our beginning of Module will include A Brief introduction of Vertica – and its Architecture.

This Includes:

• Understanding why Vertica is known as columnar Data Base and what are all its benefits.
• How it different from other Data Base (like Oracle) & why most of the projects are now migrating to Vertica.
• Data Encoding & Compression in Vertica.
• Clustering, K-safety and Continuous Performance (HA) – A Promise by Vertica.

Creating & Loading Facts and Figures:

Every bricks of a Data Base is a Table. Data Base starts with Table and end with Table. This module is going to have:

• Creating a table and playing with multi-tables (via Join).
• Loading table – A Best Practice of Vertica Copy Command – The most useful Vertica Command of all time.

Vertica-Table is all about its Projections:

Vertica is as equal as Zero without its Projections. In this Module we are going to learn what Projections is. This Module includes:

• What projection are going to do.
• How projections are being created.
• Types of Projections and its uses.
• Projection Segmentation.

How to make Vertica as fast as ‘a ray of light’:

Vertica is all knows as Best Performance Data Base, so to keep it at its best what all we need to do is:

• Optimising Performance for Insert statement.
• Starts Working with Vertica-hints.
• Making Data Read as real time with Best practice Segmentation and Shorting Order techniques.

Deletion – The Most Trickiest Part of Vertica:

Inserting data in Vertica’s Table as is easy as writing ABCD… on a piece of paper, but it isn’t the case with deleting them. This Module includes:

• Understanding why Vertica provides use Partition-Table and how to use it.
• Understanding Ancient-History-Mark and dealing with Purge-Delete-Vector.
• Usage of “Purge table” Command.

Monitoring Vertica:

Vertica provides us two main component, which uses for its Control/Maintenance purpose:

• The Administration Tools – Starting/Stopping Data Base, Restarting Host.
• Management Console – Reading Data Base Quality from its base-end.

Backing-up & Restoring Vertica:

What happen if all of sudden our system crashes, how we are going to migrate/manage all of our data? This critical stake can be handled by:

• Creating vbr.py file – A Backup Configuration file.
• Creating full and incremental Backup.
• Restoring Database.

What if I miss a class?

Don’t worry. You will always get a recording for the class in your inbox. Have a look at that and reach out to the faculty in case of doubts. All our live classes are recorded for self-study purpose. Hence, in case you miss a class, you can refer to the video recording and then reach out to the faculty during their doubts clearing time or ask your question in the beginning of the subsequent class.

Can I download the recordings?

Yes. We provide url for the video downloads.

Recordings are integral part of BSAI Academy intellectual property. The downloading/distribution of these recordings in anyway is strictly prohibited and illegal as they are protected under copyright act. Incase a student is found doing the same, it will lead to an immediate and permanent suspension in the services, access to all the learning resources will be blocked, course fee will be forfeited and the institute will have all the rights to take strict legal action against the individual.

Will I get a certificate in the end?

Yes. All our course are certified. As part of the course, students get weekly assignments and module-wise case studies and Exam will be taken at end after course completion. Candidates must bring 85% score on exam. Once all your submissions are received and evaluated, the certificate shall be awarded.

Do you guarantee placements?

No institute can guarantee placements, unless they are doing so as a marketing gimmick! It is on a best effort basis.

In professional environment, it is not feasible for any institute to do so, except for a marketing gimmick. For us, it is on a best effort basis but not time – bound – in some cases students reach out to us even after 3 years for career support.

Do you have a classroom option?

No. We provide only online let training.

What do I need to attend the online classes?

To attend the online classes, all you need is a laptop/PC with a basic internet connection. Students have often shared good feedback of attending these live classes through their data card or even their mobile 3G connection, though we recommend a basic broadband connection.

For best user experience, a mic-headphone is recommended to enhance the voice quality, though the laptop’s in-built mic works fine and you can ask your question over the chat as well.

How can I reach out to someone if I have doubts post class?

Students can always connect with the trainer or even schedule one-to-one time via online. During the course we also schedule periodic doubts-clearing classes though students can also ask doubts of a class in the subsequent class.

I am having difficulty coping up with my classes. What can I do?

For all the courses, we also provide the recordings of each class for their self-reference as well as revision in case you miss any concept in the class. In case you still have doubts after revising through the recordings, you can communicate with your trainer/tutor via email.

Can I pay in instalments?

Not for this course. The instalment options are available only for our courses which are atleast 3 months long.

What are the system requirements for the software?

It is recommended to have 64-bit operating system with minimum 8GB RAM so that the virtual lab can be installed easily

Is it feasible to attend a demo session before enrollment?

Unfortunately participation in a live class without enrollment is not possible. However, We can provide you the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in the class.

HP  Vertica Certification

The entire training course content is in line with the certification program and helps you clear Java Spring Certification Exam with ease and get the best jobs in the top MNCs. As part of this training you will be working on real time projects and assignments that have immense implications in the real world industry scenario thus helping you fast track your career effortlessly.

At the end of this training program there will be a exam that helps you score better marks in certification exam. The student must score 80% for certification.