Oracle Database 12C Bundle (OCP)


Course Details

Oracle certifications are tangible, industry-recognised credentials that can help you succeed in your IT career and provide measurable benefits to your employer. Oracle certifications are a reliable validation of training and experience that can accelerate your professional development, improve your productivity, and enhance your credibility. In fact, 97% of Global Fortune 500 companies use Oracle software. Well-trained, highly-skilled database professionals who can manage critical systems are in high demand.

This comprehensive elearning course prepares students for the Oracle 12c Database Administrator. The course is completed online, at your own time, at a location that suits you. This course covers in-depth database administration topics such as troubleshooting, problem recovery, and managing storage and memory. With Oracle Database 12c: SQL Fundamentals, you experience the benefits of an Oracle Database that is re-engineered for Cloud computing. Multitenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning. Oracle Database 12c: SQL Fundamentals certifications emphasize the full set of skills that DBAs need in today’s competitive marketplace. The Oracle 1Z0-062 course will prepare you for your Oracle Database 12c Installation and Administrator Professional certification with ease.

Practice exams are also included, which will allow you to answer questions in the same format as the test on exam day, and will provide in-depth instructional feedback on each question to thoroughly cover every subject you need to master.

This course includes the following features:

  • Instructor-led demonstrations and visual presentations to develop your skills based on real-world scenarios.
  • Unlike a live class, you can fast-forward, repeat or rewind all your lectures. This gives you all the benefit of hands-on training with the flexibility of doing it around your schedule 24/7.
  • Flash Cards and Education Games are also provided throughout the course.
  • Practice exams prepare you for your exams. These exams are on average 100 questions to ensure you are 100% prepared if you are taking a certification exam.
  • You can also interact and collaborate with other students through our forums, student contributions and announcement features.
Who should complete this course?
  • Oracle 12c Developers and Database Administrators.
  • People considering a career as a Oracle Database Developer or Administrator.
Entry Requirements / Prerequisites
  • You must have a good working knowledge of Microsoft Windows.
How CMIT eLearning Works…

Topics covered in this Course

Oracle 12c OCP 1Z0-061: SQL Fundamentals

  • Intro to Oracle 12c SQL Fundamentals
  • Retrieving Data
  • Subqueries
  • Data Manipulation Language
  • Data Control Language
  • Data Definition Language
  • Combining Queries
  • Conclusion

Oracle 12c OCP 1Z0-062: Installation and Administration

  • Database Concepts and Tools
  • Data Manipulation Language
  • Data Concurrency
  • BackUp and Recovery
  • Installation
  • Course Review
  • Memory Structure
  • Tables
  • Indexes
  • Constraints and Triggers
  • Users
  • Internal Structures
  • Starting Up and Shutting Down Database
  • Critical Storage Files
  • Once you successfully pass the programme, you will receive a Diploma in Advanced Database Administration from CMIT.
  • You may optionally take exams to receive Oracle 11g certification. This comprises two computer-based multiple-choice exams: Oracle Database 12c: SQL Fundamentals exam (1Z0-061) and the Oracle Database 12c: Administration exam (1Z0-062). These exams may be sat when students have completed the course. Exam fees are not included in the course price.
Technical Requirements
  • Broadband internet connection of at least 10Mbps.
  • Browser – we recommend Chrome or Safari for Tablet or Apple Mac; and Firefox or Internet Explorer for PC hardware.
  • Operating System – PC (Windows 7 or later), Mac or Android.
  • Following successful completion of exams, you will receive a certificate from Oracle to confirm that you are an Oracle Database 12c Administrator Certified Associate.
  • This programme does not lead to an award in the Irish National Framework of Qualifications (NFQ).
  • Click here for Accreditation Details
Student Reviews of this Course
{{ reviewsOverall }} / 5 Users (0 votes)
What students say... Leave your rating
Order by:

Be the first to leave a review.

{{{review.rating_comment | nl2br}}}

Show more
{{ pageNumber+1 }}
Leave your rating