Oracle 11g DBA OCA & OCP Training & Certification Courses
 800 Ratings

Oracle Authorized Training Partner Expert Chat

Guarantee to Run the Classes

Get Trained by Industry Expert

#1 Offshore IT Training Company


Koenig offers one of the most popular Oracle certification courses - Oracle 11g DBA OCA & OCP. Oracle DBA training takes the database administrators 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 in this DBA course. After completing this Oracle certification course, students will be able to diagnose and repair data failures with Flashback technology and manage space to optimize database storage.

Audience: Oracle 11g DBA OCA & OCP Certification is best suited for database management professionals who need to work on Oracle products.

Course Content / Exam(s)

Schedule for Oracle 11g DBA OCA & OCP

Course Name Exam # Duration (days)
Oracle Database: Introduction to SQL

Course Content

Course 1Z0-061: Oracle Database: Introduction to SQL

  • Retrieving Data using the SQL SELECT Statement
  • Introduction to Data Dictionary Views
  • Manipulating Data by Using Subqueries
  • Managing Data in Different Time Zones
  • Introduction
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables Using Joins
  • Using Subqueries to Solve Queries
  • Using the SET Operators
  • Managing Tables using DML statements
  • Introduction to Data Definition Language
  • Creating Sequences, Synonyms, Indexes
  • Creating Views
  • Managing Schema Objects
  • Retrieving Data by Using Subqueries
  • Controlling User Access
  • Manipulating Data
Oracle Database 11g: Administration Workshop I

Course Content

Course : Oracle Database 11g: Administration Workshop I

  • Exploring the Oracle Database Architecture
  • Installing your Oracle Software
  • Creating an Oracle Database
  • Managing the Oracle Database Instance
  • Manage the ASM Instance
  • Configuring the Oracle Network Environment
  • Managing Database Storage Structures
  • Administering Usersecurity
  • Managing Data Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Auditing
  • Database Maintenance
  • Performance Management
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data
  • Working with Support
Oracle Database 11g: Administration Workshop I5
Oracle Database 11g: Administration Workshop II

Course Content

Course : Oracle Database 11g: Administration Workshop II

  • Core Concepts and Tools of the Oracle Database
  • Configuring for Recoverability
  • Using the RMAN Recovery Catalog
  • Configuring Backup Settings
  • Creating Backups with RMAN
  • Restore and Recovery Task
  • Using RMAN to Perform Recovery
  • Monitoring and Tuning RMAN
  • Diagnosing the Database
  • Using Flashback Technology I
  • Using Flashback Technology II
  • Performing Flashback Database
  • Managing Memory
  • Managing Database Performance
  • Managing Performance by SQL Tuning
  • Managing Resources
  • Automating Tasks with the Scheduler
  • Managing Space in Blocks
  • Managing Space in Segments
  • Managing Space for the Database
  • Duplicating a Database
Oracle Database 11g: Administration Workshop II5
Total 15

Course Prerequisites

  • Basic understanding of databases
  • Working knowledge of RDBMS concepts & SQL
  • Working knowledge of Oracle 9i or 10g

Oracle 11g DBA OCA & OCP Benefits

Upon Completion of this Course, you will accomplish following:-

  • 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 Performance by SQL Tuning
  • Manage Resources
  • Automate Tasks with the Scheduler
  • Manage Space in Blocks
  • Manage Space in Seg/ments
  • Manage Space for the Database
  • Duplicate a Database
Give an edge to your career with Oracle certification training courses. Students can join the classes for Oracle 11g DBA OCA & OCP Training & Certification Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

Recommended Courses and Certification:

Enquire Now



Processing data, please wait...