Advanced PostgreSQL Querying

Querying records in large databases can be challenging. In order to achieve the most accurate results with the least amount of code and the highest possible performance, modern database systems provide tools and techniques that go far beyond simple SELECT statements or JOIN and GROUP BY operations.

„Advanced PostgreSQL Querying“ focusses on the variety of advanced built-in functions and concepts of the PostgreSQL database system up to version 12. These functions and numerous possible use cases are described and explained in over 60 detailed step-by-step tutorials using practical examples. This book is aimed at developers of database queries who possess solid knowledge of SQL basics and would like to enhance the efficiency and elegance of their queries.

Topics included:
- Window functions
- Common Table Expressions (CTE)
- JSON Functions
- Date and Time functions
- And many more

Mark Lorenz worked in various projects in different positions, such as Lead Development, Software Architecture and Test Management. This gave him a deep insight into the problems programmers often face when dealing with efficient handling of databases. Therefore, he started to give workshops on effective and efficient database queries.

Today Mark Lorenz works mainly in the field of public transport. There, high-performance databases are an essential part of digitisation. He used many of the problems, that arise in this work, for his book "Advanced PostgreSQL Querying".