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 (2)