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
- PostgreSQL vs MySQL vs Oracle
- Overview of PostgreSQL 13 features and architecture
Getting Started
- Setting up a database server
- Installing PostgreSQL 13
- Creating and accessing a database
- SQL syntax, commands, and functions
Configuring a Postgres Database
- Data definition, default values, and constraints
- Setting up and modifying tables
- Managing privileges and security policies
- Creating database schemas
- Implementing table inheritance and partitioning
- Adding, updating, and querying data
- Data types, functions, and operators
- Using indexes and running full-text search
- Understanding concurrency control
Managing a Database Server
- Upgrading a PostgreSQL cluster
- Securing the server and encrypting data
- Configuring server parameters
- Enabling client authentication
- Setting up access roles and permissions
- Managing multiple databases
- Performing database maintenance tasks
- Backing up and restoring data
- Optimizing database performance and reliability
- Monitoring database activity and disk usage
- Implementing logical replication
- Running regression tests
Client-Side Programming
- Using the libpq C library and large object interface
- Executing embedded SQL statements
- Exploring the information schema
- Other PostgreSQL client applications
Server-Side Programming
- Extending the SQL query language
- Writing event trigger functions
- Implementing rule systems
- Using procedural languages (PLs)
- Exploring TCL, Perl, and Python PLs
- Executing server programming interfaces
- Examples of logical decoding
- Tracking replication progress
Troubleshooting
Summary and Next Steps
Requirements
- An understanding of RDBMS
- Experience with SQL
Audience
- System administrators
- Developers
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