▶   We’ve been acquired by Pluralsight!   ▶   Upgrade your account to Pluralsight   ▶   More details…

Meet PostgreSQL

Preview

Download Free Preview

Purchase includes Quicktime (zip) download Purchase includes iPod download

Level: Intermediate

For many years, serious database aficionados have preferred the Postgres database system. It’s industrial strength – many installations store terabytes of data. It’s fully open source (not controlled by a predatory corporation). It’s fast and easy to use. Full text search is built-in. It’s the default database for all applications deployed to Heroku.

In the 65 minute Meet PostgreSQL tutorial, respected database expert (and world-traveling teacher of “The Database is Your Friend” workshops) Xavier Shay teaches the most useful and powerful features of Postgres. You’ll learn to use the built-in full-text search and optimize it. You’ll work with triggers and indexes. You’ll save yourself hours of frustration with tips for using Postgres smoothly with Rails 3.

If you’re familiar with databases but want to add Postgres to your toolbox, this is the video for you!

You’ll learn to:

  • Setup full text search
  • Optimize search with triggers and indexes
  • Use Postgres with Ruby on Rails 3
  • Optimize indexes by including only the rows that you need
  • Use database standards for more reliable queries
  • Write powerful reports in only a few lines of code
  • Convert an existing MySQL application to use Postgres

Postgres works well as an auxiliary reporting database or as the main database for your application. Get started today!

Available as part of a PeepCode Unlimited subscription (including streaming on our iOS app!) Business plans are also available.

Includes a typed transcript.

Skills

You’ll do well with this screencast if you’ve used any SQL database and if you have at least some experience with Ruby on Rails.

Revision 1 (Notes) · Updated: Feb 16, 2011 · Length: 65 min · 250 MB

Screencast Catalog