What do you think?
Rate this book
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
„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
308 pages, Paperback
Published June 23, 2020
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
No one has reviewed this book yet.