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.
<ASIN:0135861446>
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.
Deep Learning (No Starch Press)
Author: Andrew Glassner Publisher: No Starch Press Date: July 2021 Pages: 750 ISBN: 978-1718500723 Print: 1718500726 Kindle: B085BVWXNS Audience: Developers interested in deep learning Rating: Mike James Reviewer: 5 A book on deep learning wtihout an equation in sight?
|
Street Coder (Manning)
Author: Sedat Kapanoglu Publisher: Manning Date: February 2022 Pages: 272 ISBN: 978-1617298370 Print: 1617298379 Kindle: B09Q3PJQC5 Audience: General Rating: 4 Reviewer: Ian Elliot Street Coder - sounds sort of tough but messy at the same time.
| More Reviews |
|