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 KhanI 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 AbbasIt'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 AustraliaStudent Review
I joined OCP 11g course here. Training was excellent. Trainer was very helpful.
Read More Ammanullah Khan Dera Ismail KhanTo 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
Course Content Exam(s)
Exame Name | Exame Number | Product Version | Exam Cost |
1Z0-071 |
Oracle Database 12c |
$ 150 |
|
1Z0-052 |
Oracle Database 11g |
$ 150 |
|
1Z0-053 |
Oracle Database 11g |
$ 150 |
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