Books recommended for Oracle® Certification

1. OCA: Oracle Database 12c Administrator Certified Associate Study Guide: Exams 1Z0-061 and 1Z0-062 by Biju Thomas

An all-in-one study guide prepares you for the updated Oracle Certified Associate certification It's been nearly six years since Oracle updated its cornerstone database software, making the demand for a comprehensive study guide for the OCA 12c certification a top priority.

This resource answers that demand. Packed with invaluable insight, chapter review questions, bonus practice exams, hundreds of electronic flashcards, and a searchable glossary of terms, this study guide prepares you for the challenging Oracle certification exams.

Provides you with a solid understanding of restricting and sorting data Walks you through using conversion functions and conditional expressions Addresses displaying data from multiple tables, manipulating data, database maintenance, and database backups and recovery Explores the Oracle

database architecture and discusses preparing the database environment, creating an Oracle database, and managing the Oracle instance Focuses on administering and implementing user security This must-have study guide thoroughly prepares you to take the dramatically updated Oracle 12c OCA exams.

2. OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) by Roopesh Ramklass

Prepare for the Oracle Certified Associate Oracle Database 12c SQL Fundamentals I exam with this Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-061, including:

  • Data retrieval using the SQL SELECT statement
  • Restricting and sorting data
  • Single-row functions
  • Using conversion functions and conditional expressions
  • Reporting aggregated data with the group functions
  • Displaying data from multiple tables with joins
  • Using subqueries to solve problems
  • Using the set operators
  • Manipulating data with DML statements
  • Using DDL statements to create and manage tables

3. OCA/OCP Oracle Database 11g All-in-One Exam Guide : Exams 1Z0-051, 1Z0-052, 1Z0-053 by John Watson , Roopesh Ramklass , Bob Bryla

Prepare for the Oracle Certified Associate Administration I and SQL Fundamentals I exams and the Oracle Certified Professional Administration II 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 exams 1Z0-051, 1Z0-052, and 1Z0-053, including:

  • Instance management
  • Networking and storage
  • Security
  • SQL
  • Oracle Recovery Manager and Oracle Flashback
  • Oracle Automatic Storage Management
  • Resource manager
  • Oracle Scheduler
  • Automatic workload repository
  • Performance tuning

4.OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063) 2nd Edition by John Watson, Roopesh Ramklass , Bob Bryla

OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063) covers all of the exam objectives on the Installation and Administration, SQL Fundamentals, and Advanced Administration exams in detail. Each chapter includes examples, practice questions, Inside the Exam sections highlighting key exam topics, a chapter summary, and a two-minute drill to reinforce essential knowledge. 300+ practice exam questions match the format, topics, and difficulty of the real exam.

Electronic content includes interactive practice exam software with hundreds of questions that include detailed answers and explanations, a score report performance assessment tool, and a PDF copy of the book Ideal as both exam guide and on-the-job reference The most comprehensive single preparation tool for the Oracle Database 12c OCA and OCP certification exams

5. OCA Oracle Database 11g SQL Fundamentals I Exam Guide: Exam 1Z0-051 (Oracle Press) 1st Edition by John Watson , Roopesh Ramklass

Prepare for the Oracle Certified Associate Oracle Database 11g: SQL Fundamentals I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary 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 OCA objectives for exam 1Z0-051, including:

  • SQL SELECT statements
  • Restricting and sorting data
  • Single-row functions
  • Conversion functions and conditional expressions
  • Group functions
  • Displaying data from multiple tables
  • Subqueries
  • Set operators
  • DML and DDL statements
  • Schema objects

6. OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) (Oracle Press) 1st Edition by Steve O'Hearn

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

Disclaimer: Simulationexams.com is not affiliated with any certification vendor, and Sim-Ex™ Practice Exams are written independently by SimulationExams.com and not affiliated or authorized by respective certification providers. Sim-Ex™ is a trade mark of SimulationExams.com or entity representing Simulationexams.com.OCA® is a trademark of Oracle™.