T-SQL Window Functions: For Data Analysis and Beyond 3/e

Ben-Gan, Itzik

  • 出版商: MicroSoft
  • 出版日期: 2019-11-04
  • 售價: $1,600
  • 貴賓價: 9.5$1,520
  • 語言: 英文
  • 頁數: 352
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 0135861446
  • ISBN-13: 9780135861448
  • 相關分類: SQLMSSQLData Science
  • 立即出貨 (庫存=1)

買這商品的人也買了...

商品描述

Use window functions to write simpler, better, more efficient T-SQL queries

 

Most T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations make them even more powerful. In T-SQL Window Functions, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using them to handle many common T-SQL querying tasks with unprecedented elegance and power. Using extensive code examples, he guides you through window aggregate, ranking, distribution, offset, and ordered set functions. You'll find a detailed section on optimization, plus an extensive collection of business solutions -- including novel techniques available in no other book.

 

 

 

Microsoft MVP Itzik Ben-Gan shows how to:

 

- Use window functions to improve queries you previously built with predicates

 

- Master essential SQL windowing concepts, and efficiently design window functions

 

- Effectively utilize partitioning, ordering, and framing

 

- Gain practical in-depth insight into window aggregate, ranking, offset, and statistical functions

 

- Understand how the SQL standard supports ordered set functions, and find working solutions for functions not yet available in the language

 

- Preview advanced Row Pattern Recognition (RPR) data analysis techniques

 

- Optimize window functions in SQL Server and Azure SQL Database, making the most of indexing, parallelism, and more

 

- Discover a full library of window function solutions for common business problems

 

 

About This Book

 

- For developers, DBAs, data analysts, data scientists, BI professionals, and power users familiar with T-SQL queries

 

- Addresses any edition of the SQL Server 2019 database engine or later, as well as Azure SQL Database

 

 

Get all code samples at:

 

MicrosoftPressStore.com/TSQLWindowFunctions/downloads

 

商品描述(中文翻譯)

使用窗口函数编写更简单、更好、更高效的 T-SQL 查询

大多数 T-SQL 开发人员都认识到窗口函数在数据分析计算中的价值。但是它们可以做得更多,而且最近的优化使它们变得更加强大。在《T-SQL 窗口函数》一书中,著名的 T-SQL 专家 Itzik Ben-Gan 引入了使用窗口函数处理许多常见 T-SQL 查询任务的突破性技术,具有前所未有的优雅和强大。通过大量的代码示例,他指导您使用窗口聚合、排名、分布、偏移和有序集函数。书中还包含了详细的优化部分,以及大量的业务解决方案,包括其他书籍中没有的新颖技术。

Microsoft MVP Itzik Ben-Gan 展示了如何:
- 使用窗口函数改进之前使用谓词构建的查询
- 掌握关键的 SQL 窗口概念,并高效设计窗口函数
- 有效地利用分区、排序和帧
- 深入了解窗口聚合、排名、偏移和统计函数
- 了解 SQL 标准如何支持有序集函数,并找到语言中尚未提供的函数的解决方案
- 预览高级行模式识别(RPR)数据分析技术
- 优化 SQL Server 和 Azure SQL Database 中的窗口函数,充分利用索引、并行处理等功能
- 发现用于常见业务问题的完整窗口函数解决方案

关于本书:
- 面向熟悉 T-SQL 查询的开发人员、数据库管理员、数据分析师、数据科学家、BI 专业人员和高级用户
- 适用于 SQL Server 2019 数据库引擎或更高版本,以及 Azure SQL Database

获取所有代码示例:
MicrosoftPressStore.com/TSQLWindowFunctions/downloads

作者簡介

Itzik Ben-Gan is a mentor and co-founder of SolidQ and has been a data platform Microsoft MVP (Most Valuable Professional) since 1999. Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning, and Programming. Itzik is the author of several books including T-SQL Fundamentals and T-SQL Querying. He has written articles for SentryOne's sqlperformance.com, ITProToday, and SolidQ. Itzik's speaking activities include PASS Summit, SQLBits, and various events and user groups around the world. Itzik is the author of SolidQ's Advanced T-SQL Querying, Programming, and Tuning and T-SQL Fundamentals courses, and he is a primary resource within the company for their T-SQL-related activities.

 

作者簡介(中文翻譯)

Itzik Ben-Gan是SolidQ的導師和共同創辦人,自1999年以來一直是Microsoft MVP(最有價值專家)的數據平台專家。Itzik在世界各地舉辦了許多以T-SQL查詢、查詢調整和編程為重點的培訓活動。他是幾本書的作者,包括《T-SQL基礎》和《T-SQL查詢》。他曾為SentryOne的sqlperformance.com、ITProToday和SolidQ撰寫文章。Itzik的演講活動包括PASS Summit、SQLBits以及世界各地的各種活動和用戶組。他是SolidQ的高級T-SQL查詢、編程和調優以及T-SQL基礎課程的作者,並且在公司內是他們T-SQL相關活動的主要資源。