back to Course Categories | back | print
Oracle9i Introduction to Designer          

Duration: 5 days

This course will teach students the fundamental features of Oracle Designer. Students will address primary tasks for an Oracle9i Designer project. Students will convert an analysis model into design definitions, generate Oracle9i Forms and Reports, generate a Web PL/SQL application. Students will design, redefine and build database designs using the Oracle9i Designer tool.


  • Oracle9i Designer
  • The Development Life Cycle
  • CDM
  • The different stages of development
  • Roles within a project
  • The Oracle9i Designer architecture
  • Major components of Oracle Designer
  • The multi-user repository
  • Work areas, containers and objects
  • Flowdown
  • Designer terminology and concepts
  • Modeling business requirements
  • A Process Model
  • Components of a process model
  • Working with the Process Modeler
  • Modeling Data Requirements
  • The Entity Relationship Diagram (ERD)
  • Working with the Entity Relationship Diagrammer
  • Entities and domains
  • Defining a Business Function
  • Process steps and functions
  • Creating a Function Hierarchy Diagram
  • Working with the Function Hierarchy Diagrammer
  • Defining Functions to Be Automated
  • Specifying Business Function to Entity Usage
  • Explaining the Significance of the Response Type Property
  • Cross-checking Business Functions and Data
  • The Infamous CRUD Matrix
  • Building a Matrix Diagram
  • The Matrix Diagrammer
  • Reviewing Analysis Tasks
  • Primary Analysis Tasks
  • Developing Repository Reports
  • Converting the data model into a table design
  • Mapping entities to tables
  • Explaining How Relationships are Implemented
  • The Database Design Transformer
  • Using the Design Editor
  • Main Components of the Design Editor Interface
  • Using Designer Guides and Wizards
  • Building Objects
  • Modifying database object properties
  • Modifying a Database Design
  • The Server Model Diagram
  • Creating a Data Schema Diagram
  • Column Properties
  • Adding a Column to a Table Definition
  • Creating primary key columns
  • Defining default value for a column
  • A surrogate key
  • Building the Database
  • Defining a Database
  • Implementing the Data Design Using the Server Generator
  • Viewing the Online Database Using the Database Navigator
  • TTable Application Programming Interface (API)
  • Generating a Table API
  • Reviewing Data Design Tasks
  • Setting Data Presentation Standards
  • Column Properties and Column Display Properties
  • Data Display Properties
  • Application Design
  • The Application Design Transformer
  • Converting Candidate Modules to Working Modules
  • Determining the Type and Language of the Resulting Modules
  • Generating and Running an Oracle Form Module
  • Refining Modules for Generation
  • Identifying the Components of a Module and a Module Diagram
  • The relationship between modules and the generated form
  • Creating a Module Diagram Using the Design Editor
  • Re-sequencing Module Components
  • Creating links between table usages
  • Base Table Usage and Lookup Table Usage
  • Establishing Table and Module Component Links
  • Defining Bound Items in a Module
  • Generating Oracle Forms
  • Setting Preferences
  • Generation Input Sources
  • Working with List of Values
  • Setting Generator Options
  • Generating a Simple Form
  • Influencing a Module During Generation
  • Using the Message Window
  • Running a Generated Form
  • Creating Modules During Design
  • The Module Application Guide
  • Working with the Module Component Data Wizard
  • Copying a Module
  • Generating a Web PL/SQL Application
  • The Web PL/SQL Generator
  • Web PL/SQL Applications versus Web Forms
  • Web PL/SQL Modules
  • URL Structures
  • Working with Forms
  • Layout Preferences
  • Adding User Text
  • Generating, Installing and Running a Simple Web PL/SQL Application
  • Review Application Design and Generation Tasks
  • Discussing Application Design and Generation Tasks
  • Addressing Any Problems or Questions
  • Reviewing the Life Cycle Tasks
  • Reviewing Development Life Cycle tasks
  • Summary


  • A solid background in Oracle with experience in database design, SQL, PL/SQL and Oracle Developer is required.


Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes


all content property © 2006, 2007Trubix Inc.| site design by Art Z design