Kniha Advanced PostgreSQL Querying Mark Lorenz

Advanced PostgreSQL Querying

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

Autor: Mark Lorenz
Jazyk: Angličtina
Vazba: Brožovaná
Dostupnost: Skladem u dodavatele
Odesíláme za 9-15 dnů
831
Querying records in large databases can be challenging. In order to achieve the most accurate result...

Informace o knize

Autor
Jazyk
Angličtina
Vazba
Kniha - Brožovaná
Vydáno
2024
Stránek
308
EAN
9798328101752
Enbook ID
50810562
Hmotnost
495
Rozměry
170 x 244 x 16

Kompletní popis

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