Search for Training

Oracle Designer 10g

Course Overview


Oracle Designer 10g

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

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

What is the sum of 9 + 8? (security question)

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234

Subscribe to our weekly newsletter