ORA10g603 - ORACLE 10g Designer Repository Administration & Tools

Course ORA10g603

Table of Contents

Introduction
Audience
Prerequisites
Certified Professional Exams
Student Materials
Course Outline

Introduction

Building the Oracle 10g Designer repository

Return to Top

Audience

Application designers and database administrators who will be administering the Oracle Designer tool.

Return to Top

Prerequisites

Before attending this course, students must have:

• Completed ora10g008, Oracle Database 10g: Introduction to SQL I, or equivalent.
• Completed ora10g009, Oracle Database 10g: Introduction to SQL II, or equivalent.
• Completed ora10g101, Oracle Database 10g: Program With PL/SQL

It is also recommended that students have:

• ora10g201, Oracle Database 10g: Administration I (5 days)

Suggested Next Course

• ora10g604, Oracle 10g Designer Advanced Repository Administration (2 days)
• ora10g601, Oracle10g Designer Data Modeling (3 days)
• ora10g602, Oracle10g Designer Systems Analysis & Modeling (5 days)

Return to Top

Certified Professional Exams

No exam currently exists for this course.

Return to Top

Student Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

Return to Top

Course Outline

THE ORACLE DESIGNER REPOSITORY

• Understanding The Repository
• Understanding Repository Storage

THE RAU & REPOSITORY INSTALLATION

• About The Repository Administration Utility
• Using Check Requirements
• Using Install/Migration/Upgrade
• Performing A New Installation

RAU REPOSITORY MAINTENANCE

• The Repository Maintenance Tools
• Using Recreate Repository
• Using View Objects
• Using Compute Statistics

RAU MAINTAIN USERS

• Using Maintain Users
• Adding Users
• Deleting Users
• Reconciling Users

RAU DEINSTALL & BACKUP

• About Deinstall
• About Backup

USING THE RON

• About The Ron
• Perform Object Maintenance

USING THE MATRIX DIAGRAMMER

• About The Matrix Diagrammer
• Defining A Matrix
• Using The Display Modes

USING THE REPOSITORY REPORTS

• Find A Report
• Run A Report
• Understanding The Report Groups
• Reports You Should Run

ADMINISTERING STORAGE

• Enabling A Versioned Repository
• Administering Access Rights
• Creating Workareas
• Managing Objects Within A Workarea

BASIC VERSION CONTROL

• Check Out & Check In
• Viewing The Version History

ADVANCED VERSION CONTROL

• Comparing Versions
• Merging Versions
• Purging Versions
• Editing Policies

VERSION BRANCHING

• About Branching
• Maintaining Branch Definitions
• Check Out & Check In With Branching
• Merging Branches
• Altering The Version Display

Return to Top