Commencez à lire Joe Celko's SQL for Smarties: Advanced SQL Programming 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 SQL for Smarties: Advanced SQL Programming [Format Kindle]

Joe Celko

Prix conseillé : EUR 49,53 De quoi s'agit-il ?
Prix éditeur - format imprimé : EUR 51,64
Prix Kindle : EUR 34,67 TTC & envoi gratuit via réseau sans fil par Amazon Whispernet
Économisez : EUR 16,97 (33%)

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 34,67  
Broché EUR 51,64  

Descriptions du produit

Revue de presse

"If you work with SQL in any way, shape, or form, the most recent edition of Joe Celko's SQL for Smarties needs to be on your bookshelf!"--Data Technology Today Blog

Présentation de l'éditeur

Joe Celkos SQL for Smarties: Advanced SQL Programming offers tips and techniques in advanced programming. This book is the fourth edition and it consists of 39 chapters, starting with a comparison between databases and file systems. It covers transactions and currency control, schema level objects, locating data and schema numbers, base tables, and auxiliary tables. Furthermore, procedural, semi-procedural, and declarative programming are explored in this book.
The book also presents the different normal forms in database normalization, including the first, second, third, fourth, fifth, elementary key, domain-key, and Boyce-Codd normal forms. It also offers practical hints for normalization and denormalization. The book discusses different data types, such as the numeric, temporal and character data types; the different predicates; and the simple and advanced SELECT statements. In addition, the book presents virtual tables, and it discusses data partitions in queries; grouping operations; simple aggregate functions; and descriptive statistics, matrices and graphs in SQL. The book concludes with a discussion about optimizing SQL. It will be of great value to SQL programmers.


  • Expert advice from a noted SQL authority and award-winning columnist who has given ten years service to the ANSI SQL standards committee
  • Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL 92 or SQL 2008 environment
  • Offers tips for working around deficiencies and gives insight into real-world challenges

Détails sur le produit

  • Format : Format Kindle
  • Taille du fichier : 2625 KB
  • Nombre de pages de l'édition imprimée : 816 pages
  • Editeur : Morgan Kaufmann; Édition : 4 (22 novembre 2010)
  • Vendu par : Amazon Media EU S.à r.l.
  • Langue : Anglais
  • ASIN: B0050P497U
  • Synthèse vocale : Activée
  • X-Ray :
  • Word Wise: Non activé
  • Classement des meilleures ventes d'Amazon: n°252.753 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
5 étoiles
4 étoiles
3 étoiles
2 étoiles
1 étoiles
Commentaires client les plus utiles sur (beta) 4.2 étoiles sur 5  23 commentaires
10 internautes sur 10 ont trouvé ce commentaire utile 
3.0 étoiles sur 5 Some good coverage of advanced topics, with some issues 21 juillet 2012
Par King B - Publié sur
Format:Broché|Commentaire client Vine pour produit gratuit (De quoi s'agit-il?)
This book attempts to go over some advanced topics in SQL programming. While it succeeds in showing these concepts, the main issue is that the implementations are too generic and don't work in every implementation of SQL. It would be nice to see a table or indication of some sort that shows if the topic discussed works in an individual implementation of SQL. As I read a section that sounded great, I would test it out in Microsoft SQL server only to find that it was not supported. It would be nice to know if what was discussed was available in any SQL implementation or if it was only part of the ANSI SQL XX standards. He talks to SQL-92 standards that he says are not implemented in many (or any!) database engine... That does not help.
For the items that are applicable, they are so specific, I can't image any time that I would need them. For example matrix multiplication and graph theory.
On the advanced topics, the real good ones are covered in more detail in his other books. I would recommend Joe Celko's Trees and Hierarchies which goes into more detail from the trees section in this book.
Overall, I'm glad I reviewed this book, but I would like to see a language specific version that provided working examples.
6 internautes sur 6 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Celko Rules! 6 décembre 2010
Par Darwin's Bulldog - Publié sur
Format:Broché|Commentaire client Vine pour produit gratuit (De quoi s'agit-il?)
I learned SQL from the first edition of this book, many years ago. Some of the material covered in that edition has been moved to different books and this basically reflects the emergence of SQl as the lingua franca of databases and the burgeoning demands placed on developers. So in some cases, the reader may have to look at other texts for specific coverage of items sch as Trees and Heirarchies.

What I have always liked about Joe Celko's books is that once you start reading, it's hard to stop. He likes to explain why the SQL standards are written the way they are, often including why SQL databases are not as portable as might be expected. Since his books are not vendor specific, he can provide tips and hints, and in some cases what NOT to do, for several of the main vendors. There is much pedigogy presented; perhaps not always of direct value, but certainly interesting.

Joe lays a substantial foundation about data types, NULLS, implementation and the set theory basis of SQL. In fact the basic SELECT statement does not even get detailed attention until Chapter 24. But remember, this is a book for 'Smarties' and many of the difficulties of getting SQL to return specific result sets are presented in earlier chapters. Some familiarity with the language will be required.

After Chapter 24, the examples are many and the number of data retreival issues covered many: simple aggregates, OLAP, statistics, matrices, UNIONs, graphs, temporal queries, and optimization (even FoxPro gets a tip of the hat for speed).

Highly recommended!
6 internautes sur 6 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Superb Development 15 décembre 2010
Par Santeria - Publié sur
Format:Broché|Commentaire client Vine pour produit gratuit (De quoi s'agit-il?)
After Learning the Basics of SQL as well as the admin side of Oracle SQL, the knowledge of how far SQL has developed in terms of being a language that gets data from one person to another, is quite an amazing piece of work, and the glitz for most people who see the result is in the User Interface, since they never see the hard work that goes on underneath the main part of an SQL data machine.
This book takes you through Tables as entities, tables as relationships, and the idea of Rows versus records.In the "great Schema" of things, Transactions and concurrency control is explained and illustrated in detail.Coming from the detail of Schema level Objects to the various types of Tables and the language issues from the earliest SQL to the later XML forms, it is all illustrated in this book for those who wish to work with the Core Essential that is SQL.
5 internautes sur 5 ont trouvé ce commentaire utile 
3.0 étoiles sur 5 Great Content Horribly Written 9 août 2013
Par Amazon Customer - Publié sur
Format:Format Kindle|Achat vérifié
This book has some fantastic information in it on how to properly write SQL code, especially from the perspective of a programmer in a structured language. The major glaring problem with the book is its editing. There are typos everywhere, many of them in code examples, which breaks them. Additionally large portions of the text are copied from chapter to chapter, probably making up 5% of the book. This seems lazy and also makes the book more confusing as you get a nagging feeling of deja vu. With a good editor this book might be worth 5 stars. As it is the book is only 3, causing a lot of confusion and problems where there shouldn't be any.
4 internautes sur 4 ont trouvé ce commentaire utile 
4.0 étoiles sur 5 Some new material, But Not Enough To Pay for New Versus Older Editions 3 décembre 2010
Par William B. Dwinnell IV - Publié sur
Format:Broché|Commentaire client Vine pour produit gratuit (De quoi s'agit-il?)
By now, Joe Celko's books have become SQL programming standards. This title, "SQL for Smarties" is now in its 4th edition, and covers a wide mix of things a SQL programmer would want to know about, after learning the basics of SELECT..WHERE, such as date/time math, advanced queries, and odds and ends like calculating medians across records.

With books like "SQL for Smarties", which have been around long enough, readers have the choice of paying for the newest edition or saving their money by buying an older edition. I happen to own the second edition, and I notice that material from that edition has been re-arranged, and several new chapters have been introduced. Unless one requires something available only in the latest edition, I recommend finding an older edition.

To put this review in context, I have many years of experience writing in procedural programming languages, but only occasionally develop SQL code.
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