- Course
Meet PostgreSQL
Learn the most powerful tools for working with the Postgres database system.
- Course
Meet PostgreSQL
Learn the most powerful tools for working with the Postgres database system.
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
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 this course, 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.