Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Pivotal Greenplum Developer

( Duration: 3 Days )

The Pivotal Greenplum - Developer training course, provides the necessary background to take advantage of Pivotal Greenplum. You will learn the essential skills to use Pivotal Greenplum system. You will be introduced to fundamental concepts using the psql CLI; DDL, DML, and DQL; data loading strategies; data modeling, as well as some performance tuning strategies. You 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

  • This Pivotal Greenplum - Developer workshop is meant for 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 6,000 various courses 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 https://www.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
Notice
X