Oracle Database Administrator 11g-12c

Oracle Database Training & Certification Courses:

Course 1: Oracle 11g DBA OCA & OCP Certification Training

OraGyan offers a course on Oracle 11g DBA OCA & OCP. Oracle 11g DBA training takes the database administrator beyond the basic tasks covered in the SQL NEW and Administration Workshop I. Students will gain a deep understanding of the most important responsibilities a DBA has: performing backup and recovery. After completing this course, students will be able to diagnose and repair data failures with Flashback technology and manage space to optimize database storage.
  • Oracle Architecture
  • Oracle Installation on Linux
  • Background Process and SGA Configuration
  • Understanding of PFILE/SPFILE
  • Understanding and Importance of Control File
  • Tablespace and Data Files Configuration and Management
  • RedoLog Files and Archive Log Files Concept
  • Users, Roles and Profiles
  • Configure for Recoverability
  • Use the RMAN Recovery Catalog
  • Configure Backup Settings
  • Create Backups with RMAN
  • Restore and Recovery Task
  • Use RMAN to Perform Recovery
  • Monitor and Tune RMAN
  • Diagnose the Database
  • Use Flashback Technology I
  • Use Flashback Technology II
  • Perform Flashback Database
  • Manage Memory
  • Manage Database Performance
  • Manage Resources
  • Automate Tasks with the Scheduler
  • Manage Space in Blocks
  • Manage Space in Segments
  • Manage Space for the Database
  • Duplicate a Database
  • Basic understanding of databases
  • Working knowledge of RDBMS concepts & SQL
  • Working knowledge of Oracle 9i or 10g
  • Understanding of Linux
  • Fees for this course is - $1399.

Please contact us for more details.


Course 2: Oracle 12c DBA OCA & OCP Certification Training

This Oracle database 12c release comes re-engineered for Cloud computing. It also offers a multitenant infrastructure that ensures unparalleled software and hardware efficiencies, including high performance and management benefits, along with efficient and fast Cloud provisioning. Oracle Database 12c certification emphasizes the complete practical knowledge required by DBAs in today's competitive world. Oracle Database 12c OCA DBA certification will provide advanced skills and expertise required of proficient database administrators. Achieving this Oracle Database 12c OCA DBA credential will validate your skills in managing Oracle databases effectively and efficiently while optimizing their performance.

Oracle Database 12c OCP DBA certification provides advanced level expertise in administering Oracle databases while gaining deep understanding of underlying architecture and internal workings of this latest version of Oracle database 12c deployment. The OCP DBA credential in this latest version of Oracle Database 12c will help professionals confirm their advanced skills in complete database management and maintenance.

  • Installing Oracle Grid Infrastructure for Standalone Servers.
  • Managing components with Oracle Restart.
  • Upgrading existing versions of Oracle Database to the latest Oracle Database 12c.
  • Creating container databases and provisioning pluggable databases.
  • Creating and maintaining Oracle Database Instances.
  • Building and managing Storage Structures.
  • Configuring and managing the Network Environment.
  • Creating and managing users.
  • Monitoring and troubleshooting the database while ensuring performance.
  • Learning basic backup and recovery techniques.
  • Updating the Oracle Database software using My Oracle Support or Oracle Support Workbench.
  • Managing the performance of pluggable databases and multitenant container databases
  • Configuring resource manager for sharing resources between and within a multitenant container database and a pluggable database
  • Implementing unified auditing
  • Making use of SQL*Loader and Oracle Data Pump in pluggable databases
  • Monitoring the operations and performance of multitenant container database and pluggable database
  • Completely understand the multitenant architecture
  • Creating multitenant container databases from scratch
  • Creating pluggable databases using various prescribed techniques
  • Plugging a non-CDB into a multitenant container database
  • Administering the storage structures of multitenant container databases and pluggable databases
  • Creating and administering user accounts
  • Performing specific operations such as Oracle Data Pump loading, transportation, auditing, and encryption
  • Managing local and common user privileges and roles
  • Configuring backup and recovery operations for pluggable databases and multitenant container databases
  • Managing storage and security for pluggable databases and multitenant container databases
  • Familiarity with data processing concepts and techniques
  • Basic knowledge of Linux Operating System
  • Prior knowledge of 11g Database would be an added advantage
  • Fees for this course is - $1699.

Please contact us for more details.

Skip to toolbar