Project Description

Course Details

Oracle 11g: Database Administrator Certified Professional (OCP Program)

Course Duration: 100 Hours
Total Class: 30 to 35

Instructor Profile
  • Module-1 Oracle Database 12c: SQL Workshop 1 & 2 (30-Hours)
  • Module-2 Oracle Database 11g: Administration Workshop-I (30-hours)
  • Module-3 Oracle Database 11g: Administration Workshop-II (30-Hours)

Module-1 Oracle Database 12c: SQL Workshop 1 & 2

  • Introduction to Oracle Database
  • Retrieve Data using the SQL SELECT Statement
  • Learn to Restrict and Sort Data
  • Usage of Single-Row Functions to Customize Output
  • Invoke Conversion Functions and Conditional Expressions
  • Aggregate Data Using the Group Functions
  • Display Data From Multiple Tables Using Joins
  • Use Sub-queries to Solve Queries
  • The SET Operators
  • Data Manipulation Statements
  • Use of DDL Statements to Create and Manage Tables
  • Other Schema Objects
  • Control User Access
  • Management of Schema Objects
  • Manage Objects with Data Dictionary Views
  • Manipulate Large Data Sets
  • Data Management in different Time Zones
  • Retrieve Data Using Sub-queries
  • Regular Expression Support

 

Module-2 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 User Security
  • 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

Module-3 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

Resource Person

Mohammed Abdul AzizGuest Trainer Oracle
Oracle Certified