Sessions at Open Source Bridge 2010 about SQL and Databases with audio

Thursday 3rd June 2010

Interested in using PostgreSQL for you next project, or migrating to it? This tutorial will go over the basics of PostgreSQL administration and database application design, including coverage of the features available in version 9.0.

Topics to be covered include:

Installation & packaging options

Basic performance configuration

Basic security configuration

Creating your first database

Backups, PITR and Replication

Common administrative tasks

Application design patterns

Managing database changes over time

Special features you might not know about

Tools you're likely to need

In order to get the most out of this tutorial, all users should bring a laptop with PostgreSQL Version 8.4 and pgAdmin installed. For users unfamiliar with installing PostgreSQL, the One-Click installer is here: http://www.enterprisedb.com/prod...