PURCHASE

The Art of PostgreSQL

The book that teaches SQL to developers: Learn to replace thousands of lines of code with simple queries!

The Packages

The Art of PostgreSQL comes in a choice of four packages.
From the Standard Edition package onward, all your needs are covered…

Postgres 15 Special Discount

With the release day for Postgres 15 approaching, I (Dimitri Fontaine) am preparing an update to my book “The Art of Postgres”. My intention is to add coverage for the new features that made it to Postgres in specific areas such as window functions and their frame definition, grouping sets, aggregates, common table expressions, etc…

When purchasing the current edition of “The Art of PostgreSQL” now, you will get access to the new edition with Postgres 15 coverage as soon as it ships. For free!

And to encourage you to encourage me in spending all the time and efforts to renew my book, I have set-up a very nice discount:

Enjoy 30% discount with the code: PG15

  • Standard Edition
    45 $35

    The real deal, 438 pages of advanced SQL teaching, just for you. You get the PDF version, the ePub version, and the MOBI version too. And the SQL queries as separate files too!

    LEARN MORE

    PURCHASE
  • MOST POPULAR
    Full Edition
    99 $75

    The Full Edition comes with the electronic book package and an archive with a PostgreSQL dump file ready to be restored in your own instance, plus all the 334 queries as separate files for you to run and edit!

    LEARN MORE

    PURCHASE
  • Dead Tree Edition
    129 $90

    A professionally printed paperback of 480 pages, with the same content. You also have the benefits of the Full Edition including the copy/paste friendly content, the queries, and the database to use to replay the queries from the book!

    LEARN MORE

    PURCHASE
  • Enterprise Edition
    229 $160

    Everything you need for your whole team to master SQL, including a licence to share the electronic version of the book, the database, the 334 query files and a licence to share everything with up to 15 people in your enterprise!

    LEARN MORE

    PURCHASE

Still not sure what package is best for you? See the chart below for side-by-side comparisons and read the full details below.

Note that you can add the physical book as an second-step add-on in the checkout process.

    • Packages Include
    • Standard
    • Full Edition
    • Dead Tree
    • Enterprise
    • The Paperback Book
    •  
    • The e-Book
    •  
    •  
    •  
    •  
    • 6 Interviews
    •  
    •  
    •  
    •  
    • PDF, ePub, MOBI
    •  
    •  
    •  
    •  
    • SQL Queries & Code
    •  
    •  
    •  
    •  
    • Real World Dataset
    •  
    •  
    •  
    •  
    • Normalization Examples
    •  
    •  
    •  
    •  
    • Unit Tests
    •  
    •  
    •  
    •  
    • Sharing License
    •  
    •  
    •  
    •  
    • Docker Container
    •  
    •  
    •  
    •  
  • 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!).

  • Docker Container

    A PostgreSQL instance loaded with all the data from the book, and running a web based application that allows playing with every SQL query from the book!

  • 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.

  • Sharing License

    Share the book and the docker instance with up to 15 people in your enterprise! Yes, you buy once, then share. You may even run each your own container if you prefer that, of course.

  • 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…

The Interviews

The Art of PostgreSQL includes interviews from developers and SQL masters. PHP, Java, Python and Django get specific treatment in the book, which targets all application developers, whatever the language in use!

Not convinced yet? Get a FREE chapter including the full Table of Contents!