HOME


Updated 8 January, 2010
Oracle9i Database Administrator Certified Associate A+ Certification


What is Oracle Certification?


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 9i Database Administrator Certification combines training, experience, and testing to ensure that you have a strong foundation and expertise in Oracle9i Database techniques, including backup and recovery, performance tuning, and administration. Oracle9i Database provides efficient, reliable and secure data management for high-end applications such as high-volume online transaction processing (OLTP) environments, query-intensive data warehouses, and demanding Internet applications.

How this Course works


This comprehensive elearning course prepares students for the Oracle9i certification from Oracle. The course is completed online, at your own time, at a location that suits you. You progress through the course materials and complete the online lessons and tests. Students will be introduced to the major components of an Oracle server and the database structure, and will learn how to create and manage such components as databases, instances, tablespaces, tables, datafiles, storage units, undo data, tables, indexes, data integrity, users, profiles, privileges, and roles.

Students are provided with Flash-based instructional demonstrations, Instructional audio with graphics highlighting key points. 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. The course challenges 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: Introduction to Oracle9i SQLR
  • Introduction to SQL
  • Intermediate Queries
  • Queries with Single-Row Functions
  • Combining Tables
  • Grouping and Summarising Data
  • Advanced Queries and Views
  • Working with Data
  • Creating Tables and Constraints
  • Database Objects and User Security
  • SQL*Plus And iSQL*Plus Reporting and PL/SQL
  • Practice Exam

Module 2 : Database Fundamentals
  • Oracle Architecture and Tools
  • Managing Instances and Creating Databases
  • Managing the Database Structure
  • Managing Tablespaces and Datafiles
  • Managing Storage Structures and Undo Data
  • Managing Tables
  • Managing Indexes and Data Integrity
  • Managing Users and Profiles
  • Managing Privileges and Roles
  • Exam Preparation




Who should complete this course?

  • Oracle Developers and Database Administrators.
  • People considering a career as a Oracle Database Developer or Administrator.


Prerequisites

  • You must have a good working knowledge of Microsoft Windows.


Assessment

  • Once you successfully pass the programme, you will receive a Diploma in Advanced Database Administration from CMIT. You must pass both modules with a score of 70% or better to receive the Diploma.
  • To receive Oracle9i Database Administrator Certification you must complete 2 computer-based multiple choice exams (1ZO-007 and 1ZO-031) which may be sat when students have completed the course. Exam fees are not included in the course price.
  • The exam may be completed at an Assessment Centre near where you live. Assessment centres are located in the following counties: Dublin, Cork, Galway and Westmeath.


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 are 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 to confirm that you are an Oracle9i Database Administrator Certified Associate.



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