- Gratuit : téléchargez l'application Amazon pour iPhone, iPad, Android ou Windows Phone ou découvrez la nouvelle application Amazon pour Tablette Android !
- Outlet Anciennes collections, fin de séries, articles commandés en trop grande quantité, … découvrez notre sélection de produits à petits prix Profitez-en !
- Plus de 10 000 ebooks indés à moins de 3 euros à télécharger en moins de 60 secondes .
SQL Performance Explained (Anglais) Broché – 2012
|Neuf à partir de||Occasion à partir de|
Offres spéciales et liens associés
Les clients ayant acheté cet article ont également acheté
Quels sont les autres articles que les clients achètent après avoir regardé cet article?
Description du produit
SQL Performance Explained helps developers to improve database performance. The focus is on SQL-it covers all major SQL databases without getting lost in the details of any one specific product.
Starting with the basics of indexing and the WHERE clause, SQL Performance Explained guides developers through all parts of an SQL statement and explains the pitfalls of object-relational mapping (ORM) tools like Hibernate.
Topics covered include:
• Using multi-column indexes
• Correctly applying SQL functions
• Efficient use of LIKE queries
• Optimizing join operations
• Clustering data to improve performance
• Pipelined execution of ORDER BY and GROUP BY
• Getting the best performance for pagination queries
• Understanding the scalability of databases
Its systematic structure makes SQL Performance Explained both a textbook and a reference manual that should be on every developer's bookshelf.
Covers all major databases: Oracle® Database, SQL Server®, PostgreSQL, MySQL
What readers say:
"This book is definitively worth having in the company library." - Joe Celko
Aucun appareil Kindle n'est requis. Téléchargez l'une des applis Kindle gratuites et commencez à lire les livres Kindle sur votre smartphone, tablette ou ordinateur.
Pour obtenir l'appli gratuite, saisissez votre numéro de téléphone mobile.
Détails sur le produit
Si vous vendez ce produit, souhaitez-vous suggérer des mises à jour par l'intermédiaire du support vendeur ?
Meilleurs commentaires des clients
Commentaires client les plus utiles sur Amazon.com
Optimizing SQL, writing performant queries, is something that every developer dealing with databases ought to know how to do but it is not something taught in any SQL class I've seen or, if it is, it's always either taught steeped in an RDBMS-specific way that makes the knowledge difficult to apply to other databases or so academically that it's hard to know how any of it applies. This book covers SQL in general but, importantly, makes it concrete by providing examples in *multiple* popular databases. It also takes the time to explain peculiarities of different implementations, by which I mostly mean Oracle, which is something all general SQL tutorials seem to avoid.
Although nothing in here was a revelation to me for a lot of people it will be, and even I found nuggets of usefulness despite having a decade of experience in database performance tuning. This book lays out in simple, clear terms the things you need to know and is written in sufficiently non-arcane language that even an entry level developer should be able to follow it. I am certainly going to use this book as my way of explaining query optimization to all future developers I must teach, because it expresses these ideas far more lucidly than I have been able to manage.
5/5, would gather statistics again
Highly recommended if you don’t have a copy. This book *must* be able to help any database developer except those that already have vast amounts of knowledge of how indexes are implemented and what the implications on performance are. It’s like taking all the grey areas that have “just worked” for the past ten years and lifting the fog off it to see what’s actually lurking behind there, and it also opens the gateways to a whole new study focus that have been very difficult to obtain previously due to lack of solid concept to work from.
Definitely Book of the Year for me, I think (I’d be more than happy to have it topped before the year’s up).