OCA Oracle Database SQL Certified Expert Exam Guide et plus d'un million d'autres livres sont disponibles pour le Kindle d'Amazon. En savoir plus

Acheter neuf

ou
Identifiez-vous pour activer la commande 1-Click.
ou
en essayant gratuitement Amazon Premium pendant 30 jours. Votre inscription aura lieu lors du passage de la commande. En savoir plus.
Acheter d'occasion
D'occasion - Comme neuf Voir les détails
Prix : EUR 33,24

ou
 
   
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

 
Commencez à lire OCA Oracle Database SQL Certified Expert Exam Guide sur votre Kindle en moins d'une minute.

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

OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) [Anglais] [Broché]

Steve O'Hearn
5.0 étoiles sur 5  Voir tous les commentaires (1 commentaire client)
Prix : EUR 51,72 Livraison à EUR 0,01 En savoir plus.
  Tous les prix incluent la TVA
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
Il ne reste plus que 8 exemplaire(s) en stock (d'autres exemplaires sont en cours d'acheminement).
Expédié et vendu par Amazon. Emballage cadeau disponible.
Voulez-vous le faire livrer le vendredi 29 août ? Choisissez la livraison en 1 jour ouvré sur votre bon de commande. En savoir plus.

Formats

Prix Amazon Neuf à partir de Occasion à partir de
Format Kindle EUR 31,32  
Broché EUR 51,72  

Description de l'ouvrage

1 janvier 2010 Oracle Press

A Fully Integrated Study System for OCA Exam 1Z0-047

Prepare for the Oracle Certified Associate SQL Certified Expert exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all objectives for exam 1Z0-047, including:

  • DDL and SQL SELECT statements
  • Manipulating, restricting, and sorting data
  • Single-row and group functions
  • Subqueries
  • Schema objects
  • Set operators
  • Data dictionary views
  • Large data sets
  • Hierarchical retrieval
  • Regular expression support
  • User access control
  • And more

On the CD-ROM:

  • One full practice exam
  • Detailed answers and explanations
  • Score report performance assessment tool
  • Complete electronic book
  • Bonus exam available with free online registration

For a complete list of Oracle Press titles, visit www.OraclePressBooks.com


Offres spéciales et liens associés


Produits fréquemment achetés ensemble

OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) + Oracle Database 11g PL/SQL Programming
Acheter les articles sélectionnés ensemble
  • Oracle Database 11g PL/SQL Programming EUR 51,72


Descriptions du produit

Biographie de l'auteur

Steve O'Hearn has been an Oracle Certified Application Developer since 1999. He has designed databases for 23 years for clients such as the U.S. Army, U.S. Navy, the FAA, the World Bank, NASA, and others. He has served as a Chief Technology Officer, a consultant, and Instructor, and is the author of several computer books, including the "Oracle OCP Developer PL/SQL Program Units Exam Guide," from Oracle Press.


Détails sur le produit

  • Broché: 796 pages
  • Editeur : McGraw-Hill Osborne; Édition : Pap/Cdr (1 janvier 2010)
  • Collection : Oracle Press
  • Langue : Anglais
  • ISBN-10: 9780071614214
  • ISBN-13: 978-0071614214
  • ASIN: 0071614214
  • Dimensions du produit: 23,5 x 18,8 x 4 cm
  • Moyenne des commentaires client : 5.0 étoiles sur 5  Voir tous les commentaires (1 commentaire client)
  • Classement des meilleures ventes d'Amazon: 35.113 en Livres anglais et étrangers (Voir les 100 premiers en Livres anglais et étrangers)
  • Table des matières complète
  •  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
Rechercher dans ce livre:

Quels sont les autres articles que les clients achètent après avoir regardé cet article?


Commentaires en ligne 

4 étoiles
0
3 étoiles
0
2 étoiles
0
1 étoiles
0
5.0 étoiles sur 5
5.0 étoiles sur 5
Commentaires client les plus utiles
2 internautes sur 2 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Très bon livre pour la certification 2 mars 2010
Format:Broché|Achat vérifié
Très bon livre si vous décidez de passer la certification SQL Expert. Le livre reprend tous les points qui sont abordé dans la certification et est une très bonne aide.
Le CD inclus un examen + 1 examen bonus a télécharger sur internet et ces examens sont le plus proche possible a ce que vous pourrez avoir pendant l'examen.
Aujourd'hui je suis certifié avec un score de 72% et en grande partie grâce a ce livre car il y a toujours des détails qu'on oublie.
Avez-vous trouvé ce commentaire utile ?
Commentaires client les plus utiles sur Amazon.com (beta)
Amazon.com: 4.2 étoiles sur 5  29 commentaires
22 internautes sur 23 ont trouvé ce commentaire utile 
4.0 étoiles sur 5 Great Studyguide for the Exam, and good overall SQL reverence 27 avril 2010
Par J. Pelaez - Publié sur Amazon.com
Format:Broché|Achat vérifié
The Oracle SQL Certified Expert exam covers several topics that are not covered in books that are geared towards the SQL Fundamentals exam. It is for that reason that I purchased this book to use as a study guide for the Oracle SQL Certified Expert exam. I recently passed the exam and give full credit to the time I spent going through this book and taking the practice tests.

The books assumes a little knowledge of SQL but I think it is a great guide for both beginners, and experts alike. It is well organized and has a great index. You can read it from beginning to end and it makes logical sense, or you can simply use it as a reference to look up the portions you are interested in. Because the book is geared towards passing the exam and not simply to provide more general SQL knowledge, you won't find any examples that you work on, alongside the book, as you read. Some people might find it hard to learn that way, but for me it was great. I didn't need to have a computer in front of me to try out the code to understand what it meant. This also allowed the book to focus on some of the more subtle and conceptual aspects of the SQL language and how Oracle has implemented it. I think that is key to having passed the exam. Because the book teaches the concepts behind the SQL language, instead of just giving syntax examples, it helps you correctly answer questions that might not directly relate to examples given in the book. For example, the book has a great section on the meaning of "NULL" which is used in a lot of "trick" questions. It might not give you all possible examples of where "NULL" can be used in a question, but it does give you a good understanding of what "NULL" means in the SQL context and therefore how to answer questions that could be affected by "NULL" in their code.

My biggest gripe with the book is the fact that it only came with 70 test questions on the CD, and that the CD is Windows only. 70 questions is the equivalent to 1 practice exam. You can download an additional 70 questions from the web after registering with the publisher, but even doing that only gives you 2 practice exams worth of material. It doesn't take long to memorize all the correct answers for 140 questions. I would have preferred the book if it came with at least twice as many questions. I also think its kind of ridiculous that the CD itself is not cross platform. Such practice exams could have been developed in a way which would have allowed me to run it under Mac OS X or Linux. Instead I had to run Windows under virtualization just to take the practice exam.
10 internautes sur 10 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Book + eBook = Good Deal 3 mai 2010
Par ESVK - Publié sur Amazon.com
Format:Broché|Achat vérifié
Steve O'Hearn does a good job delivering a very encouraging, personal (as well as informative) tone to the material. While containing much the same material as other Oracle Press SQL books, it does not lift or "steal" any of the wording. O'Hearn has opted to write everything from scratch. The book also lacks the typographical errors that have plagued so many Oracle Press books over the years.
This book's objective is to prepare you for the exam. It is not an exhaustive SQL reference (though certainly robust) - nor does it claim to be. In addition to the book itself, you also have access to the ebook and additional exam simulated questions via the CD. The ebook is in Adobe and isn't formatted quite as well as the Kindle version. The ebook is baked into the price at nearly $40.
There really isn't too much I would offer in the area of improvements - except to have even more exam type questions.
13 internautes sur 14 ont trouvé ce commentaire utile 
3.0 étoiles sur 5 Covers the material but is verbose 10 août 2010
Par SantoshK - Publié sur Amazon.com
Format:Broché
I have used multiple books to prepare for the Oracle SQL Expert exam.
This particular book is unique in that it covers all the topics for the exam (including the following
topics which are hard to find in just one book):
Generating Reports by Grouping Related Data, Managing Objects with Data Dictionary Views, Regular Expression Support, and Hierarchical Retrieval, and a few sections on managing TimeZones, Flashback, and External Tables.

Although this book is comprehensive enough for the examination, I thought the topics were covered more clearly in other books - particularly Oracle SQL by Watson and Mastering oracle SQL by Mishra. If your primary goal is to pass the exam, this book is ideal. Otherwise, study from a combination of aforementioned books.

Pros:
+Covers all the topics for the SQL Expert certification.
+Accessible to someone new to Oracle.

Cons:
-The author repeats himself 3 to 4 times in each section.
-The syntax and the description are verbose ( the syntax is given with an
example query and about a page describing it which could have easily been
replaced by [ ] | etc...)
-The examples are rudimentary and extremely obvious from the discussion
9 internautes sur 9 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 It fulfils its purpose 11 février 2011
Par Edelmiro Fuentes - Publié sur Amazon.com
Format:Broché|Achat vérifié
As someone who has been working with Oracle for years, I was pretty confident about my SQL knowledge but I decided to buy this book anyway in order to fill some small gaps that I noticed when I checked the topics covered in the exam. I am glad that I did, because the gaps were a little bit bigger than I thought and some of the topics I was feeling very confident about needed some polishing.

As I am used to working with strict naming conventions, a basic question such as whether or not is possible to give the very same name to a table, an index or a constraint never occurred to me before (the answer is yes, as they belong to different namespaces). I also thought that I knew perfectly well everything related to joins but I found little surprises such as a predefined keyword for the Cartesian product (CROSS JOIN) or that a column of datatype TIMESTAMP WITH LOCAL TIME ZONE can be used as a PK but a column of datatype TIMESTAMP WITH TIME ZONE cannot.

The book is well organized and it covers point by point the objectives of the Oracle exam. The examples are well chosen (no need to be in front of your computer) and the way the author explains each topic is so clear that the book could also be used by a beginner as a learning tool. I could only spot a small typo (SEELCT instead of SELECT on page 521) and probably one of the questions on a self test about the use of a pseudocolumn on page 163 that could have been improved a little bit:

SELECT ROWNUM, *
FROM PORTS
ORDER BY PORT_NAME;

It fails with a syntax error but the author didn't mention that it can be solved by using an alias:

SELECT ROWNUM, p.*
FROM PORTS p
ORDER BY PORT_NAME;

But these are really unimportant details. If you have not taken any Oracle exam yet, the one provided with the book will give you a very good idea about what to expect, but be warned that questions in the exam are a little bit harder. For me, this book was a key element for passing the exam and I can surely recommend it.
3 internautes sur 3 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Got me a passing score after less than a week of study. 21 avril 2013
Par R. C. Roper - Publié sur Amazon.com
Format:Broché|Achat vérifié
This is a great book, covering all of the relevant topics in detail. The chapters and sections are in the order the certification objectives appear on Oracle's 'Exam Topics' page for this test, so it's easy to navigate and find your trouble spots. There are over 200 end-of-chapter questions in the book, and that's all I used to study for this exam. After only a week of study, I passed the exam with no other preparation except for the experience I've gained over the short time I've held my job. I can only imagine how well I would have done if I registered later for the test and gave myself more time.

I initially deducted a point from my review over the Windows-only nature of the included CD (waah, waah, whiny Linux user), but looking back I sincerely believe that this book's printed content alone makes it well worth the low price. It contains all the material you would find in a thousand+ dollar course in an easy-to-navigate, well-written package. You should definitely purchase it if you are planning on taking the Oracle SQL Expert exam.
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
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


Commentaires

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