T-SQL Window Functions: For data analysis and beyond (Developer Reference)
Language: English
Published by Microsoft Press, 2019
- Softcover
- Used
Seller: Goodwill of Greater Milwaukee and Chicago, Racine, WI, U.S.A.Goodwill of Greater Milwaukee and Chicago
AbeBooks seller since September 20, 2024
Condition: Used - Good
US$ 38.33
Quantity: 1 available
Add to basketItem description from seller
Book is considered to be in good or better condition. The actual cover image may not match the stock photo. Hard cover books may show signs of wear on the spine, cover or dust jacket. Paperback book may show signs of wear on spine or cover as well as having a slight bend, curve or creasing to it. Book should have minimal to no writing inside and no highlighting. Pages should be free of tears or creasing. Stickers should not be present on cover or elsewhere, and any CD or DVD expected with the book is included. Book is not a former library copy.
Seller Inventory # SEWV.0135861446.G
- Title
- T-SQL Window Functions: For data analysis and beyond (Developer Reference)
- Author
- Ben-Gan, Itzik
- Publisher
- Microsoft Press
- Publication year
- 2019
- Condition
- good
- Binding
- Soft cover
- Language
- English
- ISBN 10
- 0135861446
- ISBN 13
- 9780135861448
- Edition
- 2nd Edition
- Series
- Book 70 of 77: Developer Reference
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
"Synopsis" may belong to another edition of this title.
About the Author
Itzik Ben-Gan is a mentor and co-founder of SolidQ and has been a data platform Microsoft MVP (Most Valuable Professional) since 1999. Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning, and Programming. Itzik is the author of several books including T-SQL Fundamentals and T-SQL Querying. He has written articles for SentryOne’s sqlperformance.com, ITProToday, and SolidQ. Itzik’s speaking activities include PASS Summit, SQLBits, and various events and user groups around the world. Itzik is the author of SolidQ’s Advanced T-SQL Querying, Programming, and Tuning and T-SQL Fundamentals courses, and he is a primary resource within the company for their T-SQL–related activities.
"About the title" may belong to another edition of this title.
Goodwill of Greater Milwaukee and Chicago
Racine, WI, U.S.A.
AbeBooks seller since September 20, 2024
Shipping rates within U.S.A.
| Item | 5 to 14 business days | 3 to 6 business days |
|---|---|---|
| First item | US$ 3.00 | US$ 5.50 |
Payment methods
Store description
Through our mission we enhance the dignity and quality of life for individuals and families by strengthening communities, eliminating barriers to opportunity, and helping people in need reach their full potential through learning and the power of work. We intentionally serve marginalized populations within these communities and lift up long-term pathways for individuals who have disabilities and disadvantages, veterans and military families, teens and young adults, and others who face barriers to employment. We are guided by three principles: Inspired by People, Power of the Whole, and Results Matter. We call it The Goodwill Way.…
Specialty
VarietySeller's business information
Goodwill Retail Services, Inc.
6055 North 91st Street
Milwaukee, WI U.S.A. 53225
Terms of sale
Returns are allowed when initiated within 30 days of the estimated delivery date.
Goodwill Industries of Northern Illinois is a community-based not-for-profit organization whose mission is to create opportunities for individuals with barriers to enhance their lives. Thank you for supporting our mission.
Shipping terms
We endeavor to ship all orders as quickly as possible--usually within 48 hours of receiving an order--using minimal packaging and recyclable materials whenever possible.