Advanced PostgreSQL Querying
An Explanation of Advanced Features and Techniques in More Than 60 Tutorials
„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.
- Window functions
- Common Table Expressions (CTE)
- JSON Functions
- Date and Time functions
- And many more