Training Course: Designer Analysis & Design

Training Course Summary:

Delegates:

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

Objectives:

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.

Topics Covered:

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

Requirements:

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

PL/SQL


Follow-On Courses:

DBA Part I - Architecture & Administration

Forms 6i - Part I

Reports