PostgreSQL 9 Database Administration

The 2 day class covers the tasks that a database administrator faces daily, starting from basic operations to advanced techniques. Course notes use PgAdmin as graphical administration tool.

Targets

  • Software development
  • Systems administration

Topics

  • Connecting & Troubleshooting
  • PgAdmin III Overview
  • Server Configuration
  • Database Administration
  • User Administration
  • Understanding Database Object Types
  • Permissions & Security
  • Running SQL
  • Monitoring
  • MVCC and VACUUM
  • Maintenance
  • Data Migration & Test Environments
  • Server Logs
  • Help & Support

Requirements

  • SQL basics
  • Basics of databases

Course acquired skills

  • Basics of PostgreSQL database administration
  • PostgreSQL basics

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.