Pre-Conference Training
getting started with PostgreSQL 15
About Training
Date: May 9-10, 2025
Venue: Kathmandu University, Dhulikhel, Kathmandu
Training Lead: Egor Rogov
About Training Leads
The training is led by Egor Rogov, the author of “PostgreSQL Internals” book and co-author of “Postgres: The First Experience” booklet. Egor graduated from Computer Science Faculty of Lomonosov Moscow State University and has more than 15 years of Database Management Systems experience as an application developer and project manager. Since 2015 Egor works on educational programs in Postgres Professional company.
Pre-conference event is an introductory training course. It is aimed at novice DBAs (but also should be helpful for application developers to better understand what's going on at the database side).
Prerequisites for the course are basic understanding of SQL (nothing fancier than two-table joins) and some acquaintance with Linux (basic command like ls/cd/sudo).
The course covers basics of PostgreSQL architecture (things like MVCC, vacuum, buffer cache, WAL), installation and managing the server, using psql, data organization from both logical and physical points of view, and an overview of access control, backups, and replication.
For practical exercises students should use laptops with the course virtual machine installed. Minimum requirements: 64-bit host operating system and 1GB of spare operating memory for the VM.
Agenda
Day 1
Basic Toolkit
Overview: Installation and Management, psql
Architecture
General Overview
Isolation and Multiversion Concurrency Control
Vacuum
Buffer Cache and Logging
Data Organization
Logical Layout
Day 2
Data Organization (continued)
Physical Layout
Administration Tasks
-
Monitoring
Access Control
-
Access Control Overview
Access Control Overview
-
Backup and Restore Overview
-
Replication Overview
Registration
Registration is now open !!!
Training cost
Regular: NRs 10,000.00 (NRs. Ten Thousands only)
Discount: Students can apply for the student discount as well. There will be NRs 2000 waive on the registration charge for the student (limited seats are available).
The cost includes
2 Days PostgreSQL training session by an industry expert
Travel from Kathmandu pick up point to training venue
Light Breakfast, Lunch, Tea, Coffee and Water
Training Kit
Hands on notes and training materials
T-shirt with PostgreSQL logo etc.