Dates & Duration
See available dates for this course!
If there is no date and time available for a certain training you are interested in, please contact us.
This training can also be held at your place or as online training especially for your company. In this case the course agenda can also be adapted to suit your needs best.Learn more about our customized training >>
This course takes 3 days with 8 hours each (on site) or 5 hours each (online).
The only difference is that there will be less practical exercises in an online course. However, we will hand them over to you and you can still do them on your own and ask our consultants for feedback or help if needed.
This course provides a deep insight into advanced PostgreSQL topics like indexing, storage parameters, optimization, replication, monitoring, etc. It covers the technical foundations required for replication, scaling, point-in-time recovery, and the successful operation of synchronous and asynchronous replication solutions. Moreover, details of processing that are essential for optimization and performance tuning are highlighted, so that you can get the most out of your system and queries.
This course can be held in English, German, Spanish, Estonian, Polish, Ukrainian and Russian.
- Advanced psql
- Advanced indexing: Multi column indexes, GIN indexes, GiST indexes
- full text serach
- Exclusion Constraints
- Range data types
- Arrays and JSON in the database
- Transactions: isolation levels, serialization
- Prepared transactions, two-phase commit
- Physical Backup: Low-level API
- Autovacuum: advanced tuning
- Streaming replication
- Synchron replication
- Hot Standby and conflict management Konfliktmanagement
- High Availability, Patroni
- Logical replication
- Parallel queries
- Foreign Data Wrapper
- Statement tuning: finding slow statements
- EXPLAIN (ANALYZE, BUFFERS)
- Extended Statistics
Contact us to sign up for this course >>
Other courses that might interest you
GIS ESSENTIALS – „GETTING SPATIALLY ENABLED“
PostgreSQL High Availability & Patroni Cluster Manager
PostgreSQL in Kubernetes
Machine Learning for decision makers
Introduction to Machine Learning
Introduction to PostGIS
PostgreSQL Administration and Performance Tuning
Introduction to SQL
PostgreSQL for business intelligence and mass data analysis
We offer these services
Are you looking for ways to further develop your database or do you need support in implementing projects? Our experts will be happy to help you define the scope of work as part of an initial requirement analysis and will be on hand to advise you. Our PostgreSQL experts will take a close look at […]
POSTGRESQL TROUBLESHOOTING Are you fighting with corrupted database systems? Is your PostgreSQL database throwing strange error messages or do you have the feeling that something is not quite right? Is your database suddenly suffering from performance problems or are you facing problems with your replication setup? Our troubleshooting team is here to help. It’s not […]
PostgreSQL Health Check
The Health Check identifies errors and problems that may occur in your PostgreSQL database in terms of performance, high availability and security.