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.

  • PL/SQL

    A 2-day Training Course on PL/SQL; Designed for those who need to write program scripts using Oracle's Procedure Language; corresponds to exam 1Z0-001

    2 Day Course Hands On Training Course Code OPI
    Classroom Virtual Classroom Private Group - Virtual Self-Paced Online

Course PDF