Facets Demo New Batches Starting from Saturday... 22-10-2016
Search Course Here

Live Chat



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 business process, re-engineering to execution and maintenance of a system. It also provides a multi-user repository system.
  • Previous data and/or process modeling experience
  • Knowledge of Oracle RDBMS languages SQL and PL/SQL
  • It is a 12 days program and extends up to 2hrs each.
  • The format is 20% theory, 80% Hands-on.

  • It is a 3 days program and extends up to 8hrs each.
  • The format is 20% theory, 80% Hands-on.
    Private Classroom arranged on request and minimum attendies for batch is 4.
course 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 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 an LOV
    • Recapping how LOVs are Used
    • Defining and Using LOV Components
    • Including an LOV in a Module
    • Refining an 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
For Videos Click Here Videos

Flash News

AngularJS New Batch Start From 09th OCT & 10th OCT.

Hadoop Dev New Batch Start From 10th OCT & 11th OCT.

IBM COGNOS TM New Batch Start From 11th OCT & 12th OCT.

Informatica Dev New Batch Start From 12th OCT & 13th OCT.

Mean Stack New Batch Start 13th OCT & 14th OCT.

SAP BODS new Batch Starting From 14th OCT & 15th OCT.

SAP S/4 HANA New Batch Start From 15th OCT & 16th OCT

Tableau New Batch Start From 16th OCT & 17th OCT


Facets Demo Training

Demo Schedule : 08:30P.M EST / 07:30P.M CST / 05:30P.M PST on 21st OCT & 06:00A.M IST on 22nd OCT
Email :
Rediff Bol :
Google Talk :
MSN Messenger :
Yahoo Messenger :
Skype Talk :