The Everest Advantage

  • Accredited Institution
  • Online Convenience
  • Affordable Payment Plans
  • 24/7 Access
Enroll Today!
Guaranteed Results

Oracle Database Administrator OCA 11g

Find Your Program!

We are not currently enrolling students in this program. However, if you are still interested in Oracle Database Administrator training and certification, consider the Oracle-based programs available from QuickStart, one of America’s leaders in IT continuing education.

Expand Your Database Management Skill Set as an OCA Database 11g Administrator

Make the next move in your IT career as a database administrator (DBA) and get certified as an Oracle Certified Associate (OCA). Get the training you need to master the industry's most advanced database management system: Oracle Database 11g.

Why Train for OCA 11g Certification through Everest?

Oracle certification is the easy way to show current and prospective employers you're an expert in database management. This investment in your IT education will pay off with:

  • A strong foundation in Oracle database 11g
  • Greater recognition from IT hiring managers
  • Extensive employment opportunities
  • Higher earning potential

As an Oracle Database 11g Administrator Certified Associate, you can apply for a range of IT positions, including:

  • Database administrator
  • Data storage manager
  • Database analyst
  • Database designer

With Oracle Database 11g Administrator Training, You'll Learn How to:

  • Install and maintain an Oracle database
  • Create an operational database
  • Properly manage the various structures in an effective and efficient manner (performance monitoring, database security, user management and backup/recovery techniques)
  • Use the advanced features of SQL to query and manipulate data within the database
  • Control privileges at the object and system level of SQL
  • Use advanced querying and reporting techniques in SQL

With the OCA 11g Certification Program, You Get:

  • The Oracle Database 11g Administrator certification training course, which features 70 hours of expert-developed curriculum
  • Test preparation for the certification examinations
  • Assistance from qualified instructors during virtual office hours and access to customer support 24/7
  • An Oracle Database 11g Administrator Certified Associate certificate, when you pass the Oracle certification examination.* This certificate demonstrates your advanced understanding of the Oracle database system.

As part of the Oracle Database 11g Administrator Certification training, your exam prep courses will cover these subject areas:

  • 1Z0-047 - Oracle Database SQL Expert
  • 1Z0-052 - Oracle Database 11g: Administration I

The Everest Advantage

As one of America's post-secondary education leaders, Everest can provide you with an experience that is as cost-effective as it is personally rewarding. Your satisfaction is assured by our unique combination of:

  • Expert support
  • 24/7 access
  • Affordable payment plans
  • Guaranteed results!
  • Institutional Accreditation

Our Guarantee

Everest is so confident this training course exceeds the exam objectives that if you achieve 90 percent or higher on all your practice tests, and you subsequently take and fail to pass the certification exam within six months of completing the course, we will refund your money in full.

Learn how to maintain the Oracle 11g database management system, from set-up procedures and upgrades to security procedures and troubleshooting. Find the Enroll Now box at the top of the page and choose how you want to pay.

* Upon completion of the course, you will be prepared to take Oracle exam 1Z0-047 (Oracle Database SQL Expert) and exam 1Z0-052 (Oracle Database 11g: Administration I). Exam fees are not included with the course.
COURSES IN THIS PROGRAM

1Z0-047: Oracle Database SQL Expert

To prepare you for the Oracle 1Z0-047 exam, the training modules included are:

 

  1. Introduction to Oracle SQL
  2. Select statements
  3. Where and order by clauses
  4. Single-row functions
  5. Group functions
  6. Joins
  7. Subqueries
  8. Set operators
  9. Data manipulation language
  10. Data definition language
  11. Schema objects
  12. User privilege
  13. Oracle data dictionary views
  14. Large data sets
  15. Time zones
  16. Advanced subqueries
  17. Regular expressions

1Z0-052: Oracle Database 11g: Administration I

To prepare you for the Oracle 1Z0-052 exam, the training modules included are:

  1. Database architecture
  2. Installing Oracle software
  3. Creating an Oracle database
  4. The Oracle Instance
  5. Oracle network environment
  6. Database storage structures
  7. User security
  8. Schema objects
  9. Data and concurrency
  10. Undo data
  11. Security
  12. Maintenance
  13. Oracle performance
  14. Backup and recovery
  15. Database backups
  16. Recovery
  17. Moving data
  18. Database maintenance