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
- Overview of PostgreSQL features and architecture
- Basics of database administration
Getting Started
- Installing PostgreSQL
- Configuring a pgAdmin 4 client
- Creating a database user
- Creating a database
Database Operations
- SQL syntax, functions, and operators
- Data definition and data types
- User-defined data types
- Table schemas
- Creating and modifying tables
- Manipulating data in tables
- Querying and filtering data
- Exploring constraints
- Conversion functions
- Joining multiple tables
- Combining queries
- Indexes and full-text search
- Concurrency control
- Regular expressions
Database Server Administration
- Security and encryption
- Access roles and permissions
- Backup and restore
- Upgrading PostgreSQL
- High availability
- Load balancing and replication
- Statistics and monitoring
High Performance Tuning
- Resource management
- Monitoring query performance
- Parameter tuning
- Index optimization
- Query optimization
- Scalability and partitioning
External Tools for Monitoring and Observability
- pgAdmin
- pgBadger
- pgbench
- node-exporter Prometheus, Grafana
- Zabbix
Troubleshooting
Summary and Next Steps
Requirements
- Basic knowledge in database administration
- Familiarity with SQL language
Audience
- Database administrators
- System administrators
Testimonials
Trainer had practical expierience and it showed
Alicja Kotewicz, summ-it s.a.
pomoc w zadaniach oraz łatwy sposób komunikacji
Alicja Kotewicz, summ-it s.a.
1. Notes on the whiteboard 2. Labs were executed in a sharing mode
Evangelos Katsaros
The instructor explained everything we asked, he was very accurate, and he kept my interested.
Katerina Andreopoulou
interaction was encouraged,Very useful practical approaches.
Farhan - Molly Brooks, Fast Lane Consulting and Education Services Limited
Lot's of excersises
Sebastian Kotulski, Santander
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
The thing I liked most was the audience engagement, getting the participants to work through the examples whilst everyone else follows along.
Services Australia
Learning new things that I didn't know before
Nicholas Johnson - Services Australia
Michal was really helpful when people had problems and no one was left behind in the exercises.
Elvin Kennedy - Services Australia
Learning new topics
Services Australia
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
Training was well paced, engaging, and informative.
Matthew Sohar - Services Australia
Optimizing queries and foreign data wrapping.
Sebastian Khor - Services Australia
Well organized lectures and pacing was good.
Synetek Systems Pty Ltd
The pace was excellent. It seemed custom made for me ... loved it!
Varnie Karmo - Indiana Legislative Services Agency
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
Kahoot games to confirm the knowledge.
Rowena Flora, G-Xchange, Inc
Jasny sposób przekazywania wiedzy przez prowadzącego
Robert Tragier, Asseco Poland S.A
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
Wiedza prowadzącego szkolenie i jego gotowość do dzielenia się nią.
- Robert Tragier, Asseco Poland S.A
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
Really flexible with topics and amount of work in each area to fit with our knowledge.
Andy Kerslake - HM Land Registry
Lots of hands on exercises and real life examples
Sam Inglis - HM Land Registry
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
Mix of classroom style tuition and hands-on practical exercises
HM Land Registry
Trainer was very helpful and style of doing exercises together was great
Mark Wyatt - Services Australia
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
The trainer scribbling on the pages to provide extra illustration, making the learning easier. It is unusual but effective.
Services Australia
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
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
the pace and the knowledge of the trainer.
Ashneet Maharaj, Auckland Council
interactive (participation) and checking with audience on what to cover the entire time
Ashneet Maharaj, Auckland Council
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
The trainer has a very good knowledge and was able to transmit this to the trainees.
Sopra Steria
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
Michal was very knowledgable and engaging as a teacher.
Nate Clifton - NIIT (USA) Inc.
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.
Really well organised and managed by Michal.
Services Australia
Course focus on more coding than theory.
Services Australia
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
Related Courses
PostgreSQL for Developers
14 hours
PostgreSQL Essentials
14 hours
PostgreSQL Advanced DBA
14 hours
PostgreSQL Performance Tuning
14 hours
PostgreSQL with Python
21 hours
Data Management
35 hours
SAP ASE for Database Administrators
28 hours
Pivotal Greenplum for Developers
21 hours
MarkLogic Server
14 hours