EncartaLabs

Pivotal Greenplum Developer

( Duration: 3 Days )

The Pivotal Greenplum - Developer training course, provides with the necessary background to take advantage of Pivotal Greenplum. Attendees will learn the essential skills to use Pivotal Greenplum system. Attendees are introduced to fundamental concepts using the psql CLI; DDL, DML, and DQL; data loading strategies; data modeling, as well as some performance tuning strategies. They will also learn details of the OLAP capabilities of Pivotal Greenplum.

  • Basic UNIX or Linux command-line navigation and administration skills
  • Database query language basics, including but not limited to basic SQL knowledge for accessing database objects
  • Fundamental relational database concepts

  • Those who design and develop for Pivotal Greenplum.

COURSE AGENDA

1

Overview, Requirements, and Setup

  • Introduction
2

psql and Utilities

  • psql CLI Utility
3

Defining and Securing the Database

  • Data Definition Language
  • Data Manipulation Language & Data Query Language
4

Data Loading & Distribution

  • Implementing Table Storage Models, Compression and Tablespaces
  • Data Loading
  • Table Partitioning
5

Data Modeling and Design

  • Data Modeling
  • Physical Design Decisions
6

Performance Analysis and Tuning

  • SQL Joins - Types & Implementation
  • Pivotal Query Optimizer
  • Query Profiling
  • Query Tuning & Rewriting
  • Indexing Strategies
7

OLAP, Window Functions, UDF

  • Built-In Functions
  • Window Functions
  • User Defined Functions
  • User Defined Types

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top