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 8 courses organised by 2ndQuadrant in one country. Registrations are open.

Course Location Date Language
"PostgreSQL Database Administration" Workshop London, United Kingdom from 6 September to 7 September English
"PostgreSQL Replication & Recovery" Workshop London, United Kingdom from 8 September to 10 September English
"PostgreSQL Development" Workshop London, United Kingdom from 20 September to 21 September English
"PostgreSQL Advanced Development & Performance" Workshop London, United Kingdom from 22 September to 24 September English
"PostgreSQL Database Administration" Workshop London, United Kingdom from 1 November to 2 November English
"PostgreSQL Replication & Recovery" Workshop London, United Kingdom from 3 November to 5 November English
"PostgreSQL Development" Workshop London, United Kingdom from 15 November to 16 November English
"PostgreSQL Advanced Development & Performance" Workshop London, United Kingdom from 17 November to 19 November English

Course catalog

Practical SQL

Targets

  • Database Administration
  • Web development
  • Systems administration
  • Applications development

Topics

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

Course acquired skills

  • SQL basics
  • Basics of databases
top

PostgreSQL Database Administration

Description

In-depth course on PostgreSQL administration. The class is organised in order to cover the tasks that a database administrator faces daily, starting from basic operations to advanced techniques. Unless differently specified, the course will use "pgAdmin III" as graphical administration tool.

Targets

  • Software development
  • Systems 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
  • Basics of databases

Course acquired skills

  • Basics of PostgreSQL database administration
  • PostgreSQL basics
top

PostgreSQL Development

Description

In addition to providing an overview of the libraries and interfaces which connect PostgreSQL to client applications, the course consists of the basic principles behind the des ign and development of applications that interact with a PostgreSQL database.

The course will focus in particular on psql, with specific reference to how application developers can efficiently make use of policies and solutions.

Included also is a broad overview of the use of procedures and functions as defined by users within PostgreSQL, using one of the many languages available through this amazing o pen-source DBMS: PL/pgSQL.

Finally, topics such as query rules and trigger functions will be explored.

Participants are strongly recommended to have attended a prior course on PostgreSQL database administration.

Targets

  • Software development
  • Database Administration
  • Systems architecture
  • Database development

Topics

  • Basic Development
  • psql
  • Statement behaviour
  • Data loading
  • Transaction Management & MVCC
  • Visibility
  • User defined functions and procedural languages
  • PL/pgSQL
  • Function planning
  • Trigger functions
  • Rules
  • PostgreSQL advanced features

Requirements

  • Basics of programming
  • Basics of systems administration
  • Basics of PostgreSQL database administration
  • PostgreSQL basics
  • SQL basics

Course acquired skills

  • Basics of PostgreSQL development
  • Basics of applications design with PostgreSQL
  • Basics of PL/pgSQL
  • Techniques of software development with PostgreSQL (debugging, error management, etc.)
top

PostGIS

Targets

  • Database Administration
  • Geographical Information Systems

Topics

  • PostGIS structure
  • Geographical data loading on PostgreSQL
  • Basics of geographical projections
  • Vector-based geographical analysis
  • PostGIS management through a graphical frontend (QuantumGIS)

Course acquired skills

  • Basics of geographical analysis in databases
  • PostGIS basics
top

PostgreSQL Infinite Scalability

Description

How to get noSQL-like infinite scalability with PostgreSQL while maintaining standard SQL integrity. This course, run by Hannu Krosing, will focus on PL/Proxy, PgBouncer and Skytools, the open-source tools developed by the Skype database team.

Targets

  • Software development
  • Database Administration
  • Systems architecture
  • Database development
  • Database architecture

Topics

  • Scalability challenges
  • Scalability in PostgreSQL
  • PostgreSQL Service Oriented Architecture (SOA)
  • Current common approaches to large-scale data scaling
  • Architecting for minimal developer effort
  • Architecting for minimal administration effort
  • Removal of possible bottlenecks and SPoF
  • The "database bus"
  • Different types of "shared nothing" clustering
  • Skytools as universal base for data moving and processing tasks

Requirements

  • Basics of programming
  • Basics of systems administration
  • Basics of PostgreSQL database administration
  • PostgreSQL basics
  • SQL basics

Course acquired skills

  • Basics of database replication with PostgreSQL
  • Basics of database scalability with PostgreSQL
  • Basics of Skytools
  • Basics of PL/Proxy
  • Basics of PgBouncer
top

Complex Text handling in PostgreSQL

Description

This course is aimed all aspects of text management within PostgreSQL. Covering Free Text Indexing and Searching as well as XML content within the database, this course will provide an understanding of the possibilities of document storage and retrieval within PostgreSQL.

Targets

  • Software development
  • Web development
  • Systems architecture
  • Database development
  • Applications development

Topics

  • XML data types
  • Loading XML
  • Generating XML from the database (SQL/XML)
  • Structured searching with XPath
  • Full Text Search
  • Custom Parsers & dictionaries
  • Full Text Search on XML
  • Languages
  • Metadata management using Dublin Core
  • Delivery – HTML, PDF and more using XSLT
  • Schema management
  • XML Support – differences between MySQL, Oracle and PostgreSQL

Requirements

  • HTML
  • Basics of PostgreSQL database administration
  • PostgreSQL basics
  • SQL basics
  • Basics of PostgreSQL development
  • XML basics

Course acquired skills

  • XML PostgreSQL support
  • PostgreSQL Full Text Search support
top

PostgreSQL Advanced Development & Performance

Topics

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

Streaming Replication and Hot Standby

Description

Discover PostgreSQL 9.0 native features for High Availability and Replication directly from Simon Riggs, Major PostgreSQL Developer. Learn what you can do with Streaming Replication and Hot Standby.

Targets

  • Database Administration
  • Systems administration
  • Business Continuity and Operations

Topics

  • pg_dump and restore options
  • PITR Backup and Recovery
  • Replication Concepts
  • High Availability options
  • Streaming Replication
  • Hot Standby

Requirements

  • Basics of systems administration
  • Basics of PostgreSQL database administration
  • PostgreSQL basics
  • Basics of applications design with PostgreSQL

Course acquired skills

  • Advanced PostgreSQL database administration
  • Advanced database architecture techniques
  • Basics of database replication with PostgreSQL
  • Basics of database scalability with PostgreSQL
  • Basics of high availability and recovery with PostgreSQL
top

PostgreSQL Performance and Scaling Out

Description

The course is aimed at those who are already familiar with PostgreSQL or similar enterprise database systems, in a database administrator, database developer, or system architect role. It is a fast-paced introduction to how high-performance PostgreSQL installations are designed, built, maintained, and grown.

Targets

  • Database Administration
  • Systems architecture
  • Business Continuity and Operations

Topics

  • Server Architecture & Tuning
  • Workload Analysis, Benchmarking and Profiling
  • High Transaction Rate Optimization
  • Maintenance for performance
  • Performance monitoring and logging
  • Performance Tips & Tricks
  • Replication Concepts
  • High Availability options
  • Log Shipping, Warm Standby, Hot Standby
  • Connection Pooling
  • Sharding and Scale Out
  • Futures & Feature Road Map

Requirements

  • Basics of PostgreSQL database administration
  • PostgreSQL basics
  • Basics of PostgreSQL development
  • Basics of applications design with PostgreSQL

Course acquired skills

  • Advanced database architecture techniques
  • Basics of database replication with PostgreSQL
  • Basics of database scalability with PostgreSQL
  • Basics of high availability and recovery with PostgreSQL
  • Advanced database tuning and optimization
  • Monitoring and maintenance of database system performance
top

Datawarehousing with PostgreSQL

Targets

  • Software development
  • Business Intelligence
  • Database Administration
  • Database development
  • Open-source solutions integration

Topics

  • Business intelligence and data warehousing
  • Multi-dimensional data modelling
  • Horizontal partitioning
  • Tablespaces
  • Stored procedures
  • Views
  • Summary navigation
  • Loading the data in the warehouse (ETL or ELT?)
  • Data warehouse integration
  • Data warehouse scalability
  • Data warehouse high availability

Requirements

  • Basics of PostgreSQL database administration
  • PostgreSQL basics
  • SQL basics
  • Basics of PostgreSQL development
  • Basics of applications design with PostgreSQL
  • Basics of PL/pgSQL
  • Advanced PostgreSQL database administration

Course acquired skills

  • Advanced database architecture techniques
  • Basics of database scalability with PostgreSQL
  • Basics of data warehousing
  • Basics of multi-dimensional modelling
  • Basic optimisation techniques for data warehousing in PostgreSQL
top

PostgreSQL Replication & Recovery

Targets

  • Database Administration
  • Systems administration
  • Business Continuity and Operations

Topics

  • pg_dump and restore options
  • PITR Backup and Recovery
  • Replication Concepts
  • High Availability options
  • slony
  • Connection Pooling
  • Upgrading PostgreSQL
  • Warm Standby/Log Shipping
  • Sharding and Scale Out
  • Futures & Feature Road Map

Requirements

  • Basics of systems administration
  • Basics of PostgreSQL database administration
  • PostgreSQL basics
  • Basics of applications design with PostgreSQL

Course acquired skills

  • Advanced PostgreSQL database administration
  • Advanced database architecture techniques
  • Basics of database replication with PostgreSQL
  • Basics of database scalability with PostgreSQL
  • Basics of high availability and recovery with PostgreSQL
top

Sections

Services

Services

Support

Support