Course Content
ANALYSIS STAGE
CREATE APPLICATION SYSTEM
- Overview of Oracle Designer
- Methodology behind the tool
- The Repository Object Navigator (RON)
- RON initialization and functional components
- Using the Navigator Window
- Working with the Property Palette
- Using the RON to launch other tools
- Drawing toolbars on diagrammers
- Using the Oracle Designer online help system
CREATE DATA MODEL
- Data modeling concepts and processes
- Invoking the Entity Relationship Diagrammer
- Sub-types and Super-types
- Deleting diagram elements
- Displaying summary information for a diagram
- The Requery command
- Role of standards in ER diagrams
- Including existing elements from the repository
- Changing the default values
- Using the Requery command
- Documenting the model with text
- Using the RON to add additional terms to the system glossary
- Documenting business terminology
- What is an attribute?
- What is a domain?
- How to define range or list of values
- How to identify/create attributes for an entity
- Creating or identifying unique identifiers
- Defining unique identifiers with the ER Diagrammer
- Using Repository Reports to check quality
- Repository Reports tool window
CREATE FUNCTION AND PROCESS MODEL
- Function Hierarchy diagrams
- Function Creation workflow
- The role of business units
- Adding process flow information to the function model
- Organization units and swim lanes
CREATE CROSS REFERENCES
- Completing the analysis stage
- Why cross-references are needed
- Creating a new matrix diagram
- Types of entity usages
- The Data Flow Diagrammer
- DESIGN STAGE
REFINE DATABASE DESIGN
- Anatomy of the Design Editor
- Design Editor interface
- Refining the database design
- How to create a new data diagram
REFINE MODULE AND MENU STRUCTURE
- The Module Diagrammer
- The Standard Toolbar
- Creating a new diagram from existing modules
- The default module diagram
- Editing module components
- Overflow styles
DEFINE STANDARDS AND CONVENTIONS
- Preferences
- Templates
- Using the preferences palette
- Specifying form and report templates
BUILD STAGE
GENERATE DATABASE STRUCTURES
- Creating a database definition in the repository
- How to define a database using the RON
- Using the Target Tab to select the generation target
- Generating table API
- Using the Objects View to select the objects to generate
GENERATE FORMS
- Generating and testing screen modules
- Cooperation between Oracle Designer and Developer during the forms
- Generation hints
- Creating a lookup link
- Organizing the display with item groups
- How to create a Master-Detail Link
- Introduction to Webserver Generator and its use
GENERATE REPORTS, MENUS AND THE ONLINE HELP SYSTEM
- Working with report modules
- Running the Reports Generator
- Generating the application's menu
- Generating application help files
- Entering help text in the repository
