Designer Analysis & Design

5 Day Course
Code OD

This course has been retired. Please view currently available Oracle Development Training Courses.


Topics Covered (20 topics)

  • 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


A working knowledge of SQL*Plus and PL/SQL is required. This can be obtained by attendance on the Pre-Requisite courses. An understanding of Functional Analysis and Data Modelling is also required. Pre-Requisites Courses: SQL*Plus (OSP) and PL/SQL (OPI).

Additional Learning

The courses below may help you meet the knowledge level required to take this course.

Course PDF