In this updated second edition, author Itzik Ben-Gan introduces breakthrough techniques for using window functions for more than just data analysis calculations. Ben-Gan shows how to handle many common T-SQL querying tasks with elegance and power.  Using extensive code examples, the book covers window aggregate, ranking, distribution, offset, and ordered set functions. You’ll find a detailed section on optimization, plus an extensive collection of business solutions.

Author: Itzik Ben-Gan
Publisher: Microsoft Press
Date: November 2019
Pages: 352
ISBN: 978-0135861448
Print: 0135861446
Kindle: B07Z5BB6W1
Audience: SQL Server developers
Level: Intermediate/Advanced
Category: Database 

• 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

Related Reviews

T-SQL Querying

For recommendations of SQL Server books see Pick Of The Shelf - SQL Server in our Programmer's Bookshelf section.

For more Book Watch just click.

Book Watch is I Programmer's listing of new books and is compiled using publishers' publicity material. It is not to be read as a review where we provide an independent assessment. Some, but by no means all, of the books in Book Watch are eventually reviewed.

To have new titles included in Book Watch contact  BookWatch@i-programmer.info

Follow @bookwatchiprog on Twitter or subscribe to I Programmer's Books RSS feed for each day's new addition to Book Watch and for new reviews.