Oracle9i Designer: First Class

Aims and Objectives
Input business system requirements into the Designer repository.
Identify and perform the primary tasks to implement an Oracle9i Designer project.
Transform the analysis model into design definitions.
Design and generate an application system that includes an Oracle9i Forms and an Oracle Web PL/SQL application.
Refine, generate and build the database design.

Target Audiences
This course is designed for all new oracle designer users.

Prerequisites
Familiarity with relational database concepts.
Knowledge of SQL.
Familiarity with PL/SQL and Oracle Web PL/SQL.
Knowledge of Oracle Forms.

Course Content
Module 1: INTRODUCTION
Module 2: A QUICK TOUR OF ORACLE9I DESIGNER
Module 3: MODELING BUSINESS REQUIREMENTS
Module 4: MODELING DATA REQUIREMENTS
Module 5: IDENTIFYING FUNCTIONS TO AUTOMATE
Module 6: CROSS-CHECKING BUSINESS FUNCTIONS AND DATA
Module 7: REVIEWING ANALYSIS TASKS
Module 8: TRANSFORMING THE DATA MODEL INTO A TABLE DESIGN
Module 9: USING THE DESIGN EDITOR
Module 10: REFINING THE DATABASE DESIGN
Module 11: BUILDING THE DATABASE
Module 12: REVIEWING DATA DESIGN TASKS
Module 13: SETTING DATA PRESENTATION STANDARDS
Module 14: FROM FUNCTION TO WORKING FORM
Module 15: REFINING MODULES FOR GENERATION
Module 16: GENERATING ORACLE FORMS
Module 17: CREATING MODULES DURING DESIGN
Module 18: GENERATING A WEB PL/SQL APPLICATION
Module 19: REVIEW APPLICATION DESIGN AND GENERATION TASKS
Module 20: REVIEWING THE LIFE CYCLE TASKS``