Course Outline
Introduction
Setting up Pivotal Greenplum
Overview of Pivotal Greenplum Features and Architecture
Accessing Data
- DDL, DML, and DQL
Implementing a Table Storage Model
- Understanding tablespaces
- Compressing table data
Distributing the Data
- Distribution keys and partitioning
- Managing joins and indexing
Loading Data
- Table partitioning
OLAP Querying
- Implementing Greenplum functions
Modeling the Data
- Physical design considerations
Expanding the System
- Adding nodes
- Migrating data
Monitoring a Greenplum system
- Database activity and performance
Performance Tuning
- Optimizing queries
- Optimizing SQL joins
- Indexing optimization
Greenplum Best Practices
Troubleshooting
Summary and Conclusiond
Requirements
- An understanding of database concepts.
Audience
- Developers
Testimonials (4)
how the trainor shows his knowledge in the subject he's teachign
john ernesto ii fernandez - Philippine AXA Life Insurance Corporation
Course - Data Vault: Building a Scalable Data Warehouse
Los conocimientos del instructor y experiencia
Mauricio Somohano Ríos - INTERCAM BANCO SA INSTITUCION DE BANCA MULTIPLE, INTERCAM GRUPO FINANCIERO
Course - Beyond the Relational Database: Neo4j
The way trainer demonstrated everything
Manveen - Tribal Grou[
Course - Developing Applications with Oracle Application Express (APEX)
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain. The topics became more suitable/usable to us.