0

We are providing Greenplum and PostgreSQL training

India, Tamil Nadu, Chennai
Published 5 months ago
ID #1758
1 photo
100000.00 ₹
1320.00 EUR
1210.00 GBP
1560.00 USD
We are providing Greenplum and PostgreSQL training
India, Tamil Nadu, Chennai,
Published 5 months ago

Description

Working with Greenplum Platform and PostgreSQL Customized Hands-on Workshop
Total Duration: 40 Hours



Setup: Online in 10 sessions / 4 hours each

1. Greenplum and PostgreSQL Fundamental Concepts (4 hours / 1 session)

Introduction to PostgreSQL Architecture
Basics of Data Warehousing
Greenplum Concepts, Features, and Benefits
Greenplum Architecture
Shared Nothing and MPP Implementation
Versioning, Rereleases, Appliances and Pluggable Modules
2. Database Installation and Initialization (8 hours / 2 sessions)

Setup of PostgreSQL Single Instance
Greenplum distribution of PostgreSQL Instances
Systems Preparation and Verification
Greenplum Database Initialization
Basic Validation and Administration Commands
Connecting to Greenplum from Different Applications
3. Greenplum Database Tools, Utilities, and Internals (4 hours / 1 session)

PostgreSQL Core Database Functionality
PSQL Client and Greenplum Utilities
Greenplum Performance Monitor
Greenplum Database Server Configuration
Greenplum Database Internals
4. Defining and Securing the User Database (4 hours / 1 session)

Understanding Greenplum Platform Structure
Data Definition Language
Data Manipulation and Data Query Language
Roles, Privileges, and Resources
5. Data Loading and Distribution (4 hours / 1 session)

Data Loading
Table Partitioning
Streaming and Real-time Tools
Integration with Analytics Platforms
6. Database Management and Archiving (4 hours / 1 session)

Managing PostgreSQL Instances
Managing the Greenplum Database
Backup and Restores
Patching and Maintenance Operations
7. Data Modeling and Design (4 hours / 1 session)

Data Modeling
Physical Design Decisions
Performance turning overview
Database Tuning and Indexing
8. Functions, Analysis and Advanced SQL (8 hours / 2 sessions)

Advanced Analysis Using Online Analytic Processing (OLAP)
PostgreSQL Functions
User-Defined Functions for Greenplum Cluster
Advanced SQL Topics and Performance Tips

Contact :
+918838953252
nijam@rayafeel.com

 

Contact publisher

    Seller's picture
    Company
    Registered on 14. Apr 2019
    You must log in or register a new account in order to contact the advertiser.
    100000.00 ₹
    1320.00 EUR
    1210.00 GBP
    1560.00 USD

    Publisher's info

    Seller's picture
    Company
    Registered on April 14, 2019

    Listing location

    India, Tamil Nadu, Chennai
    Spencer Plaza
    Online chat
    Login to start chatting Sign in