Oracle 10g Designer Training

Categories: PHP, WordPress, Laravel
Duration: 25 hours Hours
Lesson: 10 Lessons Lessons
Type: Online Training
Includes: Course Meterial

Course Overview

Oracle Designer is Oracle's CASE tool for designing an information system and generating it. After generating the information system one is able to edit the generated code with Oracle Developer Suite Oracle Designer is an incorporated Computer-Aided Software Engineering (CASE) tool. It encompasses the full growth life cycle from the business process, re-engineering to execution, and maintenance of a system. It also provides a multi-user repository system
  • Training by Realtime Expert trainer
  • Live Online Classes
  • Free study material
  • Online virtual Classes available in morning, evening and weekend

Prerequisties

  • Previous data and/or process modeling experience
  • Knowledge of Oracle RDBMS languages SQL and PL/SQL

Duration

Online

  • The format is 40% theory, 60% Hands-on.
  • It is a 20 days program and extends up to 2hrs each.

Corporate

  • The format is 40% theory, 60% Hands-on.
  • It is a 5 days program and extends up to 8hrs each.

Classroom

  • Private Classroom arrenged on request and minimum attendees for batch is 4.

Content

  • Designing and Generating a Module
    • Moving from Function to Form
    • Structuring a Module
    • Explaining Influences to Generation
  • Manipulating and Enhancing Item Display
    • Ordering the Display Sequence of Items
    • Describing Ways to Populate and Display Items
    • Displaying Allowable Values
    • Grouping Items Together
    • Using Button Items for Navigation
    • Exploring Item Help and Tool Tips
  • Influencing and Structuring Blocks
    • Displaying Rows in a Block
    • Using a Single Area Layout
    • Handling Records that Overflow
    • Determining Block Display Preferences
  • Presenting the Module as a Form
    • Introducing Canvases
    • Explaining Stacked Item Groups on a Tabbed Canvas
    • Using Block Context Items
  • Using Region to Enhance Data Presentation
    • Explaining Mirror Items and the Role of Context
    • Using Side-by-side Blocks
    • Working with Multi-region Blocks
    • Introducing Windows
  • Using Data Records for Validation
    • Identifying Sources of Record Validation
    • Using Key Constraints
    • Restricting Values with the WHERE Clause
    • Using List of Values (LOVs) for validation
  • Using Allowable Values for Validation
    • Defining Allowable Values and Generating Validation
    • Choosing Static or Dynamic Validation
    • Describing How Validation is Generated in the Server
    • Using Graphical User Interface (GUI) Items for Domain-based Validation
    • Implementing Allowable Values
    • Validating Text Items
    • Using Domain Key Constraints for Dynamic Validation
  • Refining Region Layout
    • Adding Derived Items to a Block
    • Using Relative Tab Stops
    • Describing the Dynamic Effects of Relative Tab Stops
  • Moving Around the Form
    • Using and Controlling Block Synchronization
    • Controlling Query Behavior
    • Controlling Navigation within Blocks
  • Constructing Tree Navigation
    • Explaining the Purpose of Navigator Style Forms
    • Using Navigator Style Forms
    • Choosing the Navigation Style
    • Defining Labels for Hierarchical Trees
    • Viewing and Editing Records Using Navigator Style Forms
  • Consistency in Generation
    • Reviewing Influences of Generation
    • Exploring the Generation Options and Form Generating Messages
    • Defining the Role of the Object Library, Preference Set, Templates, Online Dictionary, and Shipped Libraries
  • Designing a Standard User Interface
    • Enabling 100% Form Generation
    • Principles of Good User Interface Design
    • Using Oracle Designer to Achieve 100% Form Generation
    • Creating a Preference Set
    • Using a Calendar Template
    • Describing Messaging Preferences and the Object Library
    • Explaining the Object Library Structure
    • Describing How the Generator Uses Standard Objects
  • Adding Code to Your Application
    • Identifying Custom Action Items
    • Implementing Customized code
    • Using Application Logic
    • Describing Named Routines
    • Explaining How Events work
    • Defining Code in a Module
    • Performing Post-Generation Changes
    • Modifying Event Code
  • Storing Application Logic
    • Defining Oracle Developer Libraries
    • Describing Library File Formats
    • Explaining How to Use Libraries
    • Creating a Module library
    • Linking and Generating Libraries
    • Implementing a Library Module
    • Attaching a Library Module
    • Determining the Location of Application Logic
  • Building Interaction Between Forms
    • Describing the Module Network
    • Passing Values to a Called Form
    • Creating Startup Navigation
    • Running a Menu from a Form Module and Launch Window
    • Creating and Designing Menus
    • Using the Application Design Transformer
    • Identifying Candidate Menu Modules
    • Refining the Menu Design
  • Modeling LOVs
    • Defining a LOV
    • Recapping how LOVs are Used
    • Defining and Using LOV Components
    • Including a LOV in a Module
    • Refining a LOV
    • Manipulating the Return List
    • Using the LOV Form
    • Implementing Row LOVs
  • Optimizing Interactions with the Server
    • Describing the Standard Query and Standard DML Mechanisms
    • Identifying Data Sources and Targets
    • Using Alternative Data Sources and Targets
    • Requirements for Non-table Targets
    • Overview of Three-tier Architecture
    • Using the Module Component Application Program Interface (API)
    • Generating the API
  • Roundtrip Development
    • Overview of Design Capture
    • Capturing from a Form
    • Capturing from a PL/SQL Library
    • Running the Utility
    • Regenerating a Form
  • Preparing to Deploy Applications
    • Running the Dependency Analyzer
    • Describing File Storage in Oracle9i Designer
    • Identifying Version Issues
    • Moving an Application into Production

Course Calender

1 Sep 2022
Attend Now