
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 the UK or in NobleProg corporate training centres in the UK.
NobleProg -- Your Local Training Provider
Testimonials
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
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
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 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
Optimizing queries and foreign data wrapping.
Sebastian Khor - Services Australia
Course: PostgreSQL for Developers
Well organised 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
PostgreSQL Course Outlines
- 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: