home Contact Information
Courses
C Language
OPP Using C++
Java
Oracle
Developer 2000
Visual basic
Active Server pages
E-Commerce Contact Us


    Introduction to Developer2000

    Course Summary: The 56 hour course will consist of 36 hours of instructor-led training along with 20 hours of tutoring. The curriculum will include quizzes, hands-on exercises, and a case study.

    Course Objective: The student will understand the fundamental concepts of Developer/2000 and how it interacts with the Oracle database. Also, the student will apply the learned concepts in developing applications using Developer 2000.

    Pre-requisite: Able to function in Windows and DOS operating environments along with knowledge of RDBMS, SQL & PL/SQL.

Basic Developer/2000 Concepts
  • Architecture and components of tool set
  • The client/server implementation 

Building Forms

Creating a Form

  • Using the Object Navigator
  • Defining base table blocks

Using the Layout Editor 

  • Working with interface items 
  • Manipulating, arranging and formatting interface items as objects
  • How to define a consistent interface
  • Providing relevant user feedback objects
  • Selecting names, color and layout

Providing user feedback

  • Developing usefulnavigation aids
  • Creating alert boxes 

PL/SQL programming

  • Developing well-structuredcode
  • Using local, global andsystem variables

Procedures and functions

  • When to useOracle-supplied routines
  • Creating user-namedroutines
  • Using the Forms library tostore reusable code

Debugging Forms

  • Tracing triggers
  • Using the debugger facility
  • Break points and stackvariables

Defining blocks and block relations

  • Block navigation 
  • WHERE and ORDER BYclauses
  • Exploiting master-detailrelationships

Creating list of values and record groups

  • Creating record groups
  • Designing queries todisplay a list of values (LOV) 

Designing windows and canvasviews

  • Content views
  • Stacked views
Building well-designed menus
  • Using the Menu Editor 
  • Creating magic menu items 

Building Reports

The basic techniques 

  • Using default options
  • Using the Data Model Editor
  • Applying queries, groups and summaries

Designing report layouts

  • Specifying and developing layout components
  • Editing and manipulating layout objects
  • Creating master-detail and tabular layout formats

Applying advanced techniques

  • Building matrix reports
  • Using triggers for validating & formatting

Parameters and summarization

  • Utilizing user, system & lexical parameters
  • Defining and building parameter screens
  • Implementing group- and report-level data summaries 

Building Graphs

Examining Graphics components

  • Chart items and their properties
  • Data queries
  • Categories
  • Category values 

Building graphical displays

  • Editing the layout
  • Defining chart items and specifying queries used for populating the chart
  • Testing and executing graphical displays

Creating drill-down charts

  • Passing parameters between master and detail charts
  • Using layers to navigate between drill-down levels

Integrating Developer/2000 components

  • Creating integrated applications using menus, forms, reports and graphs
  • Passing parameters between forms 
    Communicating between modules

Case Study

Top
Top
Top
Contact

For a consultation to discuss your training needs, please
contact us at
770-458-2727 xtn 1701 or click here to send us email.

| Home | About Us | Services | Partners | Customers | WOL Advantage | Training | Careers |