Commencez à lire Joe Celko's Trees and Hierarchies in SQL for Smarties sur votre Kindle dans moins d'une minute. Vous n'avez pas encore de Kindle ? Achetez-le ici Ou commencez à lire dès maintenant avec l'une de nos applications de lecture Kindle gratuites.

Envoyer sur votre Kindle ou un autre appareil

 
 
 

Essai gratuit

Découvrez gratuitement un extrait de ce titre

Envoyer sur votre Kindle ou un autre appareil

Tout le monde peut lire les livres Kindle, même sans un appareil Kindle, grâce à l'appli Kindle GRATUITE pour les smartphones, les tablettes et les ordinateurs.
Joe Celko's Trees and Hierarchies in SQL for Smarties
 
Agrandissez cette image
 

Joe Celko's Trees and Hierarchies in SQL for Smarties [Format Kindle]

Joe Celko

Prix conseillé : EUR 33,94 De quoi s'agit-il ?
Prix éditeur - format imprimé : EUR 34,76
Prix Kindle : EUR 23,76 TTC & envoi gratuit via réseau sans fil par Amazon Whispernet
Économisez : EUR 11,00 (32%)

Formats

Prix Amazon Neuf à partir de Occasion à partir de
Format Kindle EUR 23,76  
Broché EUR 34,76  

Auteurs, publiez directement sur Kindle !

KDP
Via notre service de Publication Directe sur Kindle, publiez vous-même vos livres dans la boutique Kindle d'Amazon. C'est rapide, simple et totalement gratuit.




Descriptions du produit

Présentation de l'éditeur

The demand for SQL information and training continues to grow with the need for a database behind every website capable of offering web-based information queries. SQL is the de facto standard for database retrieval, and if you need to access, update, or utilize data in a modern database management system, you will need SQL to do it. The Second Edition of Joe Celko's Trees and Hierarchies in SQL for Smarties covers two new sets of extensions over three entirely new chapters and expounds upon the changes that have occurred in SQL standards since the previous edition's publication. Benefit from mastering the challenging aspects of these database applications in SQL as taught by Joe Celko, one of the most-read SQL authors in the world.



*Expert advice from a noted SQL authority and award-winning columnist who has given 10 years of service to the ANSI SQL standards committee

*Teaches scores of advanced techniques that can be used with any product, in any SQL environment

*Offers graph theory and programming techniques for working around deficiencies and gives insight into real-world challenges

Biographie de l'auteur

Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards.

Mr. Celko is author a series of books on SQL and RDBMS for Elsevier/MKP. He is an independent consultant based in Austin, Texas.

He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.

Détails sur le produit

  • Format : Format Kindle
  • Taille du fichier : 1107 KB
  • Nombre de pages de l'édition imprimée : 286 pages
  • Pagination - ISBN de l'édition imprimée de référence : 0123877334
  • Editeur : Morgan Kaufmann; Édition : 2 (25 janvier 2012)
  • Vendu par : Amazon Media EU S.à r.l.
  • Langue : Anglais
  • ASIN: B006Y8MKUU
  • Synthèse vocale : Activée
  • X-Ray :
  • Classement des meilleures ventes d'Amazon: n°144.234 dans la Boutique Kindle (Voir le Top 100 dans la Boutique Kindle)
  •  Souhaitez-vous faire modifier les images ?


En savoir plus sur l'auteur

Découvrez des livres, informez-vous sur les écrivains, lisez des blogs d'auteurs et bien plus encore.

Commentaires en ligne 

Il n'y a pas encore de commentaires clients sur Amazon.fr
5 étoiles
4 étoiles
3 étoiles
2 étoiles
1 étoiles
Commentaires client les plus utiles sur Amazon.com (beta)
Amazon.com: 4.4 étoiles sur 5  16 commentaires
4 internautes sur 4 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 If you need this, I don't know of any alternative 17 mars 2012
Par Dave - Publié sur Amazon.com
Format:Broché|Commentaire client Vine pour produit gratuit (De quoi s'agit-il?)
Joe Celko writes well about SQL, and his earlier "SQL for Smarties" is a good book. This one expands what he's done with trees and heirarchies, and does so in a straightforward manner.

There's a limited audience for this book, as many SQL developers just won't need to deal with these data types, or they'll deal with fixed, mixed-type trees (such as Customer->Account->Transactions) in which many of these techniques won't be needed.

Also, some database systems (such as Oracle) have very powerful proprietary SQL dialects that will do obviate the need for much of this - if you are willing to use a DBMS-specific solution. But this book is written in a dialect-agnostic way.

I think the nicest thing about this book is that I've seen really bad table designs created just to avoid having to deal with trees and hierarchies, and this wook should help people avoid that and yet still feel thay will be able to program effectively using those kinds of designs.
3 internautes sur 3 ont trouvé ce commentaire utile 
4.0 étoiles sur 5 This is for Smarties allright! 19 avril 2012
Par Kurt G. Schumacher - Publié sur Amazon.com
Format:Broché|Commentaire client Vine pour produit gratuit (De quoi s'agit-il?)
I thought I knew my SQL, but this book showed me that I have a LOT to learn! SQL stands for Structured Query Language, and my use of the language has always been pretty much limited to "sentences". Select this, update that, delete something. I've even done a few simple procedures ("paragraphs"). And I've done some of the things described in this book ... trees and hierarchies ... in programming languages like PERL with occasional SQL statements.

This book shows how to do those things strictly in SQL. It made me realize that SQL itself can really be a programming language. You can write pretty heavy-duty programs just with SQL. That made my brain hurt!

A lot of the material covered in the book is way more advanced than I can handle right now, and more than I really need. But I've found over and over again that if I say, "I'll never need that," it's only a matter of time until I do need it. And even if I don't need anything as advanced as this, I've already learned a lot about what SQL can do.

I'm going to look up Joe Celko's other SQL books. I need to make my brain hurt some more.
1 internautes sur 1 ont trouvé ce commentaire utile 
4.0 étoiles sur 5 Interesting topic for real life SQL problems 1 juin 2012
Par Philosophically Yours - Publié sur Amazon.com
Format:Broché|Commentaire client Vine pour produit gratuit (De quoi s'agit-il?)
I feel graphs and tree are the core set of data structures used in most of the applications today and historically we have always modeled such network type data in relational databases for storage & retrieval. Naturally, the relational database doesn't fit out of the box to meet all read/aggregated read requirements for such data sets and even seasoned developers struggle to find a good solution to the problem at hand with such data. Joe Celko has attacked this area and described it at length in this book.

The book has 15 chapters to discuss the problems and a few proposed solutions at length. I feel the chapters are simple, easy to read, to the point and are always illustrated with meaningful examples to educate & engage the readers. The book starts with an introduction to the data problems with graph, tree and hierarchies and then discusses common data models to store & read such data and the current problems with such solutions. Further down the line, it discusses about the common real world problems that many data engineers or architect face today and proposes solutions. Finally, there are discussions around graphs in SQL and some specific cases around this area, which are really nice.

I liked the way this book deals with such a specific topic and I liked various ideas proposed through the chapters. This book has a specific set of audience but has very good set of ideas that are very relevant in today's world of data engineering.
1 internautes sur 1 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Easy to read, accurate, lots of interesting solutions 30 avril 2012
Par Gina Pera - Publié sur Amazon.com
Format:Broché|Commentaire client Vine pour produit gratuit (De quoi s'agit-il?)
This review comes from my husband, who actually understands this book's contents:

Joe Celko is my favorite writer when it comes to SQL. He holds true to form
with this book. It's got everything you might want to know about handling
trees in SQL, written in a vendor-independent way. Easy to read, accurate,
lots of interesting solutions. It's so nice I have it in both Kindle *and*
hard-copy form.
1 internautes sur 1 ont trouvé ce commentaire utile 
4.0 étoiles sur 5 Good book for people wanting to learn more about SQL trees and hierarchies 15 mars 2012
Par Luckyclucker - Publié sur Amazon.com
Format:Broché|Commentaire client Vine pour produit gratuit (De quoi s'agit-il?)
Joe Celko has written a very good book on the architecture of trees and hierarchies in sql. That should have gotten the attention of a very limited audience. Yes, this book is not for light reading, it is for people who really need to understand the differences between trees vs hierarchies and how they might be used in database applications. It probably won't leave anyone understanding the whole science but it will help them focus on what they need to build the type of queries and data structures to store.This book is a collection of his articles put together to make some sense for those who need to know this pretty specific information. Does it cover everything. No. Does it go off on tangents. Not really. It does a good job of going over some very deep stuff in a fairly engaging way.
Ces commentaires ont-ils été utiles ?   Dites-le-nous

Discussions entre clients

Le forum concernant ce produit
Discussion Réponses Message le plus récent
Pas de discussions pour l'instant

Posez des questions, partagez votre opinion, gagnez en compréhension
Démarrer une nouvelle discussion
Thème:
Première publication:
Aller s'identifier
 

Rechercher parmi les discussions des clients
Rechercher dans toutes les discussions Amazon
   


Rechercher des articles similaires par rubrique