Oracle Designer 6i First Class: Design and Generate

This is the second title in a series of two and covers the same material as the second half of the Instructor Led course Oracle Designer6i: First Class. This course takes students along a streamlined path through the Oracle Designer development environment. It follows on from the first title in the series Oracle Designer First Class 6i: Analysis and covers transforming the analysis model into design level definitions refining the data and application designs and generating database objects and simple WebServer applications. This course is part of an Oracle integrated curriculum and forms the core course to all the Oracle Designer courses.

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 8 hours Training Presented in: English

Audience

Targeted audiences for this course are Business Analysts; Project Leaders; Designer/Developers; Web Application Developers; Data Administrators and Database Administrators. Participants should have taken the first part in this series Oracle Designer 6i: First Class Analysis (course 61414).

Objective

• Identify how to transform the analysis model into design definitions.
• Identify how to refine generate and build the database design.
• Identify how to design and generate an application system that includes an Oracle Developer form and an Oracle WebServer application.

Topics Include

Unit 1: Oracle Designer Introduction

• Identify the phases of the development life cycle.
• Identify the features of Oracle Designer.
• Identify how the Entity Relationship Diagrammer is used to prepare for Server Design.
• Identify how a Function Hierarchy Diagrammer is used to prepare for Application Design.
• Identify how a Matrix Diagrammer is used to prepare for application design.
• Identify the uses of the Database Design Transformer.
• Identify the uses of the Application Design Transformer.
• Identify the uses of the Design Editor.
• Identify the components of a Function Hierarchy Diagram.
• Identify the components of an Entity Relationship Model.
• Identify the components of a Matrix Diagram.
• Identify how a first-cut database design can be mapped from an Entity Relationship Model.
• Identify how a first-cut application design is mapped from a Function Hierarchy and CRUD Matrix.

Unit 2: Server Design and Generation

• Identify unique identifiers relationships and attributes of an Entity Relationship Model.
• Identify the components of a table definition.
• Identify how an entity definition maps to a table definition.
• Automatically transform an Entity Relationship Model into table definitions using the Database Design Transformer.
• Identify how the Design Editor is used during systems development.
• Identify the four views of information represented in the Design Navigator.
• Create a schema diagram using the Design Editor Work Area.
• Perform a series of tasks using a Wizard.
• Perform an entire process using a guide.
• Edit a property of a database object using a dialog box.
• Edit a property of a database object using a property palette.
• Create a database object using the Design Editor.
• Automatically populate a column using the AutoGen Type column property.
• Set a column to default to a specific value by setting the Default Value property.
• Automatically generate successive integer values for a column using the Sequence Generator.
• Automatically create primary keys using the Database Design Transformer.
• Identify the criteria necessary to ensure that the Database Design is complete and ready for Database Generation.
• Create files that can be used to create database objects using the Generate from Server Model utility.
• View the online dictionary using the Database Navigator.
• Identify the uses of the Table API.
• Create APIs on tables in the online dictionary using the Generate Table API utility.

Unit 3: Application Design and Generation

• Identify the benefits of setting column display properties prior to module creation.
• Set a column display property using the Edit Table dialog box.
• Identify what must be completed before running the Application Transformer to create a first-cut application design.
• Identify how the Application Design Transformer uses the CRUD matrix and the
• Function Hierarchy to create a first-cut application design.
• Perform the steps necessary to run the Application Design Transformer.
• Accept and delete candidate modules using the Design Editor.
• Set the Response Property of a business function to determine the module type and data usage of a module.
• Select the different Generator options needed for module generation.
• Perform the steps necessary to generate a module in the Design Editor to create a working form.
• Save the changes that the Generator has made to the module definition using the Generation Complete Dialog Box.
• Identify the components of a module.
• Create links between module components to define master-detail and lookup table usage.
• Create a bound item in a base table usage from the module diagram.
• Toggle between the Data View and the Display View using the button on the tool palette in a module diagram.
• Set module component properties using a dialog box.
• Create a WHERE condition to restrict rows returned by a query.
• Identify the way in which preferences are grouped.
• Identify some of the preferences that influence the layout of a generated form.
• Set the preferences for a module using the Preferences Palette.
• Identify which preferences to set to automatically control the GUI items.
• Identify the properties that can be modified to customize a List of Values.
• Create a module definition using the Module Application Guide in the Design Editor.
• Create a Module definition using the Navigator in the Design Editor.
• Create a copy of a module and select properties to copy using the Copy utility.
• Make a copy of a module with a different language using the Copy With New Language utility.
• Identify the concepts of HTML Web Pages and Developer on a Web Application Server.
• Create a WebServer module definition using the Design Editor.
• Identify the output produced when a WebServer module is generated.
• Identify the three types of layout styles that can be defined for a Web page.
• Identify the groups of preferences that are specific to a WebServer module.
• Identify the type of pages that user text can be added to at the module component level.
• Identify the tasks that need to be performed before generated Web pages can be run.
• Identify the properties that need to be set in the Generator dialog box.
• Install the PL/SQL packages needed to run an application using the Build Actions dialog box.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

• Oracle Designer 6i First Class: Analysis