T-SQL Window Functions: For data analysis and beyond (Developer Reference)
Language: English
Published by Microsoft Press, 2019
- Softcover
- Used
Seller: Coas Books, Las Cruces, NM, U.S.A.Coas Books
AbeBooks seller since January 23, 1998
Condition: Used - Fair
US$ 25.20
Quantity: 1 available
Add to basketItem description from seller
Cover is worn. Pages have denting. Item has staining. Paperback. 2nd Edition.
Seller Inventory # COBV.0135861446.A
- Title
- T-SQL Window Functions: For data analysis and beyond (Developer Reference)
- Author
- Ben-Gan, Itzik
- Publisher
- Microsoft Press
- Publication year
- 2019
- Condition
- acceptable
- 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.
Coas Books
Las Cruces, NM, U.S.A.
AbeBooks seller since January 23, 1998
Shipping rates within U.S.A.
| Item | 3 to 7 business days | 2 to 4 business days |
|---|---|---|
| First item | US$ 3.99 | US$ 10.99 |
Payment methods
Store description
About Us: Coas Books is New Mexico’s largest second-hand bookstore with more than 500,000 books in stock! We have an incredible selection of new and used books — including regional and out-of-print books —, CDs, DVDs, Vinyl, VHS, audio books, and games. Coas Books is family owned and operated, with two stores located in Las Cruces, New Mexico. We receive hundreds of books every day, so our inventory is constantly changing and full of hidden gems! Our History: Coas Books was founded in 1983 by archaeologist Pat Beckett. It started out as an archaeological publishing company specializing in anthropology books. As Pat's vast collection of books continued to grow, he purchased a local paperback exchange, and with that Coas Books was born. The name Coas has its roots in archaeology, coming from the Nahuatl term “coa” — meaning digging stick —, and the acronym for "Center of Anthropological Studies". Today, Coas Books is run and operated by Mike and Veronica Beckett as they continue to proudly serve the community in the heart of Las Cruces.…
Specialty
non-fiction, fiction, literature, children, young adult, textbooks, technicalSeller's business information
Coas Books, Inc.
317 N. Main
Las Cruces, NM U.S.A. 88001
Terms of sale
We accept most major credit cards and PayPal.
email: coas@coasbooks.com
phone: (575) 524-8471
Michael Beckett, President
Coas Books, Inc.
317 N. Main Street
Las Cruces, NM 88001
Shipping terms
All orders are processed and shipped within 24 hours!
All US orders are shipped with Delivery Confirmation through USPS.
Economy Mail takes 7 to 14 Business Days to arrive.
Expedited Mail takes 2 to 5 Business Days to arrive.
International shipping varies by country and takes 14 to 30 Business Days to arrive.
Important Notice to International Buyers: Import duties, taxes, and other charges by your country's authorities are not included in the item price or shipping charges. Check with your local customs office to determine what these additional costs may be.