Oracle9iDS Designer Systems Analysis & Modeling

This 5-day course will teach students the necessary skills 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 allowing participants to see first hand the productivity gains achieved with the tool. On course completion, students will learn about:

• Supporting tools and utilities
• Navigators
• Setting Preferences
• Fine-tuning models
• Generate Rapid Prototypes Using Design Wizard

Target audience

The target audience for this course is Oracle client/server developers. Students should have attended the following courses or have equivalent knowledge and experience:

• Oracle Designer Data Modeling
• Introduction to Oracle 9i SQL
• Introduction to Oracle 9i PL/SQL language

Course content

Introduction 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 modelling introduction What is process modelling? • 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 modelling Configuration and management of models • File/Summary information • File/Configuration • Including repository objects • Diagram consolidation • Presentation and analysis features • Utilities • How to build a model

The entity/relationship diagrammer What is the entity/relationship diagrammer • Creating an entity/relationship diagram • Entities and 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 and 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 data flow diagrams and why data flow diagrams 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 and administer the repository strategy • Sharing objects between applications

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today