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 course takes 3 days – 8 hours per day (on site) or 5 hours per day (online).
The only difference is that there will be less practical exercises in an online course. However, we can share them with you so you can do them on your own. You can 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 search
- 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
- 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
SQL BasicsMore about this course
Migration TutorialMore about this course
PostgreSQL High Availability & Patroni Cluster ManagerMore about this course
PostgreSQL in KubernetesMore about this course
Machine Learning for decision makersMore about this course
Introduction to Machine LearningMore about this course
Introduction to PostGISMore about this course
PostgreSQL Administration and Performance TuningMore about this course
Introduction to PostgreSQLMore about this course
PostgreSQL for business intelligence and big data analysisMore about this course
We offer these services
PostgreSQL Optimization & Security
Is your database not running smoothly or are you struggling with security issues? Our experts will analyze problems & optimization potentials within a health check or security audit.
PostgreSQL Setup & Installation, automation with Kubernetes and database architecture: We’ll find the optimal setup and make sure that your PostgreSQL Infrastructure meets your needs and expectations.
PostgreSQL Setup & Installation
Get started with PostgreSQL by using our Setup & Installation service. We fully focus on your personal needs and infrastructure. In addition to the configuration itself, you also benefit from the knowledge of our experts in the field of database design.