Training PostgreSQL Basic and Advance

Basic PostgreSQL Class Schedule

Day Session Topic Duration Description
1 1 PreTest 1 hour Before Training Test
2 Introduction to RDBMS 4 hours ACID Concept; OLTP and OLAP Concept; Benchmarking Result Oracle vs PostgreSQL;
3 Concept and Architecture 1 hour Core Architecture (Shared Memory, WAL Buffer, Commit Log, etc); Journalling Concept;
4 Administration 2 hours How to manage PostgreSQL Instance (control scripts); Data directory Structure; Simple binary PostgreSQL install; Physical access of PostgreSQL;
2 5 Objects & Query 2 hours Keywords on PostgreSQL; DDL; DML; Database structures on PostgreSQL; Data Types Explained; ACL
6 Advance SQL Languages 2 hours Advanced SQL like; Subqueries, WITH, UPSERT, Complex Join, object, Indexes, View, etc
7 Accessibility & Security 2 hours Users; Using psql; Host-based Authentication Configuration; PostgreSQL Server-side Configuration (parameters); Using Client Libraries PHP, JAVA, etc;
8 Monitoring 2 hours pgAdmin 4; Monitoring Views; PostgreSQL System Catalogs;
3 9 Backup & Restore 3 hours Cold Backup; Hot Backup; Backup tools;
10 Replication Concept and Implementation 3 hours Synchronous Replication; Asynchronous Replication; Cascading Replication;
11 Free Topic 1 hour Free Discussion;
12 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 ORDBMS Concept in General 2 hours ACID Concept;OLTP and OLAP Concept; Benchmarking Result Oracle vs PostgreSQL;
2 Architecture 2 hours Core Architecture (Shared Memory, WAL Buffer, Commit Log, etc.); Journaling Concept; Replication Concept; HA Concept; Archiving Concept;
3 Installation & Administration 4 hours Compilation concept on Linux; How to install PostgreSQL from Source Code;Source Code structure of PostgreSQL; How to initialize data directory; How to manage PostgreSQL Instance (control scripts); Data directory Structure;
2 4 Monitoring 2 hours Pgadmin 4; Monitoring Views; PostgreSQL System Catalogs (stats); Art of Logging; How to analyze slow queries (Introduction);
5 Administration & Advance Security 2 hours Using psql; Host-based Authentication Configuration; PostgreSQL Server-side Configuration (parameters);Plugins Installation;
6 Syntaxes, Query, & Data Types 4 hours Keywords on PostgreSQL; Database structures on PostgreSQL; Data Types Explained; Stored Procedure, Trigger, View, Sequence Explained;
3 7 Multitier Backup & Restore 2 hours Cold Backup; Hot Backup; Incremental Backup; Point in Time Recovery; Backup tools;
8 Replication 2 hours Synchronous Replication; Asynchronous Replication; Cascading Replication; Multi-slave Replication; Logical Decoding Explained;
9 High Availability Implementation 4 hours Linux-HA Concept & Hands-on; Failover & Recovery Mechanism; Combining Replication & Linux-HA on HA Implementation;
4 10 Partition & Tablespace 2 hours How to configure Tablespace; How to configure Partition; Best practices on Performance Tuning using Tablespace & Partition;
11 Load-balancing 4 hours Bi-directional Replication Explained; Data sharding Concept; FDW for Loadbalancing, pg_shard, PostgresXL;
12 Benchmarking & Server-side Tuning 2 hours How to tune Server-side Configuration; Best Practices on High Performance System; pgBench Tools Explained; Hand-on tuning & benchmarking;
5 13 Exotic Features 2 hours JSONB; FDW; UPSERT Query; Row Level Security; Paralel Worker;
14 Special Topic 4 hours SQL Query Tuning; Art of Indexing; pg_upgrade;
15 Free Discussion & Test 2 hours Free Discussion;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.