Hurtig levering
Fremragende Trustpilot
Op til 20% Rabat på nye medlemsordrer
Kurv
Expert T-SQL Window Functions in SQL Server 2019
Af: Clayton Groom, Kathi Kellenberger, Ed Pollack Engelsk Paperback
SPAR
kr 117
Expert T-SQL Window Functions in SQL Server 2019
Af: Clayton Groom, Kathi Kellenberger, Ed Pollack Engelsk Paperback
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.

Eksklusiv medlemspris 446 kr
Medlemspris 458 kr
Eksklusiv medlemspris og medlemspris er kun for medlemmer. Du bliver automatisk medlem når du køber til eksklusiv medlemspris eller medlemspris. Få 7 dages gratis medlemskab (herefter automatisk 89 kr/30 dage). Læs mere om fordelene
Gratis fragt
23 - 25 hverdage
10 kr
Lavt pakkegebyr
Normalpris 563 kr
Fragt: 59 kr
23 - 25 hverdage
20 kr
Pakkegebyr
Spar 117 kr
Se vores konkurrenters priser her
God 15.838 anmeldelser på
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.

Produktdetaljer
Sprog: Engelsk
Sider: 213
ISBN-13: 9781484251966
Indbinding: Paperback
Udgave:
ISBN-10: 1484251962
Udg. Dato: 22 okt 2019
Længde: 17mm
Bredde: 176mm
Højde: 254mm
Oplagsdato: 22 okt 2019
Forfatter(e) Clayton Groom, Kathi Kellenberger, Ed Pollack


Kategori Programmering: Microsoft


Sprog Engelsk


Indbinding Paperback


Sider 213


Udgave


Længde 17mm


Bredde 176mm


Højde 254mm

MEDLEMSFORDELE
GRATIS FRAGT
SPAR OP TIL 90%
Andre har også købt
BOG (HÆFTET)
Eksklusiv medlemspris kr 189

kr 280
Normalpris
kr 198
Medlemspris
SPAR
kr 91
BOG (INDBUNDET)
Eksklusiv medlemspris kr 380

kr 499
Normalpris
kr 392
Medlemspris
SPAR
kr 119
BOG (INDBUNDET)
Eksklusiv medlemspris kr 220

kr 320
Normalpris
kr 230
Medlemspris
SPAR
kr 100
BOG (INDBUNDET)
Eksklusiv medlemspris kr 183

kr 270
Normalpris
kr 192
Medlemspris
SPAR
kr 87
BOG (INDBUNDET)
Eksklusiv medlemspris kr 208

kr 299
Normalpris
kr 217
Medlemspris
SPAR
kr 91
BOG (INDBUNDET)
Eksklusiv medlemspris kr 214

kr 320
Normalpris
kr 225
Medlemspris
SPAR
kr 106
BOG (INDBUNDET)
Eksklusiv medlemspris kr 329

kr 499
Normalpris
kr 346
Medlemspris
SPAR
kr 170
BOG (INDBUNDET)
Eksklusiv medlemspris kr 919

kr 1.499
Normalpris
kr 977
Medlemspris
SPAR
kr 580
BOG (HÆFTET)
Eksklusiv medlemspris kr 154

kr 229
Normalpris
kr 162
Medlemspris
SPAR
kr 75
BOG (HÆFTET)
Eksklusiv medlemspris kr 154

kr 229
Normalpris
kr 162
Medlemspris
SPAR
kr 75
BOG (HÆFTET)
Eksklusiv medlemspris kr 27

kr 227
Normalpris
kr 47
Medlemspris
SPAR
kr 200
BOG (INDBUNDET)
Eksklusiv medlemspris kr 203

kr 300
Normalpris
kr 213
Medlemspris
SPAR
kr 97
BOG (PAPERBACK)
Eksklusiv medlemspris kr 166

kr 201
Normalpris
kr 170
Medlemspris
SPAR
kr 35
BOG (HARDBACK)
Eksklusiv medlemspris kr 25

kr 227
Normalpris
kr 45
Medlemspris
SPAR
kr 202
BOG (HÆFTET)
Eksklusiv medlemspris kr 199

kr 300
Normalpris
kr 209
Medlemspris
SPAR
kr 101
BOG (HÆFTET)
Eksklusiv medlemspris kr 80

kr 229
Normalpris
kr 95
Medlemspris
SPAR
kr 149
BOG (INDBUNDET)
Eksklusiv medlemspris kr 239

kr 329
Normalpris
kr 248
Medlemspris
SPAR
kr 90
BOG (INDBUNDET)
Eksklusiv medlemspris kr 132

kr 149
Normalpris
kr 134
Medlemspris
SPAR
kr 17
BOG (INDBUNDET)
Eksklusiv medlemspris kr 199

kr 300
Normalpris
kr 209
Medlemspris
SPAR
kr 101
BOG (INDBUNDET)
Eksklusiv medlemspris kr 183

kr 270
Normalpris
kr 192
Medlemspris
SPAR
kr 87
Vi anbefaler også
BOG (PAPERBACK)
Eksklusiv medlemspris kr 446

kr 563
Normalpris
kr 458
Medlemspris
SPAR
kr 117
BOG (PAPERBACK)
Eksklusiv medlemspris kr 485

kr 619
Normalpris
kr 498
Medlemspris
SPAR
kr 134
BOG (PAPERBACK)
Eksklusiv medlemspris kr 372

kr 427
Normalpris
kr 378
Medlemspris
SPAR
kr 55
BOG (PAPERBACK)
Eksklusiv medlemspris kr 367

kr 450
Normalpris
kr 375
Medlemspris
SPAR
kr 83
BOG (PAPERBACK)
Eksklusiv medlemspris kr 249

kr 450
Normalpris
kr 269
Medlemspris
SPAR
kr 201
BOG (PAPERBACK)
Eksklusiv medlemspris kr 407

kr 506
Normalpris
kr 417
Medlemspris
SPAR
kr 99
BOG (PAPERBACK)
Eksklusiv medlemspris kr 367

kr 450
Normalpris
kr 375
Medlemspris
SPAR
kr 83
BOG (PAPERBACK)
Eksklusiv medlemspris kr 323

kr 619
Normalpris
kr 353
Medlemspris
SPAR
kr 296
BOG (PAPERBACK)
Eksklusiv medlemspris kr 354

kr 534
Normalpris
kr 372
Medlemspris
SPAR
kr 180
BOG (PAPERBACK)
Eksklusiv medlemspris kr 446

kr 563
Normalpris
kr 458
Medlemspris
SPAR
kr 117
BOG (PAPERBACK)
Eksklusiv medlemspris kr 331

kr 495
Normalpris
kr 347
Medlemspris
SPAR
kr 164
BOG (PAPERBACK)
Eksklusiv medlemspris kr 265

kr 337
Normalpris
kr 272
Medlemspris
SPAR
kr 72
BOG (PAPERBACK)
Eksklusiv medlemspris kr 223

kr 303
Normalpris
kr 231
Medlemspris
SPAR
kr 80
BOG (PAPERBACK)
Eksklusiv medlemspris kr 306

kr 450
Normalpris
kr 320
Medlemspris
SPAR
kr 144
BOG (PAPERBACK)
Eksklusiv medlemspris kr 325

kr 484
Normalpris
kr 341
Medlemspris
SPAR
kr 159
BOG (PAPERBACK)
Eksklusiv medlemspris kr 446

kr 563
Normalpris
kr 458
Medlemspris
SPAR
kr 117
BOG (PAPERBACK)
Eksklusiv medlemspris kr 446

kr 563
Normalpris
kr 458
Medlemspris
SPAR
kr 117
BOG (PAPERBACK)
Eksklusiv medlemspris kr 372

kr 506
Normalpris
kr 385
Medlemspris
SPAR
kr 134
BOG (PAPERBACK)
Eksklusiv medlemspris kr 407

kr 506
Normalpris
kr 417
Medlemspris
SPAR
kr 99
BOG (PAPERBACK)
Eksklusiv medlemspris kr 485

kr 619
Normalpris
kr 498
Medlemspris
SPAR
kr 134