30 Hours(For Regular Course)

4-8 Hours(For Capsule Course)

Enroll Now

Request more information


This web-based training course on GREEN PLUM 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.

This course offers an opportunity for the trainees to get well versed in fundamental concepts of the Greenplum database and EMC DCA (Data Computing Appliance). This training program is useful for beginners as it covers postgre SQL essentials, basic SQL structures, user maintenance, roles and privileges, data types and functions. This certification training helps to learn the most important key features of the unique Greenplum architecture and to get familiar with terminology, data distribution and high level optimization methods. The students will gain the exposure to the installation, configuration, up gradation and maintenance of the Greenplum database system. The main objectives of this online training course are: column oriented storage techniques, loading and backup techniques, scripting Greenplum by Python or Pearl. Further, the online certification course will provide trainees the experience with the main features such as resource queues and advanced workload management.

Introduction to Greenplum

  • Greenplum Architecture
  • About the Greenplum Master
  • About the Greenplum Segments
  • About Segment Mirroring
  • Segment Failover and Recovery
  • About Master Mirroring

About Distributed Databases

  • Understanding Greenplum Distribution Policies
  • Broadcast

About Greenplum Query Processing

  • Understanding Query Planning and Dispatch
  • Understanding Greenplum Query Plans
  • Understanding Parallel Query Execution

Access control and security

  • Managing Roles and Privileges
  • Security Best Practices for Roles and Privileges
  • Creating New Roles (Users)
  • Creating Groups (Role Membership)
  • Managing Object Privileges
  • Encrypting Data
  • Time-based Authentication

Configuring Client Authentication

  • Allowing Connections to Greenplum Database
  • Limiting Concurrent Connections

Accessing the Database

  • Establishing a Database Session
  • Supported Client Applications
  • Greenplum Database Client Applications
  • Database Application Interfaces
  • Writing Stored Procedure in PL/pgSQL
  • Triggers
  • Writing a Trigger in PL/pgSQL
  • Watching Triggers in Action

Backing Up and Restoring Databases

  • Overview of Backup and Restore Operations
  • Backing Up a Database
  • Restoring From Parallel Backup Files
  • pg_dump

Monitoring a Greenplum System

  • Monitoring System State
  • Viewing the Database Server Log Files
  • Monitoring Database Activity and Performance

Routine System Maintenance Tasks

  • Routine Vacuum and Analyze
  • Routine Reindexing
  • Managing Greenplum Database Log Files

Common Causes of Performance Issues

  • Identifying Hardware and Segment Failures
  • Maintaining Database Statistics
  • Optimizing Data Distribution
  • Optimizing Database Design

Investigating a Performance Problem

  • Checking System State
  • Checking Database Activity
  • Troubleshooting Problem Queries
  • Investigating Error Messages

Managing Workload and Resources

  • Overview of Greenplum Workload Management
  • Configuring Workload Management
  • Creating Resource Queues
  • Assigning Roles (Users) to a Resource Queue
  • Modifying Resource Queues

Defining Database Objects

  • Creating and Managing Databases
  • Creating and Managing Tablespaces
  • Creating and Managing Schemas
  • Creating and Managing Tables
  • Choosing the Table Storage Model in Greenplum
  • Partitioning Large Tables
  • Creating and Using Sequences
  • Indexes in Greenplum Database
  • Creating and Managing Views

Managing Data

  • About Concurrency & Isolation in GPDB
  • Inserting New Rows
  • Updating Existing Rows
  • Deleting Rows
  • Vacuuming the Database
  • Analysing QUERY PLAN

Oracle Compatibility Functions

  • Installing Oracle Compatibility Functions
  • Available Oracle Compatibility Functions

Greenplum Database is an advanced, multi-featured, open source data warehouse. Greenplum database adds Innovative Query Optimizer which is the industry’s first cost-effective query optimizer for big data workloads. It helps to scale interactive and batch mode analytics to larger datasets in the petabytes without reducing query performance and throughput. The training program helps to use table partitioning as a method for dealing with large tables. The Greenplum Database also provides integrated email as well as SNMP notification in the case of any event needing attention. This online training program also helps in database management, archiving, modeling, design, performance analysis and tuning. Hence, this course is more application focused as compared to theory focused in order to give the trainees a profound usability experience and procedures.

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.