Time left to place your booking

 

Days

 

Hours

 

Minutes

 

Seconds

Training

This year we’re running three optional, full-day training courses during PGConf UK. These courses will be held at the same venue as the main day - 30 Euston Square. Each course covers the most popular PostgreSQL specific topics and have been sold out at other conferences in Europe and the USA.


Course 1:  Multi-Master Replication for PostgreSQL


Monday 2nd July 2018, London

Tutor: Simon Riggs (CTO & Founder, 2ndQuadrant)

Level: Intermediate


Content:


Bi-Directional Replication for PostgreSQL (Postgres-BDR, or BDR) is the first open source multi-master replication system for PostgreSQL to reach full production status. BDR is specifically designed for use in geographically distributed clusters, using highly efficient asynchronous logical replication, supporting anything from 2 to more than 48 nodes in a distributed database. It can be deployed on bare metal, a virtualized environment, or in the cloud.


This course introduces the participant to:


  • The architecture of the BDR cluster
  • How to optimally set up the cluster
  • Best practice usage
  • Monitoring your BDR environment to ensure optimal performance
  • High availability in BDR


The course also includes practical exercises to enhance the understanding.


Price: £399 (or £349 for during our Early Bird promotion). If purchased together with a ticket to PGConf UK, a 10% discount will be applied to your order total. All prices are inclusive of VAT.



Course 2:  PostgreSQL Performance Tuning


Monday 2nd July 2018, London

Tutor: Tomas Vondra (Developer, 2ndQuadrant)

Level: Intermediate


A whole-day training session focused on areas that you should master to tune PostgreSQL for performance. The training starts by explaining the overall architecture of the database system, how it interacts with the operating system and what settings are important; both in PostgreSQL and the operating system itself.


PostgreSQL is a multi-user system executing queries in parallel and it uses a fair amount of locking to co-ordinate those independent processes. As locks are a natural enemy of parallel systems, we'll spend some time explaining the basics of locking in PostgreSQL and how to investigate these issues. We'll also look at the basics of MVCC, a PostgreSQL feature that allows database systems to reduce the amount of locking. It's important to understand the basic MVCC idea as it has consequences for maintenance, particularly with regards to reclaiming space by VACUUM/autovacuum.


We will then discuss topics that are relevant for performance optimisation at the query level, such as; alternative ways to design a database, workload analysis, indexes, using EXPLAIN to tune queries, partitioning and - as a continuation of the MVCC discussion - transactions and isolation levels.


Content:


  • Server Architecture and Tuning
  • MVCC and VACUUM
  • Locking and Concurrency
  • EXPLAIN SQL Tuning
  • Workload Analysis
  • Indexes

Price: £399 (or £349 for during our Early Bird promotion). If purchased together with a ticket to PGConf UK, a 10% discount will be applied to your order total. All prices are inclusive of VAT.


Course 3:  PostgreSQL Security


Monday 2nd July 2018, London

Tutor: Dr. Gianni Ciolli (Principal Consultant, 2ndQuadrant)

Level: Intermediate


Identifying database security breach points is the first step towards improving your infrastructure so that you don’t become a victim of malicious attack due to preventable vulnerabilities. 


This training course will highlight the importance of database security in the following areas:


  • Operating System Security
  • Network Security Strategy
  • User Authentication Levels
  • Schema Level Security
  • Data Encryption
  • Backup Security
  • Row Level Security
  • SCRAM authentication


Price: £399 (or £349 for during our Early Bird promotion)If purchased together with a ticket to PGConf UK, a 10% discount will be applied to your order total. All prices are inclusive of VAT.



If you're interested in booking a place for any of these training courses, please visit our booking page.