Advanced Topics on Analytics
This part of the book focuses on enhancing your understanding of PostgreSQL’s data retrieval mechanisms by exploring how databases and indexes are scanned for optimized query performance. It introduces complex data types such as JSON and arrays, allowing you to handle semi-structured data beyond traditional relational models. You will also learn how to process date/time, text, and geospatial data, enabling richer and more accurate real-world analyses. This part also introduces fundamental inferential statistics such as hypothesis testing, confidence intervals, and regression analysis as tools for uncovering relationships and making predictions. Finally, it provides a case study of the modern data analytics workflow, showing how SQL fits into broader data analysis systems with examples.
This part of the book includes the following chapters:
- Chapter 10, Performant SQL
- Chapter 11, Processing JSON and Arrays
- Chapter 12, Advanced...
