BenGan, Itzik
T-SQL Window Functions: For data analysis and beyond
- ISBN 13:
- 9780135861448
- author:
- BenGan, Itzik
- format:
- Paperback / softback
- publisher:
- Addison Wesley
- language:
- English
- Publication Year:
- 2019
- Pages:
- 352
- Dimensions:
- 23 x 19 x 1 centimetres (0.57 kg
- Genre:
- Computers, Server & Database, General Database,
- Condition:
- New
- Availability:
- Item usually sent within 10 working days
Description
T-SQL Window Functions For Data Analysis and Beyond by Itzik Ben-Gan is a comprehensive guide to unlocking the full potential of window functions in T-SQL. With extensive code examples, this expert-led book introduces breakthrough techniques for using window functions to handle common querying tasks with unprecedented elegance and power. You'll learn how to master essential SQL windowing concepts, effectively utilize partitioning, ordering, and framing, and gain practical insight into window aggregate, ranking, offset, and statistical functions. The book also covers advanced Row Pattern Recognition (RPR) data analysis techniques and provides a full library of window function solutions for common business problems. Whether you're a developer, DBA, data analyst, data scientist, BI professional, or power user familiar with T-SQL queries, this book addresses any edition of the SQL Server 2019 database engine or later, as well as Azure SQL Database.
Related Products
Related Products
Data Analysis Using SQL and Excel
Gordon S. Linoff
SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights
Tanimura, Cathy
SQL for Data Scientists: A Beginner's Guide for Building Datasets for Analysis
Teate, Renee M. P.
T-SQL Fundamentals
BenGan, Itzik
SQL for Data Analytics - Third Edition: Harness the power of SQL to extract insights from data
Shan, Jun