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.
Courses are modular, so can be assembled to meet your exact needs for on-site courses. Contact us now for a free Training Needs Analysis and customized outline. New courses are always under development, so please enquire about custom courses, or to find out what's in the pipeline.
Get taught by "someone who really knows what they're talking about", Nic Doye, attendee.
Scheduled Training
Practical SQL for Developers - London - 16-17 June 2008 (£600)
Developing with PostgreSQL - London - 18 June 2008 (£300)
Practical SQL for Business Intelligence - London - 23-24 June 2008 (£600)
Replication & Recovery - London - 25 June 2008 (£300)
Advanced Development & Performance - London - 7-8 July 2008 (£600)
PostgreSQL for MS SQL Server Developers - London - 21-23 July 2008 (£600)
If you'd like to attend, just fax through a signed booking form to us on
FAX +44 (0)870 8381077.
Course Descriptions
Scheduled courses follow these outlines.
Developer Courses
Practical SQL
Aimed at both beginners and improvers, this course explains practical SQL solutions to complex development and business problems. This course covers the SQL Standard language wherever possible, allowing the skills learned to be applied generically to many database systems. Course is available as two variants: one for Developers, one for Business Intelligence.
Back to top
Developing with PostgreSQL
Intermediate level course in SQL and PL/pgSQL development specifically for PostgreSQL.
PostgreSQL Extensions to SQL
Builtin Functions
User Defined Functions
Object Relational Data Types
Triggers
Rules and Views
Basic PL/pgSQL
Error Handling & Exceptions
Debugging PL/pgSQL
Data Loading
Back to top
PostgreSQL for MS SQL Server Developers
Special migration course for those with experience of MS SQL Server who develop or administer PostgreSQL databases. Course uses PostgreSQL's graphical administration tool, pgAdmin to illustrate similarities and differences between the products, aiming to get you working quickly and easily with PostgreSQL.
Back to top
Advanced Development & Performance
Very popular course on performance, for developers with some knowledge of PostgreSQL and some previous experience of RDBMS.
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.3 Performance
Back to top
Administrator Courses
Replication & Recovery
Intermediate to Advanced course on PostgreSQL Replication, Clustering, High Availability and Horizontal Scaling/Sharding.
pg_dump and restore options
PITR Backup and Recovery
Replication Concepts
Full Discussion of HA Options
slony
Connection Pooling
Upgrading to PostgreSQL 8.3
Warm Standby/Log Shipping
Sharding and Scale Out
Futures & Feature Road Map
Back to top
