SQL Window Functions Explained
Format:
Paperback
En stock
0.60 kg
Sí
Nuevo
Amazon
USA
- Window functions are probably the most confusing part of SQL. You might think, "So what? They just added a few extra functions". Not really. "Window functions" is a separate language built into regular SQL. And it's more complicated than anything you know about SELECTs. This book is a clear and visual introduction to window functions. A step-by-step narrative combined with numerous visuals helps readers understand the material. Fifty-six interactive exercises with solutions ensure that you master window functions in practice. Here is what you will learn:Why and when to use window functions.What a window and a window function are and how to use them.Ranking, offset, aggregation, rolling aggregates, and statistics window functions.Row, group, and range frames.Frame behavior, filtering, and exclusions.Using window functions in financial and product analysis, clustering, and data cleaning. You can use this book with any of the following DBMSs: MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, and Oracle.
IMPORTÁ FACIL
Comprando este producto podrás descontar el IVA con tu número de RUT
NO CONSUME FRANQUICIA
Si tu carrito tiene solo libros o CD’s, no consume franquicia y podés comprar hasta U$S 1000 al año.