Equnix Business Solution | an Open Source and Open Mind Company

Training PostgreSQL Basic and Advance

Basic PostgreSQL Class Schedule

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

* 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.

BasicPlus PostgreSQL Class Schedule

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

* 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.