Training

2ndQuadrant provide a wide range of training courses covering your needs from Introductory to Advanced levels. Courses are available via our public schedule, as on-site courses or via various virtual classroom techniques. Each major topic is offered as a Tutorial or as a Workshop with extensive practicals.

Courses are designed, written, and often taught by Simon Riggs, PostgreSQL Major Developer. Comprehensive student handbook provided for each attendee consists of a full colour set of slides plus relevant charts and tables. Course notes are technically detailed including many hints from prior usage and information directly from the source code. Courses are constantly maintained to ensure they are accurate and up-to-date.

Get taught by someone who really knows what they're talking about, Nic Doye, attendee.

Scheduled Training

There are currently 10 courses organised by 2ndQuadrant in 2 countries. Registrations are open.

Course Location Date Language
"PostgreSQL Database Administration" Workshop London, United Kingdom from 20 July to 21 July English
"PostgreSQL Development" Workshop London, United Kingdom from 22 July to 24 July English
"PostgreSQL Database Administration" Workshop Prato, Italia from 27 July to 28 July Italian
"PostgreSQL Replication & Recovery" Workshop London, United Kingdom from 27 July to 29 July English
"PostgreSQL Database Administration" Workshop London, United Kingdom from 21 September to 22 September English
"PostgreSQL Development" Workshop London, United Kingdom from 23 September to 25 September English
"PostgreSQL Replication & Recovery" Workshop London, United Kingdom from 28 September to 30 September English
"PostgreSQL Database Administration" Workshop London, United Kingdom from 16 November to 17 November English
"PostgreSQL Development" Workshop London, United Kingdom from 18 November to 20 November English
"PostgreSQL Replication & Recovery" Workshop London, United Kingdom from 23 November to 25 November English

Course catalog

Practical SQL

Topics

  • Relational Model
  • Data and Data Types
  • Creating Tables and Columns
  • Modifying data
  • Single table SELECTs
  • Understanding Joins
  • Sub-selects
  • Aggregation
  • Builtin Functions
top

PostgreSQL Database Administration

Topics

  • Connecting & Troubleshooting
  • Viewing Database Objects and Running SQL
  • Monitoring
  • Permissions & Security
  • Indexing
  • Backups, Data Migration & Test Environments
  • Server Logs
  • Maintenance
  • Localisation
  • Help & Support
  • Teamworking
  • Enterprise Integration

Requirements

  • SQL Basics

Course acquired skills

  • PostgreSQL Basics
  • Basics of PostgreSQL Database Administration
top

PostgreSQL Replication & Recovery

Topics

  • pg_dump and restore options
  • PITR Backup and Recovery
  • Replication Concepts
  • Full Discussion of HA Options
  • slony
  • Connection Pooling
  • Upgrading PostgreSQL
  • Warm Standby/Log Shipping
  • Sharding and Scale Out
  • Futures & Feature Road Map
top

PostgreSQL Replication and High Availability

top

PostgreSQL Development

Topics

  • Basic Development & psql
  • Transaction Management & MVCC
  • Functions
  • Object Relational
  • C: libpq and ecpg
  • java: jdbc
  • PL/pgSQL
  • Error Handling & Debugging
  • PostgreSQL Tips & Tricks
  • Triggers
  • Rules and Views
top

PostgreSQL Advanced Development & Performance

Topics

  • Server Architecture & Tuning
  • MVCC, VACUUM and HOT
  • Locking & Concurrency
  • Advanced Development Summary
  • Reading EXPLAINs
  • Workload Analysis & Profiling
  • Join Planning
  • SQL Performance Tips & Tricks
  • What's New in 8.4 Performance
top

Sections

Services

Services

Support

Support