T-SQL Window Functions: For data analysis and beyond by Itzik Ben-Gan (Paperback, 2019)

BuyItNowBooks (337400)
99.1% positive Feedback
Price:
£23.52
Free postage
Estimated delivery Wed, 18 Jun - Tue, 24 Jun
Returns:
60 days return. Buyer pays for return postage. If you use an eBay delivery label, it will be deducted from your refund amount.
Condition:
New
Format:-Paperback / softback. Title:-T-SQL Window Functions: For data analysis and beyond. Genre:-Computers, Server & Database, General Database. Publisher Date:-02/12/2019.

About this product

Product Information

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

Product Identifiers

PublisherPearson Education (Us)
ISBN-139780135861448
eBay Product ID (ePID)8046542302

Product Key Features

Number of Pages352 Pages
LanguageEnglish
Publication NameT-Sql Window Functions: for Data Analysis and Beyond
Publication Year2019
SubjectComputer Science
TypeTextbook
AuthorItzik Ben-Gan
SeriesDeveloper Reference
FormatPaperback

Dimensions

Item Height230 mm
Item Weight581 g
Item Width185 mm

Additional Product Features

Country/Region of ManufactureUnited States
Title_AuthorItzik Ben-Gan

All listings for this product

Buy it now
Any condition
New
Pre-owned
No ratings or reviews yet
Be the first to write a review