T-SQL Window Functions: For Data Analysis and Beyond
Language: English
Published by Microsoft Press, 2019
- Softcover
- Used
Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.ThriftBooks-Dallas
AbeBooks seller since July 2, 2009
Condition: Used - Fair
US$ 29.19
Quantity: 1 available
Add to basketItem description from seller
Readable copy. Pages may have considerable notes/highlighting. ~ ThriftBooks: Read More, Spend Less.
Seller Inventory # G0135861446I5N00
- Title
- T-SQL Window Functions: For Data Analysis and Beyond
- Author
- Ben-Gan, Itzik
- Publisher
- Microsoft Press
- Publication year
- 2019
- Condition
- Fair
- Dust jacket
- No Jacket
- Binding
- Paperback
- Language
- English
- ISBN 10
- 0135861446
- ISBN 13
- 9780135861448
- Edition
- 2nd Edition
- Item weight
- 1.9 pounds
- 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.
ThriftBooks-Dallas
Dallas, TX, U.S.A.
AbeBooks seller since July 2, 2009
Shipping rates within U.S.A.
| Item | 4 to 8 business days | 4 to 8 business days |
|---|---|---|
| First item | US$ 0.00 | US$ 0.00 |
Payment methods
Store description
ThriftBooks is a fully independent seller of used books, having sold more than 160 million used and new books since we started in 2003. Each quality used book is sorted, graded, shelved and shipped by hand by our team of dedicated employees in our seven warehouses across the US. We have the best selection of books, in the right condition and format, at everyday low prices. We also have a dedicated, US-based Customer Service team, ranked in the top three by Newsweek for Best Customer Service in 2018 and 2019, so you can shop with confidence. We support and invest in our employees, appreciate and value our customers, and truly believe in the power of the written word to educate, energize, and engage readers of all ages and interests.…
Seller's business information
Thrift Books Global LLC
18300 Cascade Ave S
Seattle, WA U.S.A. 98188
Terms of sale
We guarantee each book that we send you. If you have any problems, please contact
our dedicated customer service department. They will do everything possible to
ensure you are happy with your order.
Shipping terms
All domestic Standard shipments are distributed from our warehouses by OSM, then handed off to the USPS for final delivery.
2-Day Shipping is delivered by FedEx, which does not deliver to PO boxes.
International shipments are tendered to the local postal service in the destination country for final delivery – We do not use courier services for international deliveries.