Pre Conference Training

This training will help you mastering SQL and PL/pgSQL server-side development. It includes a series of practical assignments based on the Bookstore sample application: from designing a database schema to creating tables, views, functions, and triggers.

About the course

⏳ Duration: 2 days (14 Hours)

🗓️ Date: 3-4 May, 2025

🎓️ Meet your Trainers

Egor Rogov

Egor Rogov is the author of the PostgreSQL Internals book (in english) and brings over 20 years of experience in database management systems as both an application developer and project manager. Since 2015, he has been actively contributing to educational programs at Postgres Professional, where he shares his expertise through training, workshops, and other initiatives.

Ilia Bashtanov

Ilia Bashtanov creates educational courses and programs at Postgres Professional and specializes in developing database applications. With expertise in full-stack web, desktop, and mobile development, he delivers high-quality, functional solutions that meet client needs.

Pavel Tolmachev

Pavel Tolmachev is an experienced programmer with expertise in PostgreSQL, C#, WinForms, WPF, ASP.NET, and Oracle PL/SQL. Currently, he contributes to educational initiatives at Postgres Professional, where he writes articles, develops workshops, designs training courses, and delivers presentations. Since his student days, Pavel has been deeply passionate about database management systems (DBMS), with a particular interest in exploring the intricacies of query optimizers.

⚠️ Prerequisites

SQL fundamentals
experience with any procedural programming language
basic knowledge of Unix OS

The detailed course materials will be available soon.

💡 Skills to be gained

general information about PostgreSQL architecture
working with the main database objects: tables, indexes, views
programming in SQL and PL/pgSQL on the server side
using the main data types, including records and arrays
setting up client-server communication

📝 Registration

Registration is required for the training. Follow the registration link to secure your seat. Very limited seats are available.

Registration will cover: Transportation (from pickup point to Kathmandu University), Tea/Coffee, Breakfast, Lunch, Basic Stationary Kit