Description: Use window functions to write simpler, better, more efficient T-SQL queries Most T-SQL developers recognise the value of window functions for data analysis calculations. But they can do far more, and recent optimisations 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 optimisation, 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 utilise 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 Optimise 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
Price: 22.72 GBP
Location: Gloucester
End Time: 2024-09-01T08:50:55.000Z
Shipping Cost: 22.08 GBP
Product Images
Item Specifics
Return postage will be paid by: Buyer
Returns Accepted: Returns Accepted
After receiving the item, your buyer should cancel the purchase within: 60 days
Return policy details:
EAN: 9780135861448
UPC: 9780135861448
ISBN: 9780135861448
MPN: N/A
Item Length: 22.9 cm
Item Height: 230 mm
Item Width: 185 mm
Series: Developer Reference
Author: Itzik Ben-Gan
Publication Name: T-Sql Window Functions: for Data Analysis and Beyond
Format: Paperback
Language: English
Publisher: Pearson Education (Us)
Subject: Computer Science
Publication Year: 2019
Type: Textbook
Item Weight: 581 g
Number of Pages: 352 Pages