SQL server analytical toolkit : using windowing, analytical, ranking, and aggregate functions for data and statistical analysis

SQL server analytical toolkit : using windowing, analytical, ranking, and aggregate functions for data and statistical analysis / Angelo Bobak.

Learn window function foundational concepts through a cookbook-style approach, beginning with an introduction to the OVER() clause, its various configurations in terms of how partitions and window frames are created, and how data is sorted in the partition so that the window function can operate on...

Full description

Saved in:
Bibliographic Details
Main Author: Bobak, Angelo R. (Author)
Format: eBook
Language:English
Published: [California] : Apress, [2023]
Subjects:
SQL server.
SQL server
Database management.
Database management
Online Access:Click for online access
Table of Contents:
  • Chapter 1: Partitions, Frames and the OVER() clause
  • Chapter 2: Sales DW Use Case--Aggregate Functions
  • Chapter 3: Sales Use Case - Analytical Functions
  • Chapter 4: Sales Use Case - Ranking/Window Functions
  • Chapter 5: Finance Use Case - Aggregate Functions
  • Chapter 6: Finance Use Case - Ranking Functions
  • Chapter 7: Finance Use Case - Analytical Functions
  • Chapter 8: Plant Use Case - Aggregate Functions
  • Chapter 9: Plant Use Case - Ranking Functions
  • Chapter 10: Plant Use Case - Analytical Functions
  • Chapter 11: Inventory Control Use Case - Aggregate Functions
  • Chapter 12: Inventory Use Case - Ranking Functions
  • Chapter 13: Inventory Use Case - Analytical Functions
  • Chapter 14: Summary, Conclusions, and Next Steps
  • Appendix 1: Function Syntax, Descriptions
  • Appendix 2: Statistical Functions.

Similar Items