| 书目名称 | SQL Server Analytical Toolkit | | 副标题 | Using Windowing, Ana | | 编辑 | Angelo Bobak | | 视频video | | | 概述 | Is your one--stop shop to get started with statistical data analysis and data mining using TSQL.Provides modifiable templates to use for your unique applications.Gives just enough theory to introduce | | 图书封面 |  | | 描述 | .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 the partition data sets. You will build a toolkit based not only on the window functions but also on the performance tuning tools, use of Microsoft Excel to graph results, and future tools you can learn such as PowerBI, SSIS, and SSAS to enhance your data architecture skills..This book goes beyond just showing how each function works. It presents four unique use-case scenarios (sales, financial, engineering, and inventory control) related to statistical analysis, data analysis, and BI. Each section is covered in three chapters, one chapter for each of the window aggregate, ranking, and analytical function categories..Each chapter includes several TSQL code examples and is re-enforced with graphic output plus Microsoft Excel graphs created from the query output. SQL Server estimated query plans are generated and described so you can see how SQL Server processes the query. These together | | 出版日期 | Book 2023 | | 关键词 | SQL Server development; Analytical tools; Aggregate functions; ranking functions; TSQL; SQL; data analysis | | 版次 | 1 | | doi | https://doi.org/10.1007/978-1-4842-8667-8 | | isbn_softcover | 978-1-4842-8666-1 | | isbn_ebook | 978-1-4842-8667-8 | | copyright | Angelo Bobak 2023 |
The information of publication is updating
|
|
发表于 2025-3-21 18:17:22
