Identifiez-vous pour activer la commande 1-Click.
Plus de choix
Vous l'avez déjà ? Vendez votre exemplaire ici
Désolé, cet article n'est pas disponible en
Image non disponible pour la
couleur :
Image non disponible

Dites-le à l'éditeur :
J'aimerais lire ce livre sur Kindle !

Vous n'avez pas encore de Kindle ? Achetez-le ici ou téléchargez une application de lecture gratuite.

Advanced Oracle SQL Programming: The Expert Guide to Writing Complex Queries [Anglais] [Broché]

Laurent Schneider
4.0 étoiles sur 5  Voir tous les commentaires (2 commentaires client)
Prix : EUR 26,64 LIVRAISON GRATUITE En savoir plus.
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
En stock, mais la livraison peut nécessiter jusqu'à 2 jours supplémentaires.
Expédié et vendu par Amazon. Emballage cadeau disponible.

Description de l'ouvrage

17 novembre 2008 Oracle In-Focus
Oracle SQL is one of the world's most powerful dialects, packed with advanced functions and features that give Oracle SQL procedural language capabilities. Using these powerful features it is no longer necessary to embed Oracle SQL inside a procedural language, and native Oracle SQL can now be used to solve complex query problems. This is an indispensable book for all Oracle DBA's and developers who need to understand how to apply Oracle SQL features for complex queries. Written by a certified Oracle Master and Oracle ACE, this advanced book shows working examples of how to leverage Oracle SQL's powerful built-in functions for fast extraction of complex data and how to use native SQL for procedural processing. Every developer needs to know how to use Oracle SQL to summarize and aggregate data from large tables and how to use powerful features such as the "model" clause to make SQL act as a procedural language. This book shows important techniques on how to leverage Oracle's powerful XML interface to quickly format Oracle data with XML for instant publication. This is not a book for beginners or dilettantes and it is designed for the professional Oracle developer, covering many advanced Oracle SQL techniques including XML queries, Oracle SQL analytics, SQL for aggregation, and traversing Hierarchies. Best of all, the author reveals secrets for retrieving Oracle data faster and more elegantly than the traditional approaches to writing SQL.

Offres spéciales et liens associés

Descriptions du produit

Biographie de l'auteur

Laurent Schneider is one of the most respected authors in Oracle technology, with many years of experience as a Systems Engineer and Database Engineer. Laurent achieved the highest level of DBA certification in 2004, being the first Oracle Certified Master in Switzerland and recipient of the prestigious Oracle Technology Network ACE trophy. Laurent has over a decade of expertise in development - specializing in data warehousing and database modeling as well as database administration. He currently works for a successful Swiss bank as application architect/developer. In his spare time, Laurent enjoys studying Chinese Chess strategy and has won the Swiss Championship. He lives on the sunny side of the Uetliberg with his wife Bertille, his daughter Dora and his son Loïc.

Détails sur le produit

  • Broché: 304 pages
  • Editeur : Rampant TechPress; Édition : First (17 novembre 2008)
  • Collection : Oracle In-Focus
  • Langue : Anglais
  • ISBN-10: 0977671585
  • ISBN-13: 978-0977671588
  • Dimensions du produit: 22,6 x 17,8 x 2 cm
  • Moyenne des commentaires client : 4.0 étoiles sur 5  Voir tous les commentaires (2 commentaires client)
  • Classement des meilleures ventes d'Amazon: 444.183 en Livres anglais et étrangers (Voir les 100 premiers en Livres anglais et étrangers)
  •  Souhaitez-vous compléter ou améliorer les informations sur ce produit ? Ou 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.

Dans ce livre (En savoir plus)
Parcourir les pages échantillon
Couverture | Copyright | Table des matières | Extrait | Index | Quatrième de couverture
Rechercher dans ce livre:

Vendre une version numérique de ce livre dans la boutique Kindle.

Si vous êtes un éditeur ou un auteur et que vous disposez des droits numériques sur un livre, vous pouvez vendre la version numérique du livre dans notre boutique Kindle. En savoir plus

Commentaires en ligne 

5 étoiles
3 étoiles
2 étoiles
1 étoiles
4.0 étoiles sur 5
4.0 étoiles sur 5
Commentaires client les plus utiles
4.0 étoiles sur 5 Very interesting book 13 juillet 2010
Par ctico
It's a very interesting book for oracle developers that need to make complex query .
Is not very easy to read only for professional
Avez-vous trouvé ce commentaire utile ?
4.0 étoiles sur 5 Excellent livre 25 septembre 2009
Par Waldar
C'est un très bon ouvrage qui donnera de nombreux conseils pratique quant à l'écriture de requête complexe qui permettent au final de simplifier et d'accélérer l'exécution de requêtes fastidieuses.

Les nouveauté des dernières versions d'Oracle sont incluses, ce qui est très appréciable !
Avez-vous trouvé ce commentaire utile ?
Commentaires client les plus utiles sur Amazon.com (beta)
Amazon.com: 2.8 étoiles sur 5  5 commentaires
10 internautes sur 10 ont trouvé ce commentaire utile 
3.0 étoiles sur 5 Decent book on advanced SQL but much to be desired 22 février 2009
Par Harsha N. Hegde - Publié sur Amazon.com
I am an ardent reader of Laurent Schneider's blog: [...] His deep understanding of databases is unparalleled. The tips he provides are very practical and handy. That's probably what raised my expectations from his book: "Advanced Oracle SQL Programming". I have just finished reading through this book and I can clearly say that I am a bit disappointed with the book.
- It feels more like a collection of Laurent's notes on various Oracle SQL topics.
- There is a disconnect between one topic and the next one.
- Topics are very brief, often not exceeding 3-4 sentences. Much more detailed discussion/analysis of each concept would have made the book more readable.
- More tips/tricks (like the ones in boxes with an explosive symbol) would have made me go back to this book often.
- This may sound trivial, but the formatting of the code unnecessarily takes up too much space. e.g, in the first chapter itself, all the "INSERT" statements run to 8 pages! They could have easily been arranged 2 columns/page. They are not even required because it is available for download anyway at the book's website.
Nice things I found in the book:
- Exercise problems are really good, will make you think.
- Explanation on Joins, Subquery and Hierarchical queries are so far the best I have read.
5 internautes sur 6 ont trouvé ce commentaire utile 
3.0 étoiles sur 5 Advanced Oracal SQL 13 novembre 2009
Par Richard John - Publié sur Amazon.com
Format:Broché|Achat authentifié par Amazon
I found most of the book to be a rehash of other material Oracle published. Most of the SQL I would not consider advanced. I felt if a intermediate at best. I bought this book about 6 months ago and after reading I have only used it once or twice as reference. There is some stuff in one of the middle chapters, but overall I was disappointed.
3 internautes sur 4 ont trouvé ce commentaire utile 
1.0 étoiles sur 5 Poorly written, and confusing 12 avril 2010
Par Joshua E. Emery - Publié sur Amazon.com
Probably the worst Technical book I have ever read. It is poorly formatted, and some paragraphs just do not make sense. Examples are weak, and not explained leaving you to toil over it to figure what the writter is trying to accomplish. I highly recommend avoiding this book. Do not make the costly mistake I did.
3.0 étoiles sur 5 Hardly Advanced, A good introduction. 21 août 2011
Par M. Thomas Groszko - Publié sur Amazon.com
Format:Broché|Achat authentifié par Amazon
This is not an advanced SQL book. It is an excellent introduction to the Oracle SQL environment. I was expecting much more discussion about how to handle difficult SQL problems.
4 internautes sur 8 ont trouvé ce commentaire utile 
4.0 étoiles sur 5 Best SQL Reference for Oracle 17 janvier 2009
Par Chen Shapira - Publié sur Amazon.com
After few month of writing SQL, everyone has a good grasp of the language basics - you can use joins, where, group by and nested queries and 99% of the time, this is enough.

But sometimes, this is not enough, or maybe it does the job, but its slow or ugly. And you wonder - is there a better way to select data?

This book will show you a better way. Laurent Schneider is an Oracle developer with over a decade of experience. He shows you all the tricks and techniques that real experts use when writing queries.

"Advanced Oracle SQL Programming" covers every advanced function and feature that Oracle has to offer and gives plenty of real-life, business relevant examples of how these advanced features should be used. You'll find yourself writing better code almost immediately, and the book even contains exercises that will allow you to practice your new skills as you learn.
Ces commentaires ont-ils été utiles ?   Dites-le-nous
Rechercher des commentaires
Rechercher uniquement parmi les commentaires portant sur ce produit

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


Souhaitez-vous compléter ou améliorer les informations sur ce produit ? Ou faire modifier les images?