The GIS Center uses PostgreSQL for much of our database related projects. One of the issues we have found with working with undergraduate students is the lack of experience with Postgres. Here are some resources that we have found helpful to learn introduce yourself to Postgres:

PostgreSQL Basics by Example

PostgreSQL 9.2.4 DocumentationTutorial

PostgreSQL Tutorial

PostgreSQLTutorial.com