Designer Analysis & Design

5 Day Course
Code OD

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

Modules

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

Prerequisites

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. If you are unsure please ask a training advisor .

  • 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 Next Date July 19th in Sunderland 54 Scheduled Dates in 7 Locations Course Code OPI

Sections