Meet PostgreSQL
Pluralsight
Course Summary
Learn the most powerful tools for working with the Postgres database system.
-
+
Course Description
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.
-
+
Course Syllabus
Meet PostgreSQL Part 1- 32m 19s
—Introduction 3m 17s
—Installation 4m 9s
—Rails Setup 4m 29s
—Full Text Search 7m 15s
—Search Optimization 10m 34s
—Sorting 2m 35sMeet PostgreSQL Part 2- 34m 53s
—Indexes 5m 41s
—Reporting 6m 47s
—Migrations 2m 5s
—Defaults 1m 23s
—Standards 4m 18s
—App Conversion 10m 56s
—Configuration 2m 49s
—Conclusion 0m 54s