Training PostgreSQL Basic and Advance

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:

  • In house Basic PostgreSQL: Covering basic knowledge on SQL and general RDBMS.
  • In house Advanced PostgreSQL: Covering detailed knowledge about PostgreSQL foundations and Performance Experience for Developer or General Database Administrator.

Our training is backed with Professional Certification.

Training PostgreSQL Basic and Advance



Basic PostgreSQL Class Schedule


Day Session Topic Duration Description
1 1 Online Pre-Test 1 hour Pre-Training Online Test
2 Introduction to RDBMS 4 hours ACID Concept; OLTP and OLAP Concept;
3 PostgreSQL Basic Administration 3 hours How to manage PostgreSQL Instance (control scripts); Data directory Structure; Simple binary PostgreSQL install; Physical access of PostgreSQL;
2 1 Objects & Query 2 hours Keywords on PostgreSQL; DDL; DML; Database structures on PostgreSQL; Data Types Explained; ACL
2 Advance SQL Languages 2 hours Advanced SQL like; Subqueries, WITH, UPSERT, Complex Join, object, Indexes, View, etc
3 Accessibility & Security 2 hours Users; Using psql; Host-based Authentication Configuration; PostgreSQL Server-side Configuration (parameters); Using Client Libraries PHP, JAVA, etc;
4 Monitoring 2 hours pgAdmin 4; Monitoring Views; PostgreSQL System Catalogs;
3 1 Backup & Restore 4 hours Cold Backup; Hot Backup; Backup tools;
2 Replication Concept and Implementation 4 hours Synchronous Replication; Asynchronous Replication; Cascading Replication;
3 Post Test 1 hour After 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.


Basic Plus PostgreSQL Class Schedule


Day Session Topic Duration Description
1 1 Introduction to Linux OS 4 hours OS Linux Concept; What is Shell; Root Management; What is Kernel and what are the parameters; Software Packages
2 Linux Installation (Hands-On) 2 hours Debian Installation, What is SHELL, How to do disk partitioning, Basic File System, Linux Directory Layout, How to manage Software Packages
3 File/Device Management (Hands-On) 2 hours Tools to list and managed files and directories, How to check partition layout, size, and free size
2 1 Process Manager (Hands-On) 3 hours How to monitor processes, How to start and stop application/instance
2 Network Management (Hands-On) 3 hours What is network interface in Linux, How to monitor and manage network interfaces, IP, and connections, Secure Connections
3 Access List in Linux (Hands-On) 2 hours How to manage access list and ownership in Linux
3 1 PreTest 1 hour Before Training Test
2 Introduction to RDBMS and SQL 3 hours Database Query Concept; ACID Concept; OLTP and OLAP Concept;
3 Basic PostgreSQL Administration (Hands-On) 2 hours How to control PostgreSQL instance; Users; Using psql;
4 Simple Objects & Query 2 hours Keywords on PostgreSQL; DDL; DML; Database structures on PostgreSQL; Data Types Explained
4 1 Monitoring and Simple Management (Hands-On) 2 hours pgAdmin 4; Monitoring Views; PostgreSQL System Catalogs; Where and How to Read Logs
2 Basic Accessibility & Security (Hands-On) 4 hours Host-based Authentication Configuration; PostgreSQL Server-side Configuration (parameters); Using Client Libraries PHP, JAVA, etc;
3 SQL Query for Transaction and Reporting 2 hours What is query difference between OLTP and OLAP Concept, How to execute the queries Hands-On
5 1 Simple Backup & Restore 3 hours Backup Tools Explained
2 Replication Concept and Implementation 4 hours Synchronous Replication; Asynchronous Replication; Cascading Replication;
3 Post Test 1 hour After 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.


Advance PostgreSQL Class Schedule


Day Session Topic Duration Description
1 1 PreTest 1 hour Before Training Test
2 ORDBMS Concept in General 2 hours ACID Concept;OLTP and OLAP Concept; Benchmarking Result Oracle vs PostgreSQL;
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.


Training Registration Form






PostgreSQL Training Terms & Condition

  1. Participant agreed to follow the deliverance of PostgreSQL training at all of the training process.
  2. Participant is to be expected in Equnix training centre area before the training time.
  3. Inform the training committee whenever participant will come late or not present.
  4. Participant prepare their own laptop with Linux Operating System or Virtual Box ready in all of the training sessions.
  5. Training Delivery Cycle :
    1. Registration (fill the registration form, sign and deliver to Equnix)
    2. Re-registration on arrival
    3. Pre Training Test
    4. Training Session
    5. Post Training Test
  6. In term of any specific request for the training, participant should mention the request maximum in 3 days before the first day of the training schedule.
  7. Participant is to be expected not to disturb other participant during the training time.
  8. Participant who are absent during the training session will not get any leaved day remedial and will have to follow the rest of the training.
  9. Participant who are absent more than 2 days (in the Basic Training) and 3 days (in the advance training) will not receiving the training participation certificate.
  10. If in any condition participant who have registered and paid for the training is unable to join any of the training days, then the participant will need to send the request letter to postponed to the next training schedule 5 days before the selected training schedules starts.
  11. Any participant without proper request letter and information who failed to attend any or all of the training days will get no replacement schedule, if the participant still interested in the training he/she needs to re-enroll and pay a full payment for the next training schedule.