undrgrnd Cliquez ici Toys KDP Cloud Drive Photos cliquez_ici Rentrée scolaire Cliquez ici Acheter Fire Shop Kindle cliquez_ici Jeux Vidéo Bijoux Montres Montres boutique Tendance
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

Désolé, cet article n'est pas disponible en
Image non disponible pour la
couleur :
Image non disponible

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

Joe Celko

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

App de lecture Kindle gratuite 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.

Pour obtenir l'appli gratuite, saisissez votre adresse e-mail ou numéro de téléphone mobile.


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

Les clients ayant acheté cet article ont également acheté

Cette fonction d'achat continuera à charger les articles. Pour naviguer hors de ce carrousel, veuillez utiliser votre touche de raccourci d'en-tête pour naviguer vers l'en-tête précédente ou suivante.

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 :
  • Word Wise: Non activé
  • Composition améliorée: Non activé
  • Classement des meilleures ventes d'Amazon: n°217.819 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.5 étoiles sur 5  16 commentaires
7 internautes sur 7 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.
5 internautes sur 5 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 Frobisher - 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.
2 internautes sur 2 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 This book contains a clear presentation of the representation of graphs and hierarchical data in SQL based databases 16 avril 2012
Par Patrick Regan - Publié sur Amazon.com
Format:Broché|Commentaire client Vine pour produit gratuit (De quoi s'agit-il?)
This book is about the representation of hierarchical data in SQL. On the surface, SQL does not lend itself directly to representation of hierarchal data due to the fact that it is set oriented. Yet hierarchal data is used frequently to relate things in the real world. For example, a employee hierarchy is used to represent who is subordinate to whom and hierarchies are used for the creation of products with a large amount of parts, for example, in a car, a dashboard of the car contains a speedometer, a radio and a glove compartment, each of which can be represented by a hierarchy in which the parts of the dashboard are represented as being contained in the dashboard. This book discusses the various ways in which database designers have addressed this problem. There are many ways to represent hierarchical data in a SQL and each chapter of this book is devoted to the details of one particular solution. Due to the fact that this is a pretty advanced subject, I was surprised that I was able to follow this book with my intermediate knowledge of SQL. There is little need to know advanced features of SQL such as triggers and things like that, in fact if you can create tables, including all the details inherent in them, and do transformations on them (insertion, deletion, etc) I think you will be able to understand this book. If you are a beginner at SQL, you could get the author's book called "Joe Celko's SQL for Smarties" which will give you enough information to read this book.
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 Amazon Customer - 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
Première publication:
Aller s'identifier

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

Rechercher des articles similaires par rubrique