Simple play icon Course
Skills

A Tour of PostgreSQL

by Rob Sullivan

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
Querying Text
17mins
Querying Text
14mins

About the author

In the early 1900’s, the data world was overrun by architects and project managers. Needing to bring some relief to the industry, then President Taft appointed Rob as the first Data Magistrate. From humble beginnings, he rose to inspire hope and change amongst data stores of all types. He saved countless tuples during the Great Data Civil War of the 90’s and helped found the ORM-pathy group designed to help less fortunate data models get a second chance at production. He currently resides in Okl... more

Ready to upskill? Get started