• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   Oracle DBA Training Courses

DBA Part I - Architecture & Administration

View course dates

Course Duration: 5 days

Course Code: ODA

Course Description:

This course is for anyone who needs to create, administer and troubleshoot an Oracle8i or Oracle9i database. By the end of this course, the delegate will have been given practical experience in creating and administering an Oracle database. Database administrators will gain an understanding of the architecture and processes of the Oracle server. They will be able to ensure the integrity and availability of their organisations data within the Oracle environment. This course covers the main architecture and administration topics for the Oracle9i Database: Fundamentals I examination (IZ0-031) and the topics of the Oracle8i Architecture and Administration examination (IZ0-023).

Prerequisites:

A working knowledge of SQL*Plus is required. This can be obtained by attendance on the "Oracle SQL*Plus" course. A good working knowledge of operating system commands is also required. Pre-Requisites Courses: SQL*Plus (OSP). Note: Before taking any exam, ensure you have the recommended experience.

Prerequisite courses:

SQL*Plus

Relevant Certifications:

Oracle9i Database Administrator

This course includes the following modules:

Topics Covered

• Oracle Architectural Components
• Managing an Oracle Instance
• Creating an Oracle Database
• Managing an Oracle Database
• Managing Disk Space, Tablespaces and Data Files
• Managing Undo data and Temporary Segments
• Managing redo logs and control files
• Managing Tables and Indexes
• Managing Users, Profiles, Privileges and Roles
• Maintaining Database Security
• Using National Language Support

 

To make an enquiry for this course to be run ONSITE at your location, click here or call Sales on +44 (0) 20 7620 0033.

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course