Oracle 9i Designer Part 1 (O310) Training Course

Training Course Objectives

This practical course introduces the Designer v9i tool environment and covers the techniques and methods associated with Business Process Engineering, Systems Analysis, Entity Modelling, Functional Decomposition and Design.

The course also covers the v6i repository tools used to model business processes and functions.

This practical hands-on course covers the full range of graphical modelling tools found within the Designer Upper Case modules together with the techniques needed to deploy working business analysis solutions.

Who Should Attend

• Oracle Analyst/Programmers
• Oracle Technicians
• Oracle Designers

Training Course Prerequisites

• PC Fundamentals
• View Learning Path

Training Course Duration

4 Days

Training Course Contents

Introduction

• Developing Systems
• Methodologies
• CASE Tools
• CASE Repositories
• Designer v9i
• Client Server
• Tool Manager
• Upper Case Tools
• Automation Tools
• Lower Case Tools
• Generator Tools
• Support Utilities
• Repository Data Flow
• Access and Control
• Versioning
• Workareas
• Containers

Repository Object Navigation

• Repository Object Navigator
• Application Creation
• Property Sheets
• Property Sheet Buttons
• Application Properties
• Editing Properties
• Object Navigation
• File Menu
• Edit Menu
• RON Preferences
• View Menu
• Navigator Menu
• Utilities Menu
• Application Menu
• Tools Menu
• Help Menu
• RON Buttons

Information Processing

• Information Processing
• Matrix Diagrams
• The Matrix Toolbar
• Designer Reports
• The Reports Navigator
• Report Groupings
• The Reports Toolbar

Business Process Engineering

• Business Processes
• Business Process Modelling
• Business Process Identification
• Business Process Information
• Business Organisation Structures
• Business Process Re-engineering
• Benefits
• The Process Modeller
• Process Modeller Toolbar
• Process Drawing Toolbar

Entity Modelling

• Systems Analysis
• CATWOE
• An Imaginary Payroll System Example
• Conventions and Definitions
• Entities
• Relationships
• Attributes
• Entity Life Histories
• An Attribute that Becomes An Entity
• Primary Keys and Uniqueness
• Foreign Keys
• The m:n Problem -Intersection Entities
• Building Entities: Transitions
• Domains
• Checklist
• Entity Sub-Types and Super-Types
• Exclusivity and Arcs
• Rules for Arc Notation

Entity Diagrams

• Introduction
• Entity Diagrammer
• Entity Diagrammer Interface
• Preferences
• Creating Entities
• Entity Properties
• Creating Relationships
• Drawing Relationships
• Relationship Properties
• File Menu
• Edit Menu
• View Menu
• Utility Menu
• Toolbar
• Methods

Dataflow Diagrams

• Introduction
• Diagram Components
• Dataflow Diagrammer
• Diagram Tools
• Functions and Dataflows
• Modelling Techniques

Next Available Dates

iTrain delivers this course as company specific training. Please contact us for more information or course dates.