Artículos relacionados a T-SQL Window Functions: For data analysis and beyond...
Sinopsis
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
"Sinopsis" puede pertenecer a otra edición de este libro.
Acerca del autor
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.
De la contraportada
Use window functions to optimize your T-SQL queries for greater simplicity, elegance, and performance
- Discover the surprising power of window functions, and learn how to use them far more widely
- The most advanced coverage of T-SQL window functions — including new techniques invented by author Itzik Ben-Gan, one of the world’s top T-SQL experts
- Covers T-SQL for all recent versions of Microsoft SQL Server (including 2019) and Microsoft Azure SQL Database — including important new window function optimizations
- Ideal for DBAs, developers, and anyone who uses T-SQL to solve business problems
Most T-SQL developers recognize the value of window functions for data analysis calculation. But window functions can do far more than that, and optimizations in recent versions of SQL Server have made them more powerful than ever. In T-SQL Window Functions: For Data Analysis and Beyond, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using window functions to handle many common T-SQL querying tasks with unprecedented elegance and power.
Ben-Gan first explains why window functions can often be a far better solution than traditional predicate-based approaches. Next, using extensive code examples, he guides you through each type of window function: Aggregate, Ranking, Distribution and Offset. You’ll find detailed coverage of ordered set functions (including SQL Server 2017’s STRING_AGG); plus an extensive section on optimization. The book concludes with roughly 100 pages of real T-SQL solutions using window function approaches — including techniques invented by the author and available in no other book.
"Sobre este título" puede pertenecer a otra edición de este libro.
EUR 29,43
EUR 17,02 gastos de envío desde Estados Unidos de America a España
Destinos, gastos y plazos de envíoComprar nuevo
Ver este artículo
EUR 27,82
EUR 9,09 gastos de envío desde Reino Unido a España
Destinos, gastos y plazos de envíoResultados de la búsqueda para T-SQL Window Functions: For data analysis and beyond...
Imagen de archivo
T-SQL Window Functions: For data analysis and beyond
Publicado por
Pearson Education (US), 2019
ISBN 10: 0135861446
ISBN 13: 9780135861448
Nuevo
Paperback / softback
Librería: THE SAINT BOOKSTORE, Southport, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
Paperback / softback. Condición: New. New copy - Usually dispatched within 2 working days. 700. Nº de ref. del artículo: B9780135861448
Cantidad disponible: 3 disponibles
Imagen de archivo
TSQL WINDOW FUNCTIONS 1E
Librería: Speedyhen, London, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
Condición: NEW. Nº de ref. del artículo: NW9780135861448
Cantidad disponible: 3 disponibles
Imagen de archivo
T-SQL Window Functions
Librería: PBShop.store UK, Fairford, GLOS, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
PAP. Condición: New. New Book. Shipped from UK. Established seller since 2000. Nº de ref. del artículo: GB-9780135861448
Cantidad disponible: 3 disponibles
Imagen de archivo
T-SQL Window Functions
Librería: PBShop.store US, Wood Dale, IL, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
PAP. Condición: New. New Book. Shipped from UK. Established seller since 2000. Nº de ref. del artículo: GB-9780135861448
Cantidad disponible: 3 disponibles
Imagen de archivo
T-SQL Window Functions: For data analysis and beyond (Developer Reference)
Librería: Ria Christie Collections, Uxbridge, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
Condición: New. In. Nº de ref. del artículo: ria9780135861448_new
Cantidad disponible: 3 disponibles
Imagen de archivo
T-SQL Window Functions: For data analysis and beyond (Developer Reference)
Librería: Kennys Bookshop and Art Galleries Ltd., Galway, GY, Irlanda
Calificación del vendedor: 5 de 5 estrellas
Condición: New. 2019. 2nd Edition. Paperback. . . . . . Nº de ref. del artículo: V9780135861448
Cantidad disponible: 3 disponibles
Imagen del vendedor
T-SQL Window Functions : For Data Analysis and Beyond
Librería: GreatBookPricesUK, Woodford Green, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
Condición: New. Nº de ref. del artículo: 35875271-n
Cantidad disponible: 3 disponibles
Imagen de archivo
T-SQL Window Functions (Developer Reference)
Librería: Majestic Books, Hounslow, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
Condición: New. pp. 352. Nº de ref. del artículo: 370692750
Cantidad disponible: 3 disponibles
Imagen de archivo
T-SQL Window Functions: For data analysis and beyond (Developer Reference)
Librería: California Books, Miami, FL, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
Condición: New. Nº de ref. del artículo: I-9780135861448
Cantidad disponible: Más de 20 disponibles
Imagen del vendedor
T-SQL Window Functions : For Data Analysis and Beyond
Publicado por
Microsoft Press, 2019
ISBN 10: 0135861446
ISBN 13: 9780135861448
Antiguo o usado
Tapa blanda
Librería: GreatBookPrices, Columbia, MD, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
Condición: As New. Unread book in perfect condition. Nº de ref. del artículo: 35875271
Cantidad disponible: 2 disponibles