PostgreSQL 9 Development

The 3 day class covers important Basic and Intermediate level details for developers interacting with PostgreSQL. Suitable for developers using Java, PHP, Python, perl, .Net and other client languages.

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

Topics

  • Basic Development
  • psql and scripting
  • Statement behaviour
  • Transaction Management & MVCC
  • Transaction Isolation and Visibility
  • Data loading
  • Client/Server topics
  • Interface details (jdbc, DBI, .Net etc)
  • User defined functions and procedural languages
  • PL/pgSQL
  • Triggers
  • Extensions
  • PostgreSQL extended features
  • Using XML
  • Aggregates and Set Returning Functions
  • Window Functions
  • More Functions 
  • Recursive Queries
  • Testing with pgTAP

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.)

PostgreSQL Case studies

Mind Candy logo

Mind Candy

Zero to 50m users in 3 years is a steep curve. 2ndQuadrant stepped in to help with a monster database...

PostgreSQL Books

PostgreSQL 9 Administration Cookbook

PostgreSQL 9 Administration Cookbook

A practical guide, this cookbook will ensure you run a smooth PostgreSQL database.

PostgreSQL 9.0 High Performance

PostgreSQL 9.0 High Performance

A clear, step-by-step guide to optimizing and scaling up PostgreSQL database servers.


Stay in touch with us

Subscribe to our monthly newsletter to hear the latest developments from 2ndQuadrant and related technologies.

We’ll also send you any important news or updates that we think you’ll find useful.

We value your privacy and will not pass your details on to anyone else.