Oracle 10g Designer Systems Analysis & Modeling Training

Course #:WA1375

Oracle 10g Designer Systems Analysis & Modeling Training

This course is a common starting point in the Oracle database curriculum for administrators, developers and business users.

Objectives 

Building enterprise-wide system from sophisticated models is now possible with Oracle Designer technology. Participants 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.

Prerequisites

  • The Course Oracle 10g Designer Data Modeling
  • The Course Oracle Database 10g: Introduction to SQL
  • The Course Oracle Database 10g: Program With PL/SQL

Audience

Experience developers

Duration

Five days.

Outline of Oracle 10g Designer Systems Analysis & Modeling Training

1. INTRO TO MODERN APPLICATION DESIGN

2. THE ORACLE DESIGNER ENVIRONMENT

  • About The Repository
  • Sophisticated Error Dialogs

3. REPOSITORY SETUP

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

4. PROCESS MODELING INTRODUCTION

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

5. REFINING THE PROCESS MODEL

  • Refine The Model
  • Editing Objects

6. 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

7. THE ENTITY/RELATIONSHIP DIAGRAMMER

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

8. REFINING THE DIAGRAM

  • Domains
  • Diagram Layout
  • Preferences
  • OLE Objects

9. REVERSE ENGINEERING

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

10. FUNCTION HIERARCHY DIAGRAMMER INTRODUCTION

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

11. MODIFYING & REFINING ELEMENTS

  • Edit Functions

12. 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

13. DATA FLOW DIAGRAMMER

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

14. CERTIFICATION WITH MATRIX DIAGRAMMING

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

15. REPOSITORY REPORTS

16. REPOSITORY ADMINISTRATION

  • Determine & Administer The Repository Strategy
  • Sharing Objects Between Applications
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.