New Chapter
This second edition of the book includes a whole new chapter about PostgreSQL Extensions.
Written by the author of the CREATE EXTENSION command!
Second Edition
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!
Improved Book Design
Because the first edition of the book has been so well received, the second edition is now available as a redesigned paperback printed format, making it a strong fit for your library!
Learn how to deal with SQL in your developer workflow: versioning, testing, code reviewing, deployment. Best practice and tools are covered.
Learn advanced SQL with practical examples and datasets that help you get the most of the book! Every query solves a practical use case and is given in context.
The book covers (de-)normalisation with simple practical examples to dive into this seemingly complex topic, including Caching and Indexing Strategy.
This book is for developers, covering advanced SQL techniques for data processing. Learn how to get exactly the result set you need in your application’s code!
Writing efficient SQL is easier than it looks, and begins with database modeling and writing clear code. The book teaches you how to write fast queries!
The book comes with open data sets and instructions to get them so that you can run all the SQL queries at home, edit them and learn from them. Advanced psql setup is even included!
The Art of PostgreSQL comes in a choice of four packages.
From the Standard Edition package onward, all your needs
are covered…
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
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!
PURCHASEThe 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!
PURCHASEA 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!
PURCHASEEverything 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!
PURCHASEStill 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. ⍟
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.
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.
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!).
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!
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.
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.
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.
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.
The application code is available with its SQL Regression Testing suite, using RegreSQL. Check out this tool, you might need it soon…
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!