OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063)

  • 16h 14m
  • Bob Bryla, John Watson, Roopesh Ramklass
  • Oracle Press
  • 2015

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.

  • 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

About the Authors

John Watson, OCP (Oxford, UK) is a senior consultant with BLP management Consultants, and taught for Oracle University in South Africa for four years.

Roopesh Ramklass, OCM (Canada) is a technical specialist with 10 years of experience in a wide variety of IT environments, including software development, system administration, systems analysis, software design, systems architecture, courseware development, and lecturing.

Bob Bryla, OCP (Dodgville, WI) has more than 20 years of experience in database design, database application development, training, and Oracle database administration. He is the primary Oracle DBA and database systems engineer at Epic in Verona, Wisconsin.

In this Book

  • Introduction
  • Installing Oracle Database Software
  • Creating an Oracle Database Using DBCA
  • Installing Oracle Grid Infrastructure for a Stand-Alone Server
  • Using Oracle Restart
  • DDL and Schema Objects
  • DML and Concurrency
  • Retrieving, Restricting, and Sorting Data Using SQL
  • Single-Row and Conversion Functions
  • Group Functions
  • SQL Joins
  • Subqueries and Set Operators
  • Architectural Overview of Oracle Database 12c
  • Instance Management
  • Oracle Networking
  • Oracle Storage
  • Oracle Security
  • Moving and Re-organizing Data
  • The AWR and the Alert System
  • Performance Tuning
  • The Resource Manager
  • The Scheduler
  • Configuring the Database for Backup and Recovery
  • Back Up with RMAN
  • Restore and Recover with RMAN
  • Diagnosing Failures
  • Flashback
  • Duplicating a Database
  • Encrypting, Securing, Monitoring, and Tuning RMAN Backups
  • Upgrading Oracle Database Software and Migrating Data
  • Upgrading an Oracle Database
  • Multitenant Container and Pluggable Database Architecture
  • Creating and Managing Multitenant Container and Pluggable Databases
  • Managing Storage, Security, Availability, and Performance in a CDB and PDBs
  • About the Download
  • Glossary
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Book DBA Essentials for 21c: Installing Oracle Database 21c on OCI Compute
Book Oracle Global Data Services for Mission-critical Systems: Maximizing Performance and Reliability in Complex Enterprise Environments
Book Extending Oracle Application Express with Oracle Cloud Features: A Guide to Enhancing APEX Web Applications with Cloud-Native and Machine Learning Technologies

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Rating 4.6 of 255 users Rating 4.6 of 255 users (255)
Course Oracle Database 12c R2 SQL: Conversion Functions & Conditional Expressions
Rating 4.7 of 42 users Rating 4.7 of 42 users (42)
Course Working with DDL
Rating 4.7 of 182 users Rating 4.7 of 182 users (182)