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 Development" Workshop Prato, Italy from 22 March to 24 March Italian
"Practical SQL" Workshop Prato, Italy from 12 April to 13 April Italian
"PostgreSQL Database Administration" Workshop Prato, Italy from 14 April to 15 April Italian
"PostGIS" Tutorial Prato, Italy 16 April Italian
"Complex Text handling in PostgreSQL" Workshop London, United Kingdom from 28 April to 30 April English
"PostgreSQL Development" Workshop Rome, Italy from 3 May to 5 May Italian
"Practical SQL" Workshop Prato, Italy from 21 June to 22 June Italian
"PostgreSQL Database Administration" Workshop Prato, Italy from 23 June to 24 June Italian
"PostGIS" Tutorial Prato, Italy 25 June Italian
"PostgreSQL Development" Workshop Prato, Italy from 12 July to 14 July Italian

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

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

PostgreSQL Performance, Replication, and Scaling

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