Course description

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 800×600, 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).