Course
Skills
A Tour of PostgreSQL
A Web Developer (Rob Conery) and a SQL Server DBA (Rob Sullivan) take a deep look at PostgreSQL.
What you'll learn
In this production, a SQL Server DBA (Rob Sullivan) and a developer (Rob Conery) take a deep dive into PostGreSQL (v9.1). This series was originally about Mono and ASP.NET MVC - but "the Robs" quickly found themselves amazed and surprised by just how capable, intelligent and fast PostGreSQL is. The goal of this production is to introduce people to PostGres who aren't familiar with the system.
Table of contents
Why Should You Care?
7mins
The Perils of MySQL
19mins
Data Types
7mins
Concurrency and the MVCC
13mins
Performance Tuning
28mins
Querying Text
17mins
PSQL
27mins
Querying Text
14mins