| ||||||||||||||||||||||||
Produits fréquemment achetés ensemble
Descriptions du produit
Amazon.com
Although Celko denies that the book is about database theory, he nevertheless alludes to theory often to buttress his practical points. This title is not for novices, as the author points out. Instead, its intended audience is SQL programmers with at least a year's experience. The book maintains a fine balance between technical discussion and practical explanation--picking hot topics and offering advice on a wide range of issues.
The book uses ANSI SQL-89 as its baseline standard, with some mention of SQL-92 features. It does not, however, focus on any commercial product; this guide zeroes in on the SQL language. Celko covers all aspects of database design, optimization, and manipulation, with easy-to-understand explanations of key issues such as why not to use too many nulls, how to use practical normalization, and how to optimize queries.
This insightful text is manna for all the day-to-day SQL coders banging their heads over the language's subtle challenges. --Stephen W. Plain
Topics covered: Database design and normalization, SQL data types, querying, grouping, set operations, optimization, data scaling, and encoding. --Ce texte fait référence à lédition Broché .
Book Description
SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques you need to transform yourself into an expert SQL programmer. Now, in this fully updated second edition, SQL mastermind Joe Celko keeps you moving forward, using his entertaining, conversational style to teach you the best solutions to old and new challenges and to convey the way you need to think if you really want to get the most out of your SQL programming efforts.
Inside, logic- and set-based analyses replace the traditional, procedural approach to problem-solving, helping you make the conceptual leap that separates an SQL guru from the rest of the pack. As you catch on to Celko's approach, you'll devour what he has to say about some of SQL's toughest topics: how aggregate functions really work, the best way to work with NULLs, how and why to fake array structures, and much more.
This book gives special emphasis to SQL-92 and product-independent techniques that let you optimize performance or achieve highly specialized behavior, regardless of the RDBMS with which you work. If you're serious about SQL, you won't let SQL for Smarties out of your sight.
* Presents all-new war stories that give you insight into real-world SQL programming challenges.
* Continues to cover SQL-89 but focuses heavily on the SQL-92 standard.
* Offers still more undocumented tips for working around system deficiencies.
* Teaches scores of advanced techniques that can be used with any product, in any SQL environment.
* Offers expert advice from a noted SQL authority and award-winning columnist. --Ce texte fait référence à une édition épuisée ou non disponible de ce titre.
Détails sur le produit
Souhaitez-vous compléter ou améliorer les informations sur ce produit ? Ou faire modifier les images?
|
En savoir plus sur l'auteur
› Consultez la page Joe Celko d'Amazon
Associer des mots-clés à ce produit(De quoi s'agit-il ?)Considérez votre mot-clé comme une sorte d'étiquette définissant parfaitement ce produit.
Les mots-clés aident les clients à organiser et trouver leurs articles favoris. |
Commentaires en ligne
|
Il n'y a pour l'instant aucun commentaire client.
|
|||
|
Commentaires vidéo
|
Listmania!
Rechercher des articles similaires par rubrique
Rechercher des articles similaires par thème
Commentaires
|
