Zur Startseite gehen
0,00 €*
Cover: 9780135861448 | T-SQL Window Functions | For data analysis and beyond | Itzik Ben-Gan
Dekorationsartikel gehören nicht zum Leistungsumfang.
T-SQL Window Functions
For data analysis and beyond
Taschenbuch von Itzik Ben-Gan
Sprache: Englisch

38,25 €*

inkl. MwSt.

Versandkostenfrei per Post / DHL

Lieferzeit 1-2 Wochen

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

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 [...], 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.

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: Programmiersprachen
Genre: Informatik
Rubrik: Naturwissenschaften & Technik
Medium: Taschenbuch
Seiten: 352
Inhalt: Kartoniert / Broschiert
ISBN-13: 9780135861448
ISBN-10: 0135861446
Sprache: Englisch
Einband: Kartoniert / Broschiert
Autor: Ben-Gan, Itzik
Hersteller: Pearson Education (US)
Maße: 231 x 184 x 20 mm
Von/Mit: Itzik Ben-Gan
Erscheinungsdatum: 02.12.2019
Gewicht: 0,584 kg
preigu-id: 116905180
Über den 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 [...], 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.

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: Programmiersprachen
Genre: Informatik
Rubrik: Naturwissenschaften & Technik
Medium: Taschenbuch
Seiten: 352
Inhalt: Kartoniert / Broschiert
ISBN-13: 9780135861448
ISBN-10: 0135861446
Sprache: Englisch
Einband: Kartoniert / Broschiert
Autor: Ben-Gan, Itzik
Hersteller: Pearson Education (US)
Maße: 231 x 184 x 20 mm
Von/Mit: Itzik Ben-Gan
Erscheinungsdatum: 02.12.2019
Gewicht: 0,584 kg
preigu-id: 116905180
Warnhinweis

Ähnliche Produkte

Ähnliche Produkte

Taschenbuch
Cover: 9780393955446 | Common Lispcraft | Robert Wilensky | Taschenbuch | Paperback | 1986
Common Lispcraft
EAN: 9780393955446
Sprache: Englisch
Von/Mit: Robert Wilensky

82,45 €*

Lieferzeit 4-7 Werktage

Taschenbuch
Cover: 9780596521189 | Using SQLite | Jay A. Kreibich | Taschenbuch | Englisch | 2010
Using SQLite
EAN: 9780596521189
Sprache: Englisch
Von/Mit: Jay A. Kreibich

46,45 €*

Lieferzeit 1-2 Wochen

Taschenbuch
Cover: 9781509302000 | T-SQL Fundamentals | Itzik Ben-Gan | Taschenbuch | Englisch | 2016
T-SQL Fundamentals
EAN: 9781509302000
Sprache: Englisch
Von/Mit: Itzik Ben-Gan

45,30 €*

Lieferzeit 1-2 Wochen

Taschenbuch
Cover: 9783848258239 | Ein strukturierter Einstieg in die Oracle SQL und PL/SQL-Entwicklung
Ein strukturierter Einstieg in die Oracle SQL und PL/SQL-Entwicklung
EAN: 9783848258239
Sprache: Deutsch
Von/Mit: Marek Adar

29,90 €*

Lieferzeit 1-2 Werktage

Taschenbuch
Cover: 9781492080510 | High Performance MySQL | Proven Strategies for Running MySQL at Scale
High Performance MySQL
Proven Strategies for Running MySQL at Scale
EAN: 9781492080510
Sprache: Englisch
Von/Mit: Silvia Botros (u. a.)

58,90 €*

Lieferzeit 1-2 Wochen

Taschenbuch
Cover: 9781098101923 | SQL Server Advanced Troubleshooting and Performance Tuning | Buch
SQL Server Advanced Troubleshooting and Performance Tuning
Best Practices and Techniques
EAN: 9781098101923
Sprache: Englisch
Von/Mit: Dmitri Korotkevitch

69,45 €*

Lieferzeit 1-2 Wochen

Taschenbuch
Cover: 9781098103828 | Snowflake - The Definitive Guide | Joyce Kay Avila | Taschenbuch
Snowflake - The Definitive Guide
Architecting, Designing, and Deploying on the Snowflake Data Cloud
EAN: 9781098103828
Von/Mit: Joyce Kay Avila

69,45 €*

Lieferzeit 1-2 Wochen

Buch
Cover: 9783836296304 | Oracle PL/SQL | Jürgen Sieben | Buch | Rheinwerk Computing | 1090 S.
Oracle PL/SQL
Das umfassende Handbuch für Datenbankentwickler. Aktuell zu Oracle 19c und 21c
EAN: 9783836296304
Sprache: Deutsch
Von/Mit: Jürgen Sieben

89,90 €*

Lieferzeit 1-2 Werktage

Taschenbuch
Cover: 9781484296844 | Leveling Up with SQL | Mark Simon | Taschenbuch | Paperback | xx
Leveling Up with SQL
Advanced Techniques for Transforming Data into Insights
EAN: 9781484296844
Sprache: Englisch
Von/Mit: Mark Simon

45,95 €*

Lieferzeit 4-7 Werktage

Taschenbuch
Cover: 9781835086315 | Web App Development Made Simple with Streamlit | Rosario Moscato
Web App Development Made Simple with Streamlit
A web developer's guide to effortless web app development, deployment, and scalability
EAN: 9781835086315
Sprache: Englisch
Von/Mit: Rosario Moscato

75,85 €*

Lieferzeit 4-7 Werktage

Diese Website verwendet Cookies, um eine bestmögliche Erfahrung bieten zu können. Mehr Informationen ...