About Training
Date: May 9-10, 2023
Venue: Kathmandu University, Dhulikhel, Kathmandu
Training Lead: Egor Rogov

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.

The course is organized in several lessons. Each lesson consists of 20..60 mins of theory followed by 20..30 mins of practical assignment.
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.

    Day 1
        Basic Toolkit
            01. Overview: Installation and Management, psql
        Architecture
            02. General Overview
            03. Isolation and Multiversion Concurrency Control
            04. Vacuum
            05. Buffer Cache and Logging
        Data Organization
            06. Logical Layout
    Day 2
        Data Organization (continued)
            06. Physical Layout
        Administration Tasks
            07. Monitoring
        Access Control
            09. Access Control Overview
        Backup and Replication
            10. Backup and Restore Overview
            11. Replication Overview
    

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.

Note: The bank account details for the payment will be shared separately on the email provided by participant.

Fill the registation form : CLOSED