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: 352
  • Edition: 2nd
  • Book
  • ISBN-10: 0-13-586144-6
  • ISBN-13: 978-0-13-586144-8

Use window functions to write simpler, better, more efficient T-SQL queries

 Most T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations 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 optimization, 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 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

About This Book

• For developers, DBAs, data analysts, data scientists, BI professionals, and power users familiar with T-SQL queries

• Addresses any edition of the SQL Server 2019 database engine or later, as well as Azure SQL Database

Get all code samples at:

MicrosoftPressStore.com/TSQLWindowFunctions/downloads 

Sample Content

Table of Contents

Chapter 01: SQL Windowing

Chapter 02: A Detailed Look at Window Functions

Chapter 03: Ordered Set Functions

Chapter 04: Row Pattern Recognition in SQL

Chapter 05: Optimization of Window Functions

Chapter 06: T-SQL Solutions using Window Functions

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership