PostgreSQL Training for those who’s eager to learn more about the World’s Most Advanced ORDBMS. Our Training improves your knowledge on PostgreSQL, both on fundamentals and Advanced levels. It’s taught by our experienced experts and best practitioners in PostgreSQL.
We provide 2 level of training:
Our training is backed with Professional Certification.
|1||1||PreTest||1 hour||Before Training Test|
|2||ORDBMS Concept in General||2 hours||ACID Concept; OLTP and OLAP Concept;|
|3||Architecture||2 hours||Core Architecture (Shared Memory, WAL Buffer, Commit Log, etc.); Journaling Concept; Replication Concept; HA Concept; Archiving Concept;|
|4||Hardware/OS Optimization Concept||1 hour||Managing kernel related parameters; Managing CPU scheduling parameters; Managing Storage level parameters;|
|5||Server-side Optimization Concept||2 hours||How to tune Server-side Configuration (shared_buffer, commit_delay, bgwriter_delay, fsync commit, synchronous commit, etc.);Data Partitioning (Tablespace, FDW);Capacity Planning;Page size, data type usage, TOAST;How server manages indexes;|
|2||1||Client-side Optimization Concept||1 hour||Design Database Structure; Multi-level Caching (disk, kernel, shared mem, heap, CPU data cache); Implementing and monitoring index usage (concurrently, effectively, and forcing usage); EXPLAINing Query Plan;|
|2||Installation & Administration||2 hours||Using psql; Host-based Authentication Configuration; PostgreSQL Server-side Configuration (parameters); Plugins Installation;|
|3||Monitoring (Hands-on)||3 hours||Monitoring Views (active sessions, blocked query, deadlock, table statistics, index statistics, planner statistics, pgstattuple); PostgreSQL System Catalogs (stats);Log Management (prefix, retaining);How to analyze slow queries;Identifying checkpoint overhead;|
|4||Data & Access Security (Hands-on)||2 hours||Host-based Authentication Configuration; User Roles Privileges;passwordcheck;Integrating with LDAP; Enabling SSL; pg_crypto for encryption;|
|3||1||Benchmarking & Server-side Tuning||2 hours||Hardware Benchmarking (I/O Test, Seek Rate Test); Best Practices on High Performance System; pgBench Tools Explained; Hands-on tuning & benchmarking; Identifying and optimizing resource usage/bottleneck;|
|2||Multitier Backup & Restore (Hands-on)||4 hours||Cold Backup; Hot Backup; Incremental Backup; Point in Time Recovery; Backup tools;|
|3||Connection Management (Hands-on)||2 hours||Implement and manage pgBouncer; Maintaining connection failover using libpq;|
|4||1||Partition & Tablespace (Hands-on)||2 hours||How to configure Tablespace; How to configure Partition; Best practices on Performance Tuning using Tablespace & Partition;|
|2||Replication (Hands-on)||2 hours||Synchronous Replication; Asynchronous Replication; Cascading Replication; Multi-slave Replication; Logical Replication Explained;Late Replication;|
|3||High Availability Implementation (Hands-on)||4 hours||HA Concept & Hands-on; Failover & Recovery Mechanism; Combining Replication & Pacemaker on HA Implementation;|
|5||1||Exotic Features||2 hours||JSONB; FDW; UPSERT Query; Row Level Security; Paralel Worker;|
|2||VACUUM Management (Hands-on)||2 hours||Dealing with bloated tables and index using xmin & xmax; Implement and manage VACUUM and AUTOVACUUM;Freezing & Transaction ID wraparound;|
|3||Special Topic/Free Discussion||3 hours||SQL Query Tuning; Art of Indexing; pg_upgrade;|
|4||Post-Training Test||1 hours||Post-training Test;|
* Training locations, material and times are subject to change based on availability of facilities or other unforeseen circumstances. Please confirm back one week prior to the training to verify specific details.