Duration

30 Hours(For Regular Course)

4-8 Hours(For Capsule Course)


Enroll Now

Request more information




Greenplum DBA

This web-based training course on Greenplum DBA functionality, administration and development, is available online to all individuals, institutions, corporates and enterprises in India (New Delhi NCR, Bangalore, Chennai, Kolkatta), US, UK, Canada, Australia, Singapore, United Arab Emirates (UAE), China and South Africa. No matter where you are located, you can enroll for any training with us - because all our training sessions are delivered online by live instructors using interactive, intensive learning methods.


Greenplum DBA is an open source massively parallel database that provides powerful and rapid analytics on petabyte scale data volumes. The system basically comprises of a master node, a standby node and various segment nodes. Primarily developed for big data analytics, Greenplum DBA is an array of individual databases that are based on PostgreSQL 8.2. In the web based Greenplum DBA course trainees will be taught all the foundational and advanced concepts of the system through hands on practice and online training from the finest professionals. The course will further focus on making trainees excel in the real time practical use of Greenplum DBA.


Core Concepts of Greenplum

  • A Brief overview of Data Warehousing/Data Mart
  • Integral topics, characteristics and Benefits of Greenplum
  • Framework of Greenplum
  • Shared Nothing and MPP Implementation

Set up and Initialization of Greenplum Database

  • Preparation and Verification of Systems
  • Initialization of Greenplum Database
  • Setting up Greenplum on your laptop VM

Important Tools, Utilities, and Internals in Greenplum Database

  • PSQL Client and Greenplum Utilities
  • Greenplum Performance Monitor
  • Greenplum Database Server Configuration
  • Greenplum Database Internals

Data Modeling and Design

  • Data Modeling
  • Physical Design Decisions

User Database: Definition and Security

  • Data Definition Language
  • Language Data Manipulation and Data Query
  • Responsibility, rights, and Resources

Distribution and Loading of Data

  • Loading Data
  • Dividing Table in Parts

Managing and Archiving Database

  • Greenplum Database Management
  • Backup and Restores

Performance Analysis and Tuning

  • JOIN Tables
  • Classifications and Methods
  • Tuning the Database
  • EXPLAIN Plan
  • Analyzing Queries
  • Using Statistics to Enhance Performance
  • Indexing Strategies

Using Advanced SQL to Develop Reports

  • Using Online Analytic Processing (OLAP) for Advanced Reporting
  • PostgreSQL Functions
  • Advanced SQL concepts and Tips on Performance

With the rising significance of big data, tool like Greenplum DBA are becoming more and more popular. At the present the use of Greenplum DBA is really touching great heights. Being a Massively Parallel database only adds to its significance and has provided organization a good way to analyze limitless volumes of data. On the professional side, as more and more organizations are adopting Greenplum DBA, the professionals who have all the prerequisite knowledge of the Massively Parallel Database are enjoying great demand. For those who are aiming for a career in the domain of big data can go for Greenplum DBA course online and get proficient in this particular technology.

1. Are lab-sessions available after theory sessions?

We provide online lab facilities to all our students, wherever possible & applicable, using a combination of one or more options, including global ASP setups, live-environments, real-time simulations, training-videos, PPTs, Screenshots and others.

2. Who and how qualified are the instructors?

All our instructors go through a rigorous and multiple processes of filtering and selection before they are appointed by us. Only the most qualified, most experienced and best suited candidates are chosen as instructors.

3.What are the machine requirements for the course?

You must have a fairly good desktop PC or laptop. You can even access these courses on your tabs or smart phones. For PCs and laptops the configuration should be at-least an Intel Pentium processor, 4GB of RAM and 50 to 100 GB of free hard disk space. You must also have a good and steady WiFi internet connection which works at 3G or 4G speeds.

4.How will I undergo practical training in the course?

Depending on the type of lab facilities available for the course you have enrolled in for our instructor would be happy to help you in your lab sessions.

5.What is the process to get my questions/queries answered?

Get in touch with your trainer. You can also consult your batch-mates. We believe in collaborative and practical learning.

6.Can a free demo session be provided?

We do not provide free demo sessions.

7.Will there be a provision for repetition if I miss a class?

We encourage our trainees to attend all sessions. If you have missed a session we will try out best to update you on it, if possible. Else you will need to pay a small fee to have a repeat session arranged specifically for you.

8.Does your organization provide assistance in job hunting?

We are connected across the industry in India and abroad. We will pass on any job openings from our customer to our trainees. But we are not a manpower placement provider.

9.How and where can I make the payment?

You can pay using any credit or debit card in India or abroad. You can also pay using your PayPal account.

10. Will practice material or tests be also provided with the course?

Yes. As required & as applicable.

11.What is the minimum or maximum batch size?

Minimum/maximum batch sizes vary from course to course, depending upon a number of factors. It can vary from as few as 2 to as many as a few hundred, in some cases. But that number does not impact the quality of training that we deliver due to our tight quality-control mechanisms.

All trainees will be provided with a course participation and completion certificate by Aurelius Corporate Solutions. Please note, we are an independent provider of learning solutions. We are not affiliated in any manner to any company or organization.

Copyright © 2016 Aurelius Corporate Solutions Pvt. Ltd. All Rights Reserved.