Advanced PostgreSQL Querying An Explanation of Advanced Features and Techniques in More Than 60 Tutorials

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