Scribd
Upload
9 views1 page

Advanced PostgreSQL Training Syllabus

The document outlines the syllabus for an Advanced PostgreSQL Training course scheduled for March 2-3 and 9-11, 2020. It includes various topics such as Linux OS introduction, RDBMS and SQL concepts, PostgreSQL installation and administration, backup and restore techniques, replication, high availability implementation, and performance tuning. The training also features practical sessions and discussions, with a pre-test and post-test to assess participants' understanding.

Uploaded by

jee.afnan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views1 page

Advanced PostgreSQL Training Syllabus

The document outlines the syllabus for an Advanced PostgreSQL Training course scheduled for March 2-3 and 9-11, 2020. It includes various topics such as Linux OS introduction, RDBMS and SQL concepts, PostgreSQL installation and administration, backup and restore techniques, replication, high availability implementation, and performance tuning. The training also features practical sessions and discussions, with a pre-test and post-test to assess participants' understanding.

Uploaded by

jee.afnan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Syllabus Advanced PostgreSQL Training

2 - 3, 9 - 11 Maret 2020

Day Session Topic Duration Description


1 PreTest 1 hour Before Training Test
OS Linux Concept; What is Shell; Root Management; What is Kernel and what are the parameters; Software Package
Debian Installation, What is SHELL, How to disk partitioning, Basic File System, Linux Directory Layout, How to manage
Software Packages
2 Introduction to Linux OS 4 hours Tools to list and managed files and directories, How to check partittion layout, size, and free size
1 How to Monitor processes, How to start and stop application/instance
What is network interface in Linux, How to monitor and manage network interface, IP, and connections, Secure Connections
How to manage access list and ownership in Linux
3 Introduction to RDBMS and SQL 1 hour Database Query Concept; ACID Concept; OLTP and OLAP Concept;
Core Architecture (Shared Memory, WAL Buffer, Commit Log, etc.); Journaling Concept; Replication Concept; HA Concept;
4 Architecture 2 hours
Archiving Concept;
Compilation concept on Linux; How to Install PostgreSQL from source code; Source Code structure of PostgreSQL; How to
1 Installation & Administration 2 hours
initialize data directory; How to manage PostgreSQL instance (control scripts); Data directory Structure;
2 Simple Objects & Query 2 hours Keywords on PostgreSQL; DDL; DML; Database structures on PostgreSQL; Data Types Explained
2 Using psql; Host-based Authentication Configuration; PostgreSQL Server-side Configuration (parameters); Plugins
Administration & Advanced Security
3 2 hours Installation;
Pgadmin 4; Monitoring Views; PostgreSQL System Catalogs (stats); Art of logging; How to analyze slow queries
4 Monitoring 2 hours (Introduction);
1 Multitier Backup & Restore 2 hours Cold Backup; Hot Backup; Incremental Backup; Point in Time Recovery; Backup tools;
2 Replication 2 hours Synchronous Replication; Asynchronous Replication; Cascading Replication; Multi-slave Replication; Logical Replication;
3
HA Concept and Hands-on; Fail-over & Recovery Mechanisme; Combining Replication & HA (Pacemaker) on HA
3 High Availability Implementation 4 hours
Implementation;
How to configure Tablespace; How to configure Partition; Best Practices on Performance Tuning using Tablespace &
1 Partition & Table Space 4 hours
Partition;
4
How to tune Server-side Configuration; Best Practices on High Performance System; pgBench Tools Explained; Hand-on
2 Benchmarking & Server-side Tuning 4 hours
tuning & benchmarking;

1 Database Maintenance Management 2 hours VACUUM Management, Autovacuum Tuning, Tips and Trick on doing maintenance for production system

5 2 Special Topic 4 hours Free Topic, can be requested upon the other session

3 Discussion and Post Test 2 hours Free session can be used for dicussing the other topics

You might also like