Zum Hauptinhalt springen Zur Suche springen Zur Hauptnavigation springen
Dekorationsartikel gehören nicht zum Leistungsumfang.
T-SQL Window Functions: For data analysis and beyond
Taschenbuch von Itzik Ben-Gan
Sprache: Englisch

32,30 €*

inkl. MwSt.

Versandkostenfrei per Post / DHL

Lieferzeit 2-4 Werktage

Produkt Anzahl: Gib den gewünschten Wert ein oder benutze die Schaltflächen um die Anzahl zu erhöhen oder zu reduzieren.
Kategorien:
Beschreibung
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.
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.
Über den Autor
TZIK BEN-GAN is a mentor with and co-founder of SolidQ. A Microsoft Data Platform MVP since 1999, Itzik has taught numerous training events around the world focused on T-SQL querying, query tuning, and programming. Itzik is the author of several books about T-SQL. He has written many articles for SQL Server Pro as well as articles and white papers for MSDN and The SolidQ Journal. Itzik’s speaking engagements include Tech-Ed, SQL PASS, SQL Server Connections, presentations to various SQL Server user groups, and SolidQ [...] is a subject-matter expert within SolidQ for its T-SQL related activities. He authored SolidQ’s Advanced T-SQL and T-SQL Fundamentals courses and delivers them regularly worldwide. You can learn more about Itzik at [...]
Inhaltsverzeichnis
  • Chapter 01: SQL Windowing
  • Chapter 02: A Detailed Look at Window Functions
  • Chapter 03: Ordered Set Functions
  • Chapter 04: Row Pattern Recognition in SQL
  • Chapter 05: Optimization of Window Functions
  • Chapter 06: T-SQL Solutions using Window Functions
Details
Erscheinungsjahr: 2019
Fachbereich: Datenkommunikation, Netze & Mailboxen
Genre: Importe, Informatik
Rubrik: Naturwissenschaften & Technik
Medium: Taschenbuch
Inhalt: Kartoniert / Broschiert
ISBN-13: 9780135861448
ISBN-10: 0135861446
Sprache: Englisch
Einband: Kartoniert / Broschiert
Autor: Ben-Gan, Itzik
Auflage: 2. Auflage
Hersteller: Microsoft Press
Verantwortliche Person für die EU: Pearson, St.-Martin-Str. 82, D-81541 München, salesde@pearson.com
Maße: 232 x 187 x 20 mm
Von/Mit: Itzik Ben-Gan
Erscheinungsdatum: 04.11.2019
Gewicht: 0,636 kg
Artikel-ID: 116905180
Über den Autor
TZIK BEN-GAN is a mentor with and co-founder of SolidQ. A Microsoft Data Platform MVP since 1999, Itzik has taught numerous training events around the world focused on T-SQL querying, query tuning, and programming. Itzik is the author of several books about T-SQL. He has written many articles for SQL Server Pro as well as articles and white papers for MSDN and The SolidQ Journal. Itzik’s speaking engagements include Tech-Ed, SQL PASS, SQL Server Connections, presentations to various SQL Server user groups, and SolidQ [...] is a subject-matter expert within SolidQ for its T-SQL related activities. He authored SolidQ’s Advanced T-SQL and T-SQL Fundamentals courses and delivers them regularly worldwide. You can learn more about Itzik at [...]
Inhaltsverzeichnis
  • Chapter 01: SQL Windowing
  • Chapter 02: A Detailed Look at Window Functions
  • Chapter 03: Ordered Set Functions
  • Chapter 04: Row Pattern Recognition in SQL
  • Chapter 05: Optimization of Window Functions
  • Chapter 06: T-SQL Solutions using Window Functions
Details
Erscheinungsjahr: 2019
Fachbereich: Datenkommunikation, Netze & Mailboxen
Genre: Importe, Informatik
Rubrik: Naturwissenschaften & Technik
Medium: Taschenbuch
Inhalt: Kartoniert / Broschiert
ISBN-13: 9780135861448
ISBN-10: 0135861446
Sprache: Englisch
Einband: Kartoniert / Broschiert
Autor: Ben-Gan, Itzik
Auflage: 2. Auflage
Hersteller: Microsoft Press
Verantwortliche Person für die EU: Pearson, St.-Martin-Str. 82, D-81541 München, salesde@pearson.com
Maße: 232 x 187 x 20 mm
Von/Mit: Itzik Ben-Gan
Erscheinungsdatum: 04.11.2019
Gewicht: 0,636 kg
Artikel-ID: 116905180
Sicherheitshinweis

Ähnliche Produkte

Ähnliche Produkte