ORA10g602 - Oracle 10g Designer Systems Analysis & Modeling

Course ORA10g602

Table of Contents

Introduction
Audience
At Course Completion
Prerequisites
Certified Professional Exams
Student Materials
Course Outline

Introduction

Building enterprise-wide system from sophisticated models is now possible with Oracle Designer technology. Participants in this 5-day class will be equipped with the skills necessary to develop, maintain and certify process models, function models and data models along with their supporting structures. A complete, functional system will be developed over the course of the week-long seminar allowing participants to see first hand the productivity gains achieved with the tool. All the supporting tools and utilities are also considered, including the navigators, setting preferences and fine-tuning models. Once the models have been developed, participants will learn how rapid prototypes can be generated using the Design Wizards.

Return to Top

Audience

Application designers and developers who will be using the Oracle Designer tool to design and implement application modules.

Return to Top

At Course Completion

At the end of this course, the student will be able to develop, maintain and certify process models, function models and data models along with their supporting structures.

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:

• ora10g601, Oracle Designer Data Modeling (3 days)

Suggested Next Course

• ora10g401, Oracle 10g Forms I: Build Internet Applications (5 days)
• ora10g402, Oracle 10g Forms II: Customize Internet Applications (5 days)
• ora10g501, Oracle Reports 10g: Build Reports (5 days)
• ora10g601, Oracle Designer Data Modeling (3 days)
• ora10g603, Oracle 10g Designer Repository Administration & Tools (2 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

INTRO TO MODERN APPLICATION DESIGN

THE ORACLE DESIGNER ENVIRONMENT

• About The Repository
• Sophisticated Error Dialogs

REPOSITORY SETUP

• About Building The Repository
• Administration Utility
• Repository Object Navigator

PROCESS MODELING INTRODUCTION

• What Is Process Modeling?
• Components Of A Process Model
• Starting A Process Model
• Organization Unit
• Process Step
• Flow; Store; Trigger
• Outcome

REFINING THE PROCESS MODEL

• Refine The Model
• Editing Objects

OPTIONS FOR PROCESS MODELING

• Configuration & Management Of Models
• File / Summary Information
• File / Configuration
• Including Repository Objects
• Diagram Consolidation
• Presentation & Analysis Features
• Utilities
• How To Build A Model

THE ENTITY/RELATIONSHIP DIAGRAMMER

• What Is The ER Diagrammer?
• Creating An Entity/Relationship Diagram
• Entities & Attributes
• Relationships

REFINING THE DIAGRAM

• Domains
• Diagram Layout
• Preferences
• OLE Objects

REVERSE ENGINEERING

• About Reverse Engineering
• General Steps For Reverse Engineering
• Detailed Steps For Reverse Engineering

FUNCTION HIERARCHY DIAGRAMMER INTRODUCTION

• What Is A Function Hierarchy?
• Create New Function Diagram
• Adding Elements

MODIFYING & REFINING ELEMENTS

• Edit Functions

OPTIONS FOR FUNCTION HIERARCHY DIAGRAMMING

• Viewing Function Diagrams
• Expanding and Collapsing Hierarchies
• Navigation Within A Large Diagram
• Function Focus

EDIT / INCLUDE, EXCLUDE ROOT

EDIT / PREFERENCES

DATA FLOW DIAGRAMMER

• About DFDs & Why DFDs are Useful
• Using The Diagrammer

CERTIFICATION WITH MATRIX DIAGRAMMING

• What Is The Matrix Diagrammer?
• Creating A Matrix
• Working With The Matrix

REPOSITORY REPORTS

REPOSITORY ADMINISTRATION

• Determine & Administer The Repository Strategy
• Sharing Objects Between Applications

Return to Top