Course Outline

Greenplum Database Overview?

  • What is Greenplum Database?
  • Greenplum Database features
  • Greenplum Database architecture

Preparing the Development Environment

  • Installing and configuring Greenplum Database

Administration

  • Creating users
  • Creating a group
  • Adding users

Database

  • Creating a database
  • Granting privileges
  • Creating a schema

psql Command Line

  • Loading and exporting data
  • Executing scripts

Queries and Performance

  • Analyzing tables
  • Changing optimizers
  • Partitioning tables

In-Database Analytics

  • Setting up Apach Zepellin
  • Aggregating data
  • Assembling results
  • Using Apache Madlib
  • Performing linear regression

Summary and Conclusion

Requirements

  • An understanding of RDBMS (Relation Database Management Systems)

Audience

  • Administrators
  14 Hours
 

Testimonials

Related Courses

Data Vault: Building a Scalable Data Warehouse

  28 hours

Big Data & Database Systems Fundamentals

  14 hours

Apache Druid for Real-Time Data Analysis

  21 hours

Apache Kylin: From Classic OLAP to Real-Time Data Warehouse

  14 hours

MemSQL

  28 hours

Amazon Redshift

  21 hours

Pivotal Greenplum for Developers

  21 hours

Big Data Business Intelligence for Govt. Agencies

  35 hours

From Data to Decision with Big Data and Predictive Analytics

  21 hours

Big Data Architect

  35 hours

Programming with Big Data in R

  21 hours

Big Data Storage Solution - NoSQL

  14 hours

Data Science for Big Data Analytics

  35 hours

A Practical Introduction to Data Analysis and Big Data

  35 hours

Vespa: Serving Large-Scale Data in Real-Time

  14 hours