HOME


Updated 3 April, 2012

Oracle 11g Database Administrator - Oracle Certified Associate (OCA) A+ Certification


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. Today there are over 440,000 Oracle Certified Professionals worldwide.

 

Oracle Database 11g is Oracle's largest introduction of new functionality and is Oracle's most innovative release, leading the database industry into new ground in clustering, automation, high availability and more.

 

This comprehensive elearning course prepares students for the Oracle 11g Database Administrator Certified Associate. 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. Practice exams are also included, which will allow you to answer questions in the same format as test on exam day, and will provide in-depth instructional feedback on each question to thoroughly cover every subject you need to master.

Students are provided with Flash-based instructional demonstrations. Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises. Activities allow learners to apply course concepts in an interactive questioning environment. Exercises allow learners to practice in the actual application being studied. The course challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank, and a skill assessment generates a customised learning path based on the results of a pre-test. Bookmarking tracks the learner's progress in a course.




Topics Covered in this Course


Module 1 : SQL Fundamentals
  • Introduction to SQL
  • Using Single-Row Functions
  • Using Group Functions
  • Using Joins and Subqueries
  • Manipulating Data
  • Creating Tables and Constraints
  • Creating Schema Objects
  • Practice Exam 1
  • Practice Exam 2
  • Practice Exam 3


Module 2: Oracle Database 11g Administration
  • Database Components and Architecture
  • Creating a Database
  • Database Storage and Schema Objects
  • Determining the Correct Network Architecture
  • Implementing Security and Auditing
  • Managing Data and Undo
  • Managing Performance and Maintaining the Database
  • Implementing Database Backups
  • Recovering the Database
  • Moving Data and Using EM Tools
  • Practice Exam 1
  • Practice Exam 2
  • Practice Exam 3



Who should complete this course?

  • Oracle 11g 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.


Progression

  • Oracle Database 11g Administrator Certified Professional.


Assessment

  • 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 11g: SQL Fundamentals exam (1Z0-051) and the Oracle Database 11g: Administration exam (1Z0-052).
  • These exams may be sat when students have completed the course. Exam fees are not included in the course price.


Technical Requirements

  • The following technical requirements apply: 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.


Accreditation

  • Once you successfully complete the programme, you will receive a Diploma in Advanced Database Administration from CMIT.
  • Following successful completion of exams, you will receive a certificate from Oracle to confirm that you are an Oracle Certified Associate (OCA).



 Student Feedback   (Please include your Email address)
FETAC ILM Adobe CIW MS Office Specialist ISO 9001