PostgreSQL Professional
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.
Audience
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.
Available Languages
This course can be held in English, German, Spanish, Estonian, Polish, Ukrainian and Russian.
Content
Day 1
- Installation
- 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
Day 2
- Physical Backup: Low-level API
- Autovacuum: advanced tuning
- Streaming replication
- Synchron replication
- Hot Standby and conflict management
- Failover
- High Availability, Patroni
- Logical replication
Day 3
- Partitioning
- Parallel queries
- Foreign Data Wrapper
- Functions
- Statement tuning: finding slow statements
- EXPLAIN (ANALYZE, BUFFERS)
- Extended Statistics
Contact us to sign up for this course >>
Other courses that might interest you
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 Infrastructure
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.