.webp){kind=small}
.webp){kind=small}
.webp){kind=small}
Please rate the book
Mastering PostgreSQL in Application Development is answering practical questions every developer is confronted to when using PostgreSQL. For instance, should PostgreSQL be a convenient remote storage facility, or is there something more to it that comes with those ACID properties?
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…