The Art of PostgreSQL (2^nd Ed., Dead Tree Package) Turn Thousands of Lines of Code into Simple Queries

The Dead Tree Package includes:

• The Book
  The Book is a 438 pages full of SQL queries. 334 of them actually, all answering a very clear use-case, that is given in plain English. Every query is explained in details.
• 6 Interviews
  Interviews from industry veterans who began building web application in the previous century. They’ve been there and have opinions to share about how to approach SQL.
• PDF, ePub, MOBI
  The whole electronic reading kit for all your devices: tablet, phone and desktop computer are covered. The PDF is carefully edited to target modern display formats (try it on your tablet!).
• Real World Dataset
  The datasets from the book with 56 tables already loaded from their Open Data sources. We all learn better with concrete examples. You have 15 datasets available in the docker image.
• Normalization Examples
  We also cover how to design a database model and why as a developer you should care about normalizing it. With practical examples and normalization scripts.
• SQL Queries + Code
  The Enterprise Edition’s docker image also includes the 334 queries as .sql files, plus the code of the sample applications presented in the book.
• Unit Tests
  The application code is available with its SQL Regression Testing suite, using RegreSQL. Check out this tool, you might need it soon…

Hi! My name is Dimitri Fontaine and I have been using and contributing to Open Source Software for the best of the last 20 years. I am a PostgreSQL Major Contributor after having contributed Extensions and Event Triggers, among other things.

I have been writing code almost daily for a very long time now, both in a professional capacity and on my leisure time. I’ve also been a database architect and a DBA on-call. As a developer I enjoy using SQL. As a database architect, I like teaching advanced SQL techniques to my colleagues.

The Art of PostgreSQL is the new title of “Mastering PostgreSQL in Application Development”, acclaimed one of the very best resources around to learn SQL!

This second edition of the book includes a whole new chapter about PostgreSQL Extensions. Written by the author of the CREATE EXTENSION command!