T-SQL Window Functions: For Data Analysis and Beyond 3/e
暫譯: T-SQL 窗口函數：數據分析及其他應用 第3版

Ben-Gan, Itzik

T-SQL Window Functions: For Data Analysis and Beyond 3/e
  • 出版商: MicroSoft
  • 出版日期: 2019-11-04
  • 售價: $1,600
  • 貴賓價: 9.5 折 $1,520
  • 語言: 英文
  • 頁數: 352
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 0135861446
  • ISBN-13: 9780135861448
  • 相關分類: SQL、MSSQL、Data 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 查詢的開發人員、DBA、數據分析師、數據科學家、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 年以來一直是微軟的數據平台 MVP（最有價值專業人士）。Itzik 在全球各地舉辦了許多以 T-SQL 查詢、查詢調優和程式設計為主題的培訓活動。Itzik 是幾本書的作者，包括 T-SQL Fundamentals 和 T-SQL Querying。他曾為 SentryOne 的 sqlperformance.com、ITProToday 和 SolidQ 撰寫文章。Itzik 的演講活動包括 PASS Summit、SQLBits 以及全球各地的各種活動和用戶組。Itzik 是 SolidQ 的進階 T-SQL 查詢、程式設計和調優以及 T-SQL Fundamentals 課程的作者，並且是公司內部 T-SQL 相關活動的主要資源。

類似商品

最後瀏覽商品 (8)