Series:

Oracle Press

3 total works

Cover of Oca Oracle Database SQL Exam Guide (Exam 1z0-071)
This fully integrated study system covers every aspect of the Oracle Database SQL Expert exam, and has been thoroughly updated for Oracle Database 12c

This comprehensive study guide from Oracle Press enables readers to prepare for the SQL Database Expert Exam with total confidence. Ideal both as a study guide and on-the-job reference, Oracle Database 12c SQL Certified Expert Exam Guide features examples, practice questions, and chapter summaries. Between the book and accompanying CD-ROM, you will have access to more than 150 questions that match the topics, format, and complexity of the real test.

This study system covers all of the objectives for the Oracle Database 12c SQL Expert Exam in full detail and features up-to-date coverage of advanced SQL features related to Oracle Database 12c. An "exam readiness checklist" at the front of the book and "inside the exam" and "two minute drills" sections at the end of each chapter reinforce key skills. You will acquire in-depth knowledge of SQL programming and relational database concepts and will be prepared to sit for the Oracle Certified Expert exam.

  • Each chapter includes examples, practice questions, and summaries
  • CD-ROM contains two interactive practice tests and a searchable PDF version of the book
  • Sample questions throughout match the format and difficulty of the live exam

Cover of Ocp Developer PL/SQL Program Units Exam Guide
The PL/SQL Program Units exam is one of the four exams required for the OCP Internet Application Developer track. This book covers all official exam objectives and contains over 400 practice questions, chapter self-tests, two minute drills, and a glossary of key Oracle terms. The CD-ROM contains a testing engine that simulates the actual exam.

Cover of Oce Oracle Database SQL Certified Expert Exam Guide (Exam 1z0-047)
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
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 statementsManipulating, restricting, and sorting dataSingle-row and group functionsSubqueriesSchema objectsSet operatorsData dictionary viewsLarge data setsHierarchical retrievalRegular expression supportUser access controlAnd more

On the CD-ROM:

One full practice examDetailed answers and explanationsScore report performance assessment toolComplete electronic bookBonus exam available with free online registration

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