The Art of PostgreSQL

A Small Application

5 Lessons

The SQL REPL: An Interactive Setup

8 Lessons

Indexing in PostgreSQL

4 Lessons

Part IV: SQL Toolbox

1 Lesson

SQL Tools

4 Lessons

Managing Output in SQL

9 Lessons

Understanding Nulls

6 Lessons

Window Functions

3 Lessons

Relations and Joins

3 Lessons

Part V: Data Types

1 Lesson

Serialization and Deserialization

6 Lessons

PostgreSQL Data Types 101

12 Lessons

Denormalized Data Types

9 Lessons

Part VI: Data Modeling

1 Lesson

Object Relational Mapping and Tooling for Database Modeling

5 Lessons

Normalization

5 Lessons

Practical Use Case: Geonames

9 Lessons

Modelization Anti-Patterns

4 Lessons

Denormalization

10 Lessons

Not Only SQL

5 Lessons

Part VII: Data Manipulation and Concurrency Control

1 Lesson

Another Small Application

6 Lessons

Isolation and Locking

5 Lessons

Computing and Caching in SQL

6 Lessons

Triggers

4 Lessons

Listen and Notify

4 Lessons

Batch Update, MoMA Collection

4 Lessons

Part VIII: PostgreSQL Extensions

1 Lesson

What’s a PostgreSQL Extension?

3 Lessons

Auditing Changes with hstore

5 Lessons

Million Song Dataset

2 Lessons

Using Trigrams for Typos

6 Lessons

Denormalizing Tags with intarray

3 Lessons

The Most Popular Pub Names

5 Lessons

Geolocation with PostgreSQL

6 Lessons

Counting Distinct Users with HyperLogLog

6 Lessons

Appendix

3 Lessons