Plan Szkolenia
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
Wymagania
- An understanding of database concepts.
Audience
- Developers
Opinie uczestników (4)
ćwiczenia i sposób ich tłumaczenia
Marcin Lipiec - Izba Administracji Skarbowej w Rzeszowie
Szkolenie - Wprowadzenie do Neo4j - grafowej bazy danych
Interakcja z prowadzącym, możliwość zadawania pytań na gorąco
Grzegorz Ziegert
Szkolenie - Administration with Powershell
how the trainor shows his knowledge in the subject he's teachign
john ernesto ii fernandez - Philippine AXA Life Insurance Corporation
Szkolenie - 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.