Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries
Kellenberger, Kathi; Groom, Clayton; Pollack, Ed
ISBN 10: 1484251962 ISBN 13: 9781484251966
Editorial: Apress, 2019
Nuevos
Encuadernación de tapa blanda
Librería:
Best Price, Torrance, CA, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
Vendedor de AbeBooks desde 30 de agosto de 2024
Este artículo en concreto ya no está disponible.
Descripción
Descripción:
SUPER FAST SHIPPING. N° de ref. del artículo 9781484251966
Sinopsis:
Become an expert who can use window functions to solve T-SQL query problems. Replace slow cursors and self-joins with queries that are easy to write and perform better. This new edition provides expanded examples, including a chapter from the world of sports, and covers the latest performance enhancements through SQL Server 2019.
Window functions are useful in analytics and business intelligence reporting. They came into full blossom with SQL Server 2012, yet they are not as well known and used as often as they ought to be. This group of functions is one of the most notable developments in SQL, and this book shows how every developer and DBA can benefit from their expressive power in solving day-to-day business problems. Once you begin using window functions, such as ROW_NUMBER and LAG, you will discover many ways to use them. You will approach SQL Server queries in a different way, thinking about sets of data instead of individual rows. Your queries will run faster, be easier to write, and easier to deconstruct, maintain, and enhance in the future.
Just knowing and using these functions is not enough. You also need to understand how to tune the queries. Expert T-SQL Window Functions in SQL Server clearly explains how to get the best performance. The book also covers the rare cases when older techniques are the best bet.
What You Will Learn
- Solve complex query problems without cumbersome self-joins that run slowly and are difficult to read
- Create sliding windows in a result set for computing such as running totals and moving averages
- Return aggregate and detail data simultaneously from the same SELECT statement
- Compute lag and lead and other values that access data from multiple rows in a result set
- Understand the OVER clause syntax and how to control the window
- Avoid framing errors that can lead to unexpected results
Who This Book Is For
Anyone who writes T-SQL queries, including database administrators, developers, business analysts, and data scientists. Before reading this book, you should understand how to join tables, write WHERE clauses, and build aggregate queries.
Acerca del autor:
Kathi Kellenberger is a data platform MVP and the editor of Simple-Talk at Redgate Software. She has worked with SQL Server for over 20 years. She is also co-leader of the PASS Women in Technology Virtual Group and an instructor at LaunchCode. In her spare time, Kathi enjoys spending time with family and friends, singing, and cycling.
Clayton Groom is a data warehouse and analytics consultant at Clayton Groom, LLC. He has worked with SQL Server for 25 years. His expertise lies in designing and building data warehouse and analytic solutions on the Microsoft technology stack, including Power BI, SQL Server, Analysis Services, Reporting Services and Excel.
Edward Pollack has over 20 years of experience in database and systems administration and architecture, developing a passion for performance optimization and making things go faster. He has spoken at many SQL Saturdays, 24 Hours of PASS, and PASS Summits, and has coordinated SQL Saturday Albany since its inception in 2014.
"Sobre este título" puede pertenecer a otra edición de este libro.
Detalles bibliográficos
Título: Expert T-SQL Window Functions in SQL Server ...
Editorial: Apress
Año de publicación: 2019
Encuadernación: Encuadernación de tapa blanda
Condición: New
Edición: 2ª Edición
Los mejores resultados en AbeBooks
Imagen de archivo
Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries
Librería: Bookmans, Tucson, AZ, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
paperback. Condición: Good. . Satisfaction 100% guaranteed. Nº de ref. del artículo: mon0002641893
Comprar usado
EUR 13,69
Gastos de envío:
EUR 3,46
A Estados Unidos de America
Cantidad disponible: 1 disponibles
Imagen de archivo
Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries
Librería: HPB-Diamond, Dallas, TX, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
Paperback. Condición: Very Good. Connecting readers with great books since 1972! Used books may not include companion materials, and may have some shelf wear or limited writing. We ship orders daily and Customer Service is our top priority! Nº de ref. del artículo: S_442808406
Comprar usado
EUR 13,70
Gastos de envío:
EUR 3,25
A Estados Unidos de America
Cantidad disponible: 1 disponibles
Imagen del vendedor
Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries
Librería: clickgoodwillbooks, Indianapolis, IN, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
Condición: good. Used - Good: A book that has been read but is in good condition. Very minimal damage to the cover including scuff marks, but no holes or tears. The dust jacket for hard covers may not be included. Binding has minimal wear. The majority of pages are undamaged with minimal creasing or tearing, minimal pencil underlining of text, no highlighting of text, no writing in margins. No missing pages. Nº de ref. del artículo: CSIV.1484251962.G
Comprar usado
EUR 13,75
Gastos de envío:
EUR 3,46
A Estados Unidos de America
Cantidad disponible: 1 disponibles
Imagen de archivo
Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries
Librería: Lakeside Books, Benton Harbor, MI, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
Condición: New. Brand New! Not Overstocks or Low Quality Book Club Editions! Direct From the Publisher! We're not a giant, faceless warehouse organization! We're a small town bookstore that loves books and loves it's customers! Buy from Lakeside Books! Nº de ref. del artículo: OTF-S-9781484251966
Comprar nuevo
EUR 33,11
Gastos de envío:
EUR 3,46
A Estados Unidos de America
Cantidad disponible: Más de 20 disponibles
Imagen del vendedor
Expert T-SQL Window Functions in SQL Server 2019 : The Hidden Secret to Fast Analytic and Reporting Queries
Librería: GreatBookPrices, Columbia, MD, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
Condición: New. Nº de ref. del artículo: 37566990-n
Comprar nuevo
EUR 34,31
Gastos de envío:
EUR 2,29
A Estados Unidos de America
Cantidad disponible: Más de 20 disponibles
Imagen de archivo
Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries
Librería: Lucky's Textbooks, Dallas, TX, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
Condición: New. Nº de ref. del artículo: ABLIING23Mar2716030152247
Comprar nuevo
EUR 36,23
Gastos de envío:
EUR 3,46
A Estados Unidos de America
Cantidad disponible: Más de 20 disponibles
Imagen del vendedor
Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries (Paperback or Softback)
Publicado por
Apress 11/3/2019, 2019
ISBN 10: 1484251962
ISBN 13: 9781484251966
Nuevo
Paperback or Softback
Librería: BargainBookStores, Grand Rapids, MI, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
Paperback or Softback. Condición: New. Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries. Book. Nº de ref. del artículo: BBS-9781484251966
Comprar nuevo
EUR 36,80
Gastos de envío:
GRATIS
A Estados Unidos de America
Cantidad disponible: 5 disponibles
Imagen de archivo
Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries
Librería: Toscana Books, AUSTIN, TX, Estados Unidos de America
Calificación del vendedor: 5 de 5 estrellas
Paperback. Condición: new. Excellent Condition.Excels in customer satisfaction, prompt replies, and quality checks. Nº de ref. del artículo: Scanned1484251962
Comprar nuevo
EUR 37,53
Gastos de envío:
EUR 3,73
A Estados Unidos de America
Cantidad disponible: 1 disponibles
Imagen del vendedor
Expert T-SQL Window Functions in SQL Server 2019 : The Hidden Secret to Fast Analytic and Reporting Queries
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: 37566990
Comprar usado
EUR 40,52
Gastos de envío:
EUR 2,29
A Estados Unidos de America
Cantidad disponible: Más de 20 disponibles
Imagen de archivo
Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries
Librería: AwesomeBooks, Wallingford, Reino Unido
Calificación del vendedor: 5 de 5 estrellas
paperback. Condición: Very Good. Expert T-SQL Window Functions in SQL Server 2019: The Hidden Secret to Fast Analytic and Reporting Queries This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Nº de ref. del artículo: 7719-9781484251966
Comprar usado
EUR 46,43
Gastos de envío:
EUR 5,66
De Reino Unido a Estados Unidos de America
Cantidad disponible: 2 disponibles