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.
On-Site Training
Courses are available on-site for £1000 per day for a class of up to 8 students. Expenses will also be charged, though at a fixed price agreed before the course.
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.
Scheduled Training
PostgreSQL Administration Workshop - London - 10-11 November 2008 (£600)
PostgreSQL Replication & Recovery Workshop - London - 12-13 November 2008 (£600)
PostgreSQL Development Workshop - London - 24-26 November 2008 (£900)
Advanced Development & Performance - London - 8-9 December 2008 (£600)
If you'd like to attend, just send us a signed booking form to 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
PostgreSQL Development
Development course for those with some knowledge of SQL. On-site options can emphasise one or more interfaces: java, Hibernate, C, PHP, perl, python.
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
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.4 Performance
Back to top
Administrator Courses
PostgreSQL Administration
Comprehensive PostgreSQL Administration course. Course is task-oriented, taking administrators quickly through basic administration and onto more advanced techniques. The course is available in two variants:
PostgreSQL Administration using pgAdminIII
PostgreSQL Administration using Navicat
The Navicat course covers administration using this popular multi-DBMS tool and covers extensions such as importing/exporting data and reports, data/structure synchronisation and group working.
Course topics covered in both are
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
Back to top
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 PostgreSQL
Warm Standby/Log Shipping
Sharding and Scale Out
Futures & Feature Road Map
Back to top
