Free OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) (Oracle Press) Ebooks Online

                
              
Free 
OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) (Oracle Press) Ebooks Online
A Fully Integrated Study System for OCA Exam 1Z0-047Prepare 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 statementsManipulating, restricting, and sorting dataSingle-row and group functionsSubqueriesSchema objectsSet operatorsData dictionary viewsLarge data setsHierarchical retrievalRegular expression supportUser access controlAnd moreOn the CD-ROM: One full practice examDetailed answers and explanationsScore report performance assessment toolComplete electronic bookBonus exam available with free online registration
File Size: 13911 KB
Print Length: 796 pages
Simultaneous Device Usage: Up to 4 simultaneous devices, per publisher limits
Publisher: McGraw-Hill Education; 1 edition (November 22, 2009)
Publication Date: November 22, 2009
Sold by:  Digital Services LLC
Language: English
ASIN: B0035X1BUW
Text-to-Speech:  Enabled
X-Ray:     Not Enabled
Word Wise: Not Enabled
Lending: Not Enabled
Enhanced Typesetting:  Enabled
Best Sellers Rank: #398,462 Paid in Kindle Store (See Top 100 Paid in Kindle Store)   #38 in Books > Computers & Technology > Certification > Oracle   #137 in Books > Computers & Technology > Databases & Big Data > Oracle   #306 in Books > Computers & Technology > Databases & Big Data > SQL
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.
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.
OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) (Oracle Press) OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051 (Oracle Press) OCA: Oracle Database 12c Administrator Certified Associate Study Guide: Exams 1Z0-061 and 1Z0-062 OCA Oracle Database 12c Installation and Administration Exam Guide (Exam 1Z0-062) (Oracle Press) All-in-one Oracle 12c Associate Last Minute Guide: 1Z0-047 and 1Z0-062 OCA Oracle Solaris 11 System Administration Exam Guide (Exam 1Z0-821) (Oracle Press) OCA: Oracle Database 11g Administrator Certified Associate Study Guide: Exams1Z0-051 and 1Z0-052 OCM Java EE 6 Enterprise Architect Exam Guide (Exams 1Z0-807, 1Z0-865 & 1Z0-866) (Oracle Press) Study Guide for 1Z0-067: Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP: Oracle Certification Prep OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052) OCA: Oracle Certified Associate Java SE 8 Programmer I Study Guide: Exam 1Z0-808 OCP Upgrade to Oracle Database 12c Exam Guide (Exam 1Z0-060) (Oracle Press) OCP Oracle Database 11g New Features for Administrators Exam Guide (Exam 1Z0-050) (Oracle Press) OCP Oracle Database 11g Administration II Exam Guide: Exam 1Z0-053 (Oracle Press) OCP Oracle Database 12c Advanced Administration Exam Guide (Exam 1Z0-063) (Oracle Press) Study Guide for 1Z0-051: Oracle Database 11g: SQL Fundamentals I: Oracle Certification Prep Study Guide for 1Z0-144: Oracle Database 11g: Program with PL/SQL: Oracle Certification Prep Study Guide for 1Z0-071: Oracle Database 12c SQL: Oracle Certification Prep Study Guide for 1Z0-146: Oracle Database 11g: Advanced PL/SQL (Oracle Certification Prep) Study Guide for 1Z0-117: Oracle Database 11g Release 2: SQL Tuning (Oracle Certification Prep) 