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.

Oracle is the leading developer of database software, and the Oracle certifications have long been the standard for professional Database Administrators. Oracle 11g OCAs need to have an understanding of the following:       Restricting and Sorting Data       Using Conversion Functions and Conditional Expressions       Displaying Data from Multiple Tables       Manipulating Data       Exploring the Oracle Database Architecture       Preparing the Database Environment       Creating an Oracle Database       Managing the Oracle Instance       Managing Database Storage Structures       Administering and Implementing User Security       Database Maintenance       Performance Management       Performing Database Backups and Recovery       Moving Data OCA: Oracle Database 12c Administrator Certified Associate Study Guide is designed for those who feel they are ready to attempt these challenging exams. Readers will have access to a robust of study tools, including the Sybex Test Engine featuring preassessment and chapter review questions, bonus practice exams, and over 150 electronic flashcards. It addition, it will include a searchable Glossary of Terms in PDF format.