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
 

Need help picking the right course?
Call us +971 4871 6715

Testimonials

knowledge and translations

Jan Maksymowski

I liked the examples and the way he explained.

Sandeep Parashar

The explanation way and including tips on the best practices in VBA/Access, encouraging via exercise to think more by ourselves on how to solve the problem rather than giving ready solutions.

Daria Rudin

Tamil was exceptionally patient and very helpful in figuring out solutions to real needs. He was also very honest about if he didn't know something from the top of his head, which enabled us to quickly jump on in the training and we didn't lose time.

Christine Weiler

Substantive preparation, attention to detail

Sebastian Łubik

I really liked the monitoring.

Ling Xiao

Very high competence of the trainer!!.

Heino Eilers

I mostly liked the good content and exercises.

Richard Smallwood

Complete knowledge of the lecturer.

Bogusław Stanek

A lot of exercises with different levels of difficulty and individual approach of the trainer to each participant

Agnieszka Cybula

I generally was benefit from the open mind and communication.

Oleksiy Deliyev

It is difficult to assess the very consistent training. Everything was liked

Damian Ostrega

I genuinely enjoyed the trainer Subject Knowledge.

Julian Pirau

A large number of exercises

Wojciech Kozioł

individual and patient approach to each question / problem and understandable explanation / translation / solution

Grzegorz Krzeczek

Possibility to ask questions, adjust the pace to the needs, focus on those elements that from the participants' point of view are the most interesting / needed / difficult.

Aleksandra Wójtowicz

Communicativeness, broad subject knowledge, openness to questions beyond the training program

Michał Woźny

Quality of training, and explanation of approach methods to issues

Blazej Baron

Trainer provided some topic and support it with plenty of exercises. We had a chance to apply knowledge by doing them on our own.

UBS Business Solutions Poland Sp. z o.o.

A professional and accessible way of transferring knowledge and assistance during training and exercises.

Michal Bialek

I enjoyed the access to trainers individual support in resolving exercises.

Tomasz Czornak

I enjoyed learning how to maintain the database, and how is the orgenazition of the data.

Jiang Chang

A lot of practical examples.

Paweł Miązek

Trainer had good practical knowledge about using Cassandra day-to-day at least for development purposes. Catering (snacks, coffee hour) were great 3 days length was good.

Mika Linnanoja

Good atmosphere during the training.

clovis Nebouet

practical

Andrzej Kozak

I liked the super atmosphere, working with Congo shell.

Jan Sturm

Training material was very informative. Learned a lot.

Yaw Asamoah

I really enjoyed the lessons and examples.

Kelly Taylor

He adapted to the experience of the group, gave us great value for a beginners course.

Rich Mickey

commitment of the teacher

Sylwia Żokowska

I liked the way of conducting the training the most. It was not carried out too quickly, and in a way that everyone could write down everything and learn.

Agnieszka Grzywa

The structure and pace of the class was great.

David Lacy

The depth of the Congo db training was explored from basic to advanced, I felt it was a little too much to squeeze into 2 days but I did get exposure to all aspects of Congo db.

Bay Sayarath

I liked that the course was relevant to our need.

Damon Grube

Most of the hands-on stuff was good.

Andrew Bauer

I genuinely liked that there was no pressure.

Eyal Wirsansky

I liked everything he taught.

Emily Zhou

I appreciated Folio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).

Raphael Keymer - Markit Valuations Limited

Enjoyed the pace, delivery and technical know how of the trainer.

Junaid Kalang

Very in depth knowledge on the subject matter. No “I'll have to look into that and get back to you, just new it all”.

David Marshall

Life examples, experience, deep knowledge about the operation of the database and configuration options.

Łukasz Picur

The trainer, he was knowledgeable, engaging, and easy to learn from. He encouraged a lot of hands-on learning.

Shawn McAndrew

It was addressed to the specific topics and questions

Jürgen Demant

I like fact, that after each section we had exercises. It helps to remember discussed topic.

Adam Bińczycki

Knowledge of the lecturer

Paweł Dybowski

very interactive

Martin Seidler

Knowledge of the trainer ok. After improving the improvement, I would choose the trainer again.

Michał Komarnicki

I learned a LOOOOOT.

Kamil Szmid

sql works even if I don't know why

Dominik Gardo

Topics approached. Very complete.

Carlos Eloi Barros

The last exercise was very good.

José Monteiro

I already using and have an application in production with Cassandra so mostly of the topics i already know but the data modeling and advanced topics are a lot interesting.

Tiago Costa

There was a lot of knowledge and material shared that will help me to do my current tasks.

Miguel Fernandes

I liked the amount of exercises. We could immediately apply the knowledge shared and ensure the information was on point.

Joana Pereira

I liked all technical explanation and theoretical introduction.

André Santos

I enjoyed the very good explanations with in depth examples.

Rui Magalhaes

The practical exercises and examples of implementing examples of real models and contexts.

Leandro Gomes

A wide knowledge of the trainer and commitment, the ability to be interested in the topic.

Michał Komarnicki

individual approach of the trainer to people participating in the training

Wojciech Gądzikiewicz

exercises (tasks) to be carried out, examples from the professional experience of the trainer

Tomasz Niewiadomski

Showing how well-known mechanisms are performed on the database side, e.g. they are processed in memory

Marcin Czerwiec

The training was perfectly prepared, I liked the way of running based on real-time examples with a detailed discussion of the impact of individual instructions on the database.

Joanna Dymarczyk

adapting the material to the knowledge, interests and needs of the interested; a small group of trainers helped in learning more quickly; nice way of conducting, trivia, conversation

Łukasz Madej

I liked that the course was tailored to cover our organizations questions.

Robin Bell

The clear depth of knowledge the trainer had, which really shone when combined with his evident enthusiasm for the subject.

Joseph Brailsford

Even though I have been using MongoDB for a while, there were still some new “basic” things that Tamil taught us - as well as teaching us the advanced topics we need to move our projects forwards.

Adam McKay

a lot of exercise

Łukasz Dziewiński

Commitment and passion of the trainer ☺. And with the problem of managing backupmi, Joby.

Krzysztof Klockowski

A lot of different exercises.

Celina Gromadzka

practical examples

Anita Sępkowska

I enjoyed the attention to detail, knowledge and enthusiasm for the subject.

Bristol City Council

The 1:1 style meant the training was tailored to my individual needs.

Andy McGuigan

TRENER has a practical insight, which greatly facilitates the possibility of answering purely practical issues

Krzysztof Goździk

The ability to ask questions at any time and the more informal / less structured style. This allowed us to pursue the areas of knowledge we were most interested in.

Jim Lane

tempo of classes, flexibility as to the content of the training related to the expectations of users

Karol

Pace, explanation of issues from a completely different angle. Something that explains how everything works from the server side

P4 Sp. z o.o.

number of issues covered

P4 Sp. z o.o.

adaptation to the needs of the participants, very good exploration of the discussed tasks, comprehensive answers to the asked question

Marcin Gołdyn

Work on a physical database.

P4 Sp. z o.o.

adapting to the needs of the listeners, analyzing the problems they report

P4 Sp. z o.o.

I genuinely liked the explanations.

Lowe's

I genuinely was benefit from the training knowledge and mechanic.

Sutiipong Bumlungvech

Exercises on functions!

WIktor Paprzycki

way of translation

Małgorzata Mieczkowska

exercises

Wiktor Paprzycki

examples, openness of the trainer

INTERNATIONAL PAPER POLSKA

flexibility

dawid bodo

exercises

Mateusz Wilk

practical exercises

Małgorzata Wieczorek

practical part

Marcin Witosławski

Exercises, the possibility of practical knowledge acquisition, group cooperation in solving problems.

Emil Lewandowski

Adrian was knowledgeable in Linux and MongoDB. He was able to troubleshoot the labs on our computers very quickly when we had mistakes.

MInistry of Defence

A lot of practical examples

Marta Krupińska

The flexibility of the trainer and the ability to adjust the exercises to the questions raised during the training. The training did not have a rigid plan, the plan evolved during the training under the influence of my needs.

Paweł Imbir

interaction with listeners,

Katarzyna Szabelska

perfect personal contact

Fujitsu Technology solutions Sp. z O. O.

I enjoyed the backup and restore and multiple instances.

Lakshmi Ponnada - Albany Medical Center

Gives a good overview of Cassandra. Especially the virtual box training environment is nice also for later use.

Swisscom AG

Related Courses

Angular with Firebase and Firestore

 14 hours

Firebase is a web application development platform. Firestore is a NoSQL database for storing, syncing, and querying data at scale. Users can use Firebase and Firestore while leveraging serverless architecture to build Angular applications. This

Firebase Fundamentals

 14 hours

This instructor-led, live training (online or onsite) is aimed at developers who wish to use Firebase to build powerful data-driven mobile or web application.  By the end of this training, participants will be able to: Understand the

Serverless Cloud Based Mobile and Web Development with Firebase

 28 hours

This instructor-led, live training (online or onsite) is aimed at mobile and web developers who wish to use Firebase to build serverless cloud based Android, iOS or web applications. By the end of this training, participants will be able

ClickHouse Fundamentals

 14 hours

ClickHouse is an open-source columnar database management system (DBMS) for online analytical processing (OLAP). This instructor-led, live training (online or onsite) is aimed at developers and IT professionals who wish to set up, manage, and use

Data Vault: Building a Scalable Data Warehouse

 28 hours

Data Vault Modeling is a database modeling technique that provides long-term historical storage of data that originates from multiple sources. A data vault stores a single version of the facts, or "all the data, all the time". Its

Change Data Capture (CDC) with Debezium

 14 hours

Debezium is an open source distributed platform for capturing database changes. Debezium operates as a connector service between a database and applications that wish to process changes to the database. This instructor-led, live training (online

Hasura GraphQL Engine

 14 hours

Hasura GraphQL Engine is an open source product built for fast, secure, and scalable data access. It provides real-time GraphQL queries across data sources and efficient data transformations with Postgres. This instructor-led, live training

Distributed Data Processing and Storage with Hazelcast

 14 hours

Hazelcast is an open source in-memory data grid platform for distributed computing and data storage. It provides a scalable cluster for efficient workload handling and integration with data sources and cloud technologies.     This

Mastering LINQ with C#

 14 hours

C# is a multi-paradigm programming language encompassing object-oriented and component-oriented disciplines. LINQ (language integrated query) is a component that adds native data querying capabilities to programming languages. This

Migrating Oracle to Azure SQL or PostgreSQL

 7 hours

On-premise, Oracle database management systems can be costly and difficult to maintain for mid and large-scale organizations. Migrating Oracle databases to Azure SQL (also known as Microsoft Azure SQL Database, Microsoft Azure SQL or AzureSQL) or

MongoDB Atlas Fundamentals

 14 hours

MongoDB Atlas is a multi-cloud database-as-a-service (DBaaS) platform. It simplifies the setup, operation, and management of MongoDB deployments in the cloud. This instructor-led, live training (online or onsite) is aimed at developers and

Presto for Data Science

 14 hours

Presto is a distributed query engine for big data analytics. Using Presto, users can natively query data, access data from multiple systems, and more. This instructor-led, live training (online or onsite) is aimed at data scientists who wish

Monitoring Kubernetes with Prometheus

 7 hours

This instructor-led, live training (online or onsite) is aimed at system administrators and developers who wish to use Prometheus to monitor Kubernetes clusters. By the end of this training, participants will be able to: Install and

Prometheus Fundamentals

 14 hours

Prometheus is an open source time series database for systems monitoring and alerting. It is decoupled from a larger infrastructure, making it a reliable tool to diagnose problems immediately during an outage. This instructor-led, live training

SQLite Fundamentals

 14 hours

SQLite is an open source serverless database for embedded applications that requires no configuration or administration. It is lightweight, efficient, and reliable, making it suitable for embedded devices and IoT. This instructor-led, live