• 21-Feb-2020: NEW SESSION "ORACLE 12C DBA" AT CAVALRY GROUND LAHORE
  • 21-Feb-2020: New Session "AWS Cloud Practitioner" at Cavalry Ground Lahore (6PM)
  • 14-Mar-2020: FREE Seminar "Essential Skills for Accountant 2020" at Cavalry Ground Lahore
  • 29-Feb-2020: FREE Seminar "Essential Skils for Accountant 2020" at Islamabad Centre (4PM)
  • Create Perfect Posts for Social Media with Adobe Illustrator and Adobe Photoshop

Oracle Database 11g Administrator (Oracle Certified Professional-OCP)

I joined OCP 11g course here. Training was excellent. Trainer was very helpful.

Read More Ammanullah Khan Dera Ismail Khan

I have joined here for Oracle DBA Training. Now I am working in a Oracle Partner company after the training. They gave excellent support while training and resume preparation. I Personally recommend t...

Read More Ghulam Mustafa Fort Abbas

It's a life experience. The course was very interesting . The tutors are really great . Learning in such professional environment has a great benifits for me

Read More Yaser Mehmood Australia

Student Review

I joined OCP 11g course here. Training was excellent. Trainer was very helpful.

Read More Ammanullah Khan Dera Ismail Khan

To become an Oracle Certified Professional (OCP), one must be proficient in the latest update to Oracle’s industry-leading database product: Oracle 11g—this guide prepares you for all three exams that comprise the Oracle 11g OCP certification. Each level of certification is broken down, beginning with the prerequisite Oracle Certified Administrator certification, and concluding with the OCP certification. You’ll get helpful insight for fulfilling the requirement of taking one of the approved courses offered by Oracle University.

Course Objectives

Oracle Database: Introduction to SQL

  • Identify the major structural components of the Oracle Database 12c
  • Manage objects with data dictionary views
  • Manage schema objects
  • Retrieve row and column data from tables
  • Run data manipulation statements (DML) in Oracle Database 12c
  • Use scalar and correlated sub-queries
  • Utilize views to display data
  • Write SELECT statements that include queries
  • Write multiple-column sub-queries
  • Control database access to specific objects
  • Create reports of aggregated data
  • Create reports of sorted and restricted data
  • Create tables to store data
  • Display data from multiple tables using the ANSI SQL 99 JOIN syntax
  • Employ SQL functions to retrieve customized data
  •  

Oracle Database 11g: Administration Workshop I

  • Install Oracle Grid Infrastructure
  • Install and configure Oracle Database 11g
  • Configure Oracle Net services
  • Monitor and administer undo data
  • Manage the database storage structures
  • Create and administer user accounts
  • Perform basic backup and recovery of a database
  • Manage data concurrency
  • Monitor performance
  • Describe Oracle Database Architecture
  •  

Oracle Database 11g: Administration Workshop II

  • 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
  • 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
Prerequisite

BA,BCS,MCS,MIT Degree

Student Review

I joined OCP 11g course here. Training was excellent. Trainer was very helpful.

Read More Ammanullah Khan Dera Ismail Khan
1
1
 
1
1
Fly-me-a-Trainer is a one of its kind service by Oranet. As per client requirements, Oranet sends expert trainers to corporate locations. With our trainer at your venue, you just need a conference room. The participants will be provided remote access to server at our Data Center.
For any Query or Custom Plan info@oranet.com.pk Lahore: 042-36619618-9 | Islamabad: 051-2806466
Order Summary
asdfsdsdf
Course Oracle Database 11g Administrator (Oracle Certified Professional-OCP)
Training Mode
Training Type
Training Location
Accomodation
Date
Total




Order Summary
asdfsdsdf
Course Oracle Database 11g Administrator (Oracle Certified Professional-OCP)
Training Mode
Training Type
Training Location
Accomodation
Training Days
Date
Total