Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Oracle Database 11g: SQL Fundamentals I 
Print PageOracle Designer 6
Description:
This course teaches the purposes and capabilities of each tool of the Oracle CASE Method and how to generate a Windows-based client-server system.
- Cost: Price on application
- Duration: 5 Days
- This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
Familiarity with Microsoft Windows environment, the terminology and concepts of data modeling and relational database design. The equivalent in course OR experience with Oracle Foundations Classes, Developer Forms and Relational Database Design Concepts
Create Application System:
Overview of Oracle Designer
Methodology behind the tool
The Respository 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 onilne help system
Methodology behind the tool
The Respository 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 onilne help system
Create Data Model:
Data modeling concepts and processes
Invoking the Entity Relationship Diagrammer
Sup-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 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 unipue identifers with the ER Diagrammer
Using Repository Reports to check quality
Repository Reports tool window
Invoking the Entity Relationship Diagrammer
Sup-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 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 unipue identifers 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
Organisation units and swin lanes
Function Creation workflow
The role of business units
Adding process flow information to the function model
Organisation units and swin 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
Why cross-references are needed
Creating a new matrix diagram
Types of entity usages
The Data Flow Diagrammer
Define Database Design:
Anatomy of the Design Editor
Design Editor interface
Fefining the database design
How to create a new data diagram
Design Editor interface
Fefining 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
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
Templates
Using the preferences palette Specifying form and report templates
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
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
Organising the display with item groups
How to create a Master-Detail link
Introduction to Webserver Generator and its use
Cooperation between Oracle Designer and Developer during the forms
Generation hints
Creating a lookup link
Organising 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
Running the Reports Generator
Generating the application`s menu
Generating application help files
Entering help text in the repository