MOTHER'S DAY SPECIALS! SHOW ME MORE

Close Notification

Your cart does not contain any items

T-SQL Window Functions: For data analysis and beyond by Itzik Ben-Gan at Abbey's Bookshop,
T-SQL Window Functions: For data analysis and beyond
— —
Itzik Ben-Gan

T-SQL Window Functions

For data analysis and beyond

Itzik Ben-Gan

$107.95   $86.48

Paperback

Not in-store but you can order this
How long will it take?
English
Addison Wesley
02 December 2019
Database programming; Database software
Series: Developer Reference
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
By:  
Imprint:   Addison Wesley
Country of Publication:   United States
Edition:   2nd edition
Dimensions:   Height: 230mm,  Width: 185mm,  Spine: 20mm
Weight:   581g
ISBN:   9780135861448
ISBN 10:   0135861446
Series:   Developer Reference
Pages:   352
Publication Date:  
Audience:   Professional and scholarly ,  Undergraduate
Format:   Paperback
Publisher's Status:   Active

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.

See Also

T-SQL Window Functions: For data analysis and beyond

Pro T-SQL Programmer's Guide

Jay Natarajan

Paperback

$214.95  $171.85

Not in-store but you can order this

ADD +
T-SQL Window Functions: For data analysis and beyond

Beginning SQL Server 2005 for Developers...

From Novice to Professional

Robin Dewson

Paperback

$107.95  $86.54

Not in-store but you can order this

ADD +
T-SQL Window Functions: For data analysis and beyond

Guerrilla Analytics

A Practical Approach to Working...

Enda Ridge (Data Scientist, London,...

Paperback

$70.95 

Not in-store but you can order this

ADD +
T-SQL Window Functions: For data analysis and beyond

Dynamics 365 Essentials

Getting Started with Dynamics 365...

Sarah Critchley

Paperback

$152.95  $121.96

Not in-store but you can order this

ADD +
T-SQL Window Functions: For data analysis and beyond

Kaizen

How to Apply Lean Kaizen to Your...

Greg Caldwell

Paperback

$33.95  $30.19

Not in-store but you can order this

ADD +
T-SQL Window Functions: For data analysis and beyond

Lean Analytics

How to Use Data to Track, Optimize,...

Greg Caldwell

Paperback

$31.95  $28.70

Not in-store but you can order this

ADD +