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).