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
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 hoursFirebase 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 hoursThis 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 hoursThis 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 hoursClickHouse 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 hoursData 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 hoursDebezium 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 hoursHasura 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 hoursHazelcast 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 hoursC# 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 hoursOn-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 hoursMongoDB 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 hoursPresto 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 hoursThis 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 hoursPrometheus 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 hoursSQLite 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