Designer/2000: Analysis and Design

Audience

This course is designed for personnel who require a comprehensive introduction to the Oracle Designer/CASE tool.

Skills Gained

By the end of this course, the delegate will:

• Understand the Major Components of the Oracle Designer/2000 Software.
• Use the Process Modeller for Business Process Re-engineering (BPR).
• Use the Systems Modeller to Model Applications in Logical Business Terms.
• Use the Systems Designer to Model the Physical Application Design and to Build Applications.

Prerequisites

• SQL
• PL/SQL

Course Outline

• Business and System Analysis in Designer
• The Process Modeller
• The Entity Relationship Diagrammer
• The Function Hierarchy Diagrammer
• The Dataflow Diagrammer
• The Matrix Diagrammer
• System Design in Designer
• Transforming the Conceptual Data Model
• The Design Editor
• Refining the Data Model
• Physical Database Design
• Creating First Cut Code
• Maintaining Modules
• Maintaining PL/SQL in Designer
• Software Generation in Designer
• Generating the Server Model
• Generator Preferences
• Generating Forms and Reports
• Design Capture
• Application Management

Follow On Courses

• Oracle Database 10g DBA - Part I
• PL/SQL Stored Program Units
• Forms 6i - Part I
• Forms - Part I
• Reports