
Online or onsite, instructor-led live PostgreSQL (AKA Postgres) training courses demonstrate through interactive discussion and hands-on practice the fundamentals of PostgreSQL and how to handle the administration and performance tuning of PostgreSQL databases.
PostgreSQL training is available as "online live training" or "onsite live training". Online live training (aka "remote live training") is carried out by way of an interactive, remote desktop. Onsite live PostgreSQL training can be carried out locally on customer premises in Kazakhstan or in NobleProg corporate training centers in Kazakhstan.
NobleProg -- Your Local Training Provider
Testimonials
Trainer had practical expierience and it showed
Alicja Kotewicz, summ-it s.a.
Course: PostgreSQL Administration and Development
pomoc w zadaniach oraz łatwy sposób komunikacji
Alicja Kotewicz, summ-it s.a.
Course: PostgreSQL Administration and Development
1. Notes on the whiteboard 2. Labs were executed in a sharing mode
Evangelos Katsaros
Course: PostgreSQL Administration and Development
The instructor explained everything we asked, he was very accurate, and he kept my interested.
Katerina Andreopoulou
Course: PostgreSQL Administration and Development
interaction was encouraged,Very useful practical approaches.
Farhan - Molly Brooks, Fast Lane Consulting and Education Services Limited
Course: PostgreSQL for Administrators - 2 Days
Lot's of excersises
Sebastian Kotulski, Santander
Course: PostgreSQL for Administrators - 2 Days
I liked the trainer Michal a lot - he had a good clear voice - which made it easier to understand the complicated subject matter.
Services Australia
Course: PostgreSQL for Developers
The thing I liked most was the audience engagement, getting the participants to work through the examples whilst everyone else follows along.
Services Australia
Course: PostgreSQL for Developers
Learning new things that I didn't know before
Nicholas Johnson - Services Australia
Course: PostgreSQL for Developers
Michal was really helpful when people had problems and no one was left behind in the exercises.
Elvin Kennedy - Services Australia
Course: PostgreSQL for Developers
Learning new topics
Services Australia
Course: PostgreSQL for Developers
There was no one thing that stood out, it was all pretty good. The occasional non-English word appearing in the slides - I assume that the original was in Polish - I found amusing.
Services Australia
Course: PostgreSQL for Developers
Training was well paced, engaging, and informative.
Matthew Sohar - Services Australia
Course: PostgreSQL for Developers
Optimizing queries and foreign data wrapping.
Sebastian Khor - Services Australia
Course: PostgreSQL for Developers
Well organized lectures and pacing was good.
Synetek Systems Pty Ltd
Course: PostgreSQL for Developers
The pace was excellent. It seemed custom made for me ... loved it!
Varnie Karmo - Indiana Legislative Services Agency
Course: PostgreSQL for Developers
The virtual desktop where we can try the hands-on activities on our end. The laboratories provided in each topic and also the Kahoot game for ice breaker.
Rowena Flora, G-Xchange, Inc
Course: PostgreSQL Administration, Optimization and Replication
Kahoot games to confirm the knowledge.
Rowena Flora, G-Xchange, Inc
Course: PostgreSQL Administration, Optimization and Replication
Jasny sposób przekazywania wiedzy przez prowadzącego
Robert Tragier, Asseco Poland S.A
Course: PostgreSQL Administration, Optimization and Replication
Wszystkie zagadnienia były niezwykle interesujące, podobały mi się szczególnie ćwiczenia praktyczne. Usystematyzowały moją wiedzę.
Kamila - Robert Tragier, Asseco Poland S.A
Course: PostgreSQL Administration, Optimization and Replication
Wiedza prowadzącego szkolenie i jego gotowość do dzielenia się nią.
Robert Tragier, Asseco Poland S.A
Course: PostgreSQL Administration, Optimization and Replication
Prowadzący pokazywał przydatne praktyczne rozwiązania, do nich działające ćwiczenia . Ogrom wiedzy na szkoleniu. Doceniam cierpliwość prowadzącego.
Robert Tragier, Asseco Poland S.A
Course: PostgreSQL Administration, Optimization and Replication
Really flexible with topics and amount of work in each area to fit with our knowledge.
Andy Kerslake - HM Land Registry
Course: PostgreSQL Essentials
Lots of hands on exercises and real life examples
Sam Inglis - HM Land Registry
Course: PostgreSQL Essentials
Michal was a very good trainer. On the course I attended we all had different levels of experience with PostgreSQL, but he managed to teach at the right level that meant those with less experience could keep up and did not make it dull or useless for those with more experience.
HM Land Registry
Course: PostgreSQL Essentials
Mix of classroom style tuition and hands-on practical exercises
HM Land Registry
Course: PostgreSQL Essentials
Trainer was very helpful and style of doing exercises together was great
Mark Wyatt - Services Australia
Course: PostgreSQL Essentials
I liked Michal's approach to ensuring that everyone was involved on exercises. Obviouslyi this would present challenges given the remote training scenario, but I think he did this in a far more effective manner than other trainers I've had recently on other courses.
Services Australia
Course: PostgreSQL Essentials
The trainer scribbling on the pages to provide extra illustration, making the learning easier. It is unusual but effective.
Services Australia
Course: PostgreSQL Essentials
The hands on practical parts of the training were engaging, I tended to lose a little interest if there was too much talking.
Bob Burt - Services Australia
Course: PostgreSQL Essentials
I liked that we got hands on experience with exercises in the Virtual Desktop, rather than just purely listening to a presentation. The trainer was great - very understanding and helpful when one of us was lost.
Cruise Speck - Services Australia
Course: PostgreSQL Essentials
the pace and the knowledge of the trainer.
Ashneet Maharaj, Auckland Council
Course: PostgreSQL Advanced DBA
interactive (participation) and checking with audience on what to cover the entire time
Ashneet Maharaj, Auckland Council
Course: PostgreSQL Advanced DBA
The way it was presented Getting "under the hood" information on Postgres. The topics on vacuum, backups and replication were very useful.
Greg Albrecht - Ashneet Maharaj, Auckland Council
Course: PostgreSQL Advanced DBA
The trainer has a very good knowledge and was able to transmit this to the trainees.
Sopra Steria
Course: PostgreSQL Advanced DBA
The trainer was very knowledgeable in the subject, answered every question and kept the engagement of the participants. Some topics were explained in great depth, which I found really good.
Sopra Steria
Course: PostgreSQL Advanced DBA
Michal was very knowledgable and engaging as a teacher.
Nate Clifton - NIIT (USA) Inc.
Course: PostgreSQL Advanced DBA
Michal is a knowledgeable and experienced trainer. It's good to have trainers who have industry experience. I also liked the hands-on exercises with remote VMs.
NIIT (USA) Inc.
Course: PostgreSQL Advanced DBA
Really well organised and managed by Michal.
Services Australia
Course: PostgreSQL Performance Tuning
Course focus on more coding than theory.
Services Australia
Course: PostgreSQL Performance Tuning
It was clearly tailored to be very appropriate to our purpose which made it extra helpful. I really liked the zoom format as it helped me focus with the material right in front of you all the time and the trainer able to add illustrations and markings on to it as he explained. The trainer answered all our questions in a very satisfying way and I felt surprised at how much I was able to learn in one day. Usually i get tired of training by the afternoon but this was very engaging right through to the end. Pace was perfect and detail went into the right areas.
Davina Sanders - Scottish Government
Course: PostgreSQL Performance Tuning
PostgreSQL Course Outlines in Kazakhstan
- Use advanced administration techniques to configure and manage a PostgreSQL server.
- Optimize the database and queries for maximum performance.
- Replicate and scale a PostgreSQL server.
You will also learn how to find slow queries, monitor database performance and tune PostgreSQL for Performance.
- Install and configure PostgreSQL 13.
- Understand the features, architecture, and fundamentals of operating, managing, and maintaining databases with PostgreSQL 13.
- Learn how to configure Postgres database tables and schemas.
- Learn how to perform data manipulations and queries.
- Explore the different programming interfaces (client and server) to fully utilize and extend functionalities in PostgreSQL 13.
- Install and configure PostgreSQL.
- Understand the features and architecture of PostgreSQL.
- Learn how to perform database operations with SQL.
- Perform database backup and recovery to prevent data loss.
- Configure the server for high availability.
- Learn the tools and techniques for high performance tuning.
- Explore the external tools for monitoring and observability.
- Install, configure, and connect PostgreSQL with Python.
- Get a refresher on Python programming fundamentals.
- Understand the benefits of using PostgreSQL with Python.
- Learn how to perform basic SQL operations with Python.
- Learn how to use the advanced PostgreSQL features with Python.
- Implement data safety, security, monitoring, and optimization techniques.
- Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
- Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
- Perform post-migration steps to test, optimize, update, and maintain a migrated database.
Last Updated: