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

Number of participants



Price per participant

Testimonials (1)

Related Courses

Data Vault: Building a Scalable Data Warehouse

28 Hours

Amazon Redshift

21 Hours

Big Data & Database Systems Fundamentals

14 Hours

Azure Data Lake Storage Gen2

14 Hours

Apache Druid for Real-Time Data Analysis

21 Hours

Pivotal Greenplum for Developers

21 Hours

IBM Datastage For Administrators and Developers

35 Hours

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

14 Hours

MemSQL

28 Hours

Big Data Analytics for Telecom Regulators

14 Hours

Big Data Business Intelligence for Govt. Agencies

35 Hours

Big Data Architect

35 Hours

Big Data Business Intelligence for Criminal Intelligence Analysis

35 Hours

Programming with Big Data in R

21 Hours

Big Data Storage Solution - NoSQL

14 Hours

Related Categories

1