For information about purchasing 'Oracle Designer 6i: First Practice', please visit the Oracle University web site at http://education.oracle.com/.

  1. Objectives
  2. Audience
  3. Prerequisites

'Oracle Designer 6i: First Practice' is a set of hands-on practices designed to complement the 'Oracle Designer 6i: First Class' instructor-led and technology-based courses.

One of the things about self-study is that it's sometimes difficult to put into practice the things you've learned on your own, and still be sure you've got it right. So we've created First Practice to help you, in your own time, go through a carefully designed set of practice exercises, using the actual software, and to match your efforts with sample solutions. It's a simulation of a project, just like the approach we've used in our course 'Oracle Designer 6i: First Class'. This should help you use the software tools in the right context.

First Practice takes you along a streamlined path through the Oracle Designer 6i development environment. You record business requirements into the repository, transform the analysis model into design level definitions, refine the data and application designs, and generate database objects and simple Oracle Forms and WebServer applications.

Objectives
  • Identify the features and components of System Modelers.
  • Identify standard components of the Life Cycle.
  • Invoke Entity Diagrammer, Process Modeler, Matrix Diagrammer, Design Editor
  • Identify and perform the primary tasks to implement an Oracle Designer 6i project.
  • Input business system requirements into the Oracle Designer 6i repository.
  • Generate Oracle Server objects
  • Generate Oracle Forms and WebServer applications
  • Create and modify a repository object under version control
Audience
This practice is aimed at all those people who will be involved in the development of application systems using Oracle Designer 6i. This includes:
  • Business analysts or system analysts
  • Project managers
  • Database designers
  • Oracle Forms application developers
  • WebServer application designers
  • Repository administrators
  • Data administrators or database administrators
  • Anyone with a need for a full lifecycle overview of Oracle Designer 6i
Prerequisites

Required

Completion of both Oracle Designer 6i technology based training titles:

'Oracle Designer 6i First Class: Analysis'

'Oracle Designer 6i First Class: Design and Generation'

OR

Completion of the instructor-led course 'Oracle Designer 6i: First Class'

Suggested

Familiarity with relational database concepts

Knowledge of SQL

Familiarity with PL/SQL

Knowledge of Oracle Forms

Summary

By the time you complete this self-practice, you should be able to build and generate an application using Oracle Designer 6i. You should also understand how information flows through the life cycle from analysis to design and into the generated application.