Project Oracle

Oracle Database 11g Administrator Certified Professional (OCP)

OCP training helps rising DBA professionals earn project manager roles, while helping IT veterans become more valuable to employers.This professional certification allows you to manage large databases and develop large-scale database applications. In summary, to become an Oracle Certified Professional (OCP), you have to take an instructor-led course, an exam and a hands-on course.

  • What you will learn :

This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You'll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery.

  • Benefits to You :

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter.

  • Backup & Recovery :

The concepts and architecture that support backup and recovery, along with the steps required to execute it in various ways and situations, are covered in detail. You'll learn how to define and test your own backup and recovery scenarios.

  • Manage Memory Effectively :

You'll also learn how to manage memory effectively, as well as how to perform some performance evaluation and tuning tasks. Instructors will review all types of flashback technologies, scheduling jobs inside and outside of the database and controlling system resource usage.

  • Course Objectives :

Back and recover a database (and its parts) with RMAN (command-line and Enterprise Manager) Use flashback technology to view past states of data and to revert either objects or the entire database back to a past state
Use an appropriate and flexible memory configuration for your database Identify burdensome database sessions and poorly performing SQL Configure the Oracle Database for optimal recovery
Configure the database instance such that resources are appropriately allocated among sessions and tasks Schedule jobs to run inside or outside of the database Use compression to optimize database storage and duplicate a database

  • Course Topics :

  • Core Concepts and Tools of the Oracle Database
  • The Oracle Database Architecture: Overview
  • ASM Storage Concepts
  • Connecting to the Database and the ASM Instance
  • DBA Tools Overview
  • Configuring for Recoverability
  • Purpose of Backup and Recovery (B&R), Typical Tasks and Terminology
  • Using the Recovery Manager (RMAN) Configuring your Database for B&R Operations Configuring Archivelog Mode
  • Using the RMAN Recovery Catalog Tracking and Storing Backup Information Setting up a Recovery Catalog
  • Using RMAN Stored Scripts
  • Managing the Recovery Catalog (Backup, Export, Import, Upgrade, Drop and Virtual Private Catalog)
  • Automatic Tempfile Recovery
  • Recovering from a Lost Index Tablespace Re-creating a Password Authentication File Complete and Incomplete
  • Flashback Technology: Overview and Setup Using Flashback Technology to Query Data Flashback Table
  • Automatic Workload Repository (AWR) Describing the Benefits of Database Replay
  • SQL Tuning and SQL Advisors
  • Managing Space in Blocks Free Space Management Monitoring Space Compressing Data
  • Additional Automatic Space-Saving Functionalit
  • Managing Space for the Database Using 4 KB-Sector Disks Transporting Tablespaces Transporting Databases
  • Describing the Use of Windows, Window Groups, Job Classes, and Consumer Groups