Home > Store

T-SQL Window Functions: For data analysis and beyond, 2nd Edition

Register your product to gain access to bonus material or receive a coupon.

T-SQL Window Functions: For data analysis and beyond, 2nd Edition

Best Value Purchase

Book + eBook Bundle

  • Your Price: $43.19
  • List Price: $71.98
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

More Purchase Options

Book

  • Your Price: $31.99
  • List Price: $39.99
  • Estimated Release: Nov 13, 2019

eBook (Watermarked)

  • Your Price: $25.59
  • List Price: $31.99
  • Estimated Release: Nov 13, 2019
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

About

Features

  • Discover the surprising power of window functions, and learn how to use them far more widely
  • The most advanced coverage of T-SQL window functions — including new techniques invented by author Itzik Ben-Gan, one of the world’s top T-SQL experts
  • Covers T-SQL for all recent versions of Microsoft SQL Server (including 2019) and Microsoft Azure SQL Database — including important new window function optimizations
  • Ideal for anyone who uses T-SQL to solve business problems

Description

  • Copyright 2020
  • Dimensions: 7-3/8" x 9-1/8"
  • Pages: 288
  • Edition: 2nd
  • Book
  • ISBN-10: 0-13-586144-6
  • ISBN-13: 978-0-13-586144-8

Most T-SQL developers recognize the value of window functions for data analysis calculation. But window functions can do far more than that, and optimizations in recent versions of SQL Server have made them more powerful than ever. In T-SQL Window Functions: For Data Analysis and Beyond, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using window functions to handle many common T-SQL querying tasks with unprecedented elegance and power.
Ben-Gan first explains why window functions can often be a far better solution than traditional predicate-based approaches. Next, using extensive code examples, he guides you through each type of window function: Aggregate, Ranking, Distribution and Offset. You’ll find detailed coverage of ordered set functions (including SQL Server 2017’s STRING_AGG); plus an extensive section on optimization. The book concludes with roughly 100 pages of real T-SQL solutions using window function approaches — including techniques invented by the author and available in no other book.

Sample Content

Table of Contents

1. SQL Windowing2. A Detailed Look at Window Functions3. Ordered Set Functions4. Optimization of Window Functions5. T-SQL Solutions Using Window Functions

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership