Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member 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
Testimonials
Training Room and quite location and all the stuff.
Abdullah Adelyar - USAID - Kabul Afghanistan
The own working, it helps a lot I think.
Krisztina BALOGH, Diehl
The trainer let us ask regarding our issues with our current projects. He explained really well what kind of approach we should choose.
Krisztina BALOGH, Diehl
perfect level of knowledge transfair
Pascal - Krisztina BALOGH, Diehl
I learned a lot of new things which will be useful for my tasks.
Zsolt - Krisztina BALOGH, Diehl
The trainings by our self
Andreas - Krisztina BALOGH, Diehl
I liked that all the neccessary topics have been explored.
Krisztina BALOGH, Diehl
Our group was not that big so every time we asked a question we received an extensive answer with examples. So everything was well explained and it can be noticed that trainer has a great knowledge.
Iwona - Iwona Domagała, Universal-Investment-Gesellschaft mit beschränkter Haftung
complex introduction to queries, relationships. Useful tips in term of further using of Access as well as Access connection with different tools
Iwona Domagała, Universal-Investment-Gesellschaft mit beschränkter Haftung
Trainer has very broad knowledge, not only related to access. Impressive :)
Iwona Domagała, Universal-Investment-Gesellschaft mit beschränkter Haftung
starting from scratch and go further and further.
Iwona Domagała, Universal-Investment-Gesellschaft mit beschränkter Haftung
Kamil 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
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
examples and the way he explained
Sandeep Parashar
I like very much the course
Miguel Angel Miranda Hernandez - Gabriela Fernandez Olvera, ENGINEERING AND SERVICES JF S.A. DE C.V.
El curso es muy completo, el instructor tiene muy buen domino del tema, felicidades, todo muy bueno.
Christian - Gabriela Fernandez Olvera, ENGINEERING AND SERVICES JF S.A. DE C.V.
Replica Set
RICARDO VILLEGAS MARTINEZ - Gabriela Fernandez Olvera, ENGINEERING AND SERVICES JF S.A. DE C.V.
la maquina vistual que se utilizo ahorra mucho tiempo y en general el contenido del curso fue adecuado y preciso
Emmy - Gabriela Fernandez Olvera, ENGINEERING AND SERVICES JF S.A. DE C.V.
Que se compartieron los Link Complementarios al curso
Manuel De L Barra - Jorge Vera, Redbanc
I had the good fortune to have one-on-one training with Jose. He built rapport well, got straight into the coursework, answered my questions well, and stepped outside of the agenda to demonstrate things relevant to the questions I was asking. He also extended the practical exercises with some more complex ones.
Aaron - Hayley S, Attorney General's Department
la resolución de problemas y la flexibilidad de la tecnología
hiram chavez - LUIS FERNANDO GUERRERO, Datavision Digital S.A. de C.V.
I learned many new things and terms
José Ernesto Cruz Pineda - LUIS FERNANDO GUERRERO, Datavision Digital S.A. de C.V.
los temas que vimos fueron bien explicados.
Daniela Valdez, Banco de México
Los ejercicios para repasar teoría y que al inicio de cada sesión había un resumen que me permitía recordar lo visto.
Daniela Valdez, Banco de México
El contenido del curso
Daniela Valdez, Banco de México
Practical use cases showed on examples.
Adrian Czok, Hostersi sp. z o.o.
Good content, and very easy to understand and follow along with the trainer who was very pedagogic
Fredrik Andersson - Magnus Angermund, Högskolan i Gävle
The technical knowledge and the fact that he approach the NoSql technology and not only MongoDB perspective.
- Siemens S.A.
The deep dive in the technical topics.
Nuno Cruz - Siemens S.A.
The architecture concepts and the way that using a NoSQL should be approached
- Siemens S.A.
Trainers patience to listen and answer our questions which is highly appreciated.
Elango Muthu - TransCore
the trainer tried to listen to us and encouraged us to ask questions
- TransCore
LIttle to no breaks. At least time is not wasted on breaks.
- ST Electronics (Info-Software Systems) Pte Ltd
Kamil was excellent at explaining even the difficult topics in a way that I understood them straight away. The presentation and delivery were both clear and methodical, and the teacher passionate about the subject.
Mark Novak - Kiloo
It was very flexible and adapted to our expectations and skill level
Raúl Alberto Canales Requena - Kiloo
That we had a virtual environment to work on
epic ltd
The training platform and functionalities as well as the Kamil way of knowledge transfer
panayiotis kakouris - epic ltd
The lab environment
Samer Roshdi - epic ltd
He asked each individual about their thoughts and feedback. Very good knowledge of SQL.
Krisztina BALOGH, Diehl
Lot of content and exactly the requested one.
Pascal - Krisztina BALOGH, Diehl
The trainer had a high level of Expertise and could answer all upcoming questions
Krisztina BALOGH, Diehl
The effort it took for the trainer to prepare for the training
Krisztina BALOGH, Diehl
There were a lot of exercises really good exercises and the trainer passed on his knowledge well.
Zsolt - Krisztina BALOGH, Diehl
The excercises, because we do it together, and the trainer explained it.
Krisztina BALOGH, Diehl
Pace of training, explanations of tasks. Generally really good training.
Aneta Tunderska, EY GDS (CS) POLAND SP. Z O.O.
Trainer style and knowledge
Aneta Tunderska, EY GDS (CS) POLAND SP. Z O.O.
Communicative, big knowledge and well presented material
Filip Gotowicki - Aneta Tunderska, EY GDS (CS) POLAND SP. Z O.O.
We use BigQuery and the trainer decided we would use BigQuery instead to run all of the codes which was really really useful
- Spark44
Relevance to BigQuery.
- Spark44
Phil was great! He was both patient and knowledgeable. The training went at a good pace, moving a team of mixed SQL abilities through the basics into more advanced SQL querying together. The exercises were an excellent way for us to commit our newly learned skills to memory, and Phil's instructions/class discussions on numerous ways to achieve the same thing were interesting.
Sophie Clement - Thames Water Utilites Ltd
Related Courses
ClickHouse Fundamentals
14 hours
SQLite Fundamentals
14 hours
MongoDB Atlas Fundamentals
14 hours
Prometheus Fundamentals
14 hours
Presto for Data Science
14 hours
Mastering LINQ with C#
14 hours
Firebase Fundamentals
14 hours
Angular with Firebase and Firestore
14 hours