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.
Machine Learning For Dummies, 2e (Wiley)
Author: John Paul Mueller Publisher: For Dummies Date: January 2021 Pages: 464 ISBN: 978-1119724018 Print: 1119724015 Kindle: B08SZHJGJW Audience: General, but not too dumb Rating: 4 Reviewer: Mike James Dummies probably need machine learning to cope...
|
Python Crash Course, 3rd Ed (No Starch Press)
Author: Eric Matthes Publisher: No Starch Press Pages: 552 ISBN: 978-1718502703 Print: 1718502702 Kindle: B09WJX22TV Audience: People wanting to learn Python Level: Introductory/Intermediate Audience: Not the complete beginner Rating: 4 Reviewer: Alex Armstrong To reach a third edition this [ ... ]
| More Reviews |
|