T-SQL Window Functions, 2nd Edition
For data analysis and beyond
Price | $26.99 - $31.74
|
Rating | ![]() ![]() ![]() ![]() ![]() |
Author | Itzik Ben-Gan |
Publisher | Microsoft Press |
Published | 2019 |
Pages | 352 |
Language | English |
Format | Paper book / ebook (PDF) |
ISBN-10 | 0135861446 |
ISBN-13 | 9780135861448 |
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.
- Itzik Ben-Gan (4 books)
5 5 2
Similar Books
Expert T-SQL Window Functions in SQL Server
by Kathi Kellenberger, Clayton Groom
Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window...
Price: $23.82 | Publisher: Apress | Release: 2015
Pro SQL Database for Windows Azure, 2nd Edition
by Scott Klein, Herve Roggero
Pro SQL Database for Windows Azure, 2nd Edition shows how to create enterprise-level database deployments without the usual investment in datacenter and other infrastructure. Take advantage instead of Microsoft's worldwide backbone for cloud computing that delivers all the power of SQL Server in the form of the cloud-based SQL Databa...
Price: $49.99 | Publisher: Apress | Release: 2012
Technical Analysis For Dummies, 2nd Edition
by Barbara Rockefeller
Technical analysis is a collection of techniques designed to help people make trading decisions. Technical Analysis For Dummies, 2nd Edition explains the basic principles and shows you how to apply these principles in an approachable and non-intimidating way.Since the publication of the first edition of Technical Analysis For Dummies, rea...
Price: $29.99 | Publisher: Wiley | Release: 2011
Advanced Analytics with Transact-SQL
by Dejan Sarka
Learn about business intelligence (BI) features in T-SQL and how they can help you with data science and analytics efforts without the need to bring in other languages such as R and Python. This book shows you how to compute statistical measures using your existing skills in T-SQL. You will learn how to calculate descriptive statistics, i...
Price: $32.55 | Publisher: Apress | Release: 2021
by Alice Zhao
If you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is your ideal on-the-job reference. You'll find many examples that address the language's complexities, along with key aspects of SQL used in Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL, and SQLite.I...
Price: $28.14 | Publisher: O'Reilly Media | Release: 2021
PostGIS in Action, 2nd Edition
by Regina O. Obe, Leo S. Hsu
Processing data tied to location and topology requires specialized know-how. PostGIS is a free spatial database extender for PostgreSQL, every bit as good as proprietary software. With it, you can easily create location-aware queries in just a few lines of SQL code and build the back end for a mapping, raster analysis, or routing applicat...
Price: $35.97 | Publisher: Manning | Release: 2015
Angular Development with Typescript, 2nd Edition
by Yakov Fain, Anton Moiseev
Angular Development with TypeScript, 2nd Edition is an intermediate-level tutorial that introduces Angular and TypeScript to developers comfortable with building web applications using other frameworks and tools.Whether you're building lightweight web clients or full-featured SPAs, Angular is a clear choice. The Angular framework is ...
Price: $39.99 | Publisher: Manning | Release: 2018
Pro T-SQL Programmer's Guide, 4th Edition
by Miguel Cebollero, Michael Coles, Jay Natarajan
Pro T-SQL Programmer's Guide is your guide to making the best use of the powerful, Transact-SQL programming language that is built into Microsoft SQL Server's database engine. This edition is updated to cover the new, in-memory features that are part of SQL Server 2014. Discussing new and existing features, the book takes you on...
Price: $45.64 | Publisher: Apress | Release: 2015