This intensive hands-on course is your first step to mastering Oracle 9i database administration. You will learn everything from the fundamental architecture of Oracle databases to creating databases from scratch, managing tables & indexes, managing security & configuring roles & privileges.

Duration: 5 Days

Oracle Architectural Components
Using Administration Tools
Creating a Database
Creating the Data Dictionary & Standard Packages
Maintaining the Control File
Maintaining Redo Log Files
Managing Tablespace & Data Files
Storage Structure & Relationships
Managing Undo Segments
Managing Tables
Maintaining Data Integrity
Managing Password Security & Resources
Managing Profiles
Managing Privileges
Managing Roles

Completion of OR-115: Oracle 9i: SQL & PL/SQL or knowledge of
PL/SQL is required to successfully complete this course.

This course is meant for Oracle database administrators or those who will be charged with administering an Oracle Database.  Most of the skills acquired also apply to previous versions of Oracle, such as Oracle 8i.