Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
21 Hours
Testimonials (2)
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
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.