Entegra Consultancy

Home / Training / Database Management / D203

D203

D203: Building Oracle8i Applications with Developer 2000 and PL/SQL – 3 Days

Who Should Attend:

System support consultants, system administrators, software engineers, database programmers, computer science students, and other IT professionals who intend to understand and use Oracle.

Objectives:

Particular emphasis will be placed on practical laboratory experience in creating powerful Oracle8 applications with the Developer/2000 package, and customizing these packages with PL/SQL programming.

In addition, the module will address aspects of Oracle Developer/2000 that have resulted in its reputation as a powerful and unique development environment for creating user-friendly, front-end interfaces to the Oracle8 database. Participants will be systematically guided with the aid of examples through an entire application development cycle using Developer/2000 and PL/SQL

At the end of this module, the participant should have a deeper understanding of how to use the Developer/2000 package to develop user-friendly database applications.

Contents:

Introducing Developer/2000: Building Forms, Report, and Graphics Applications. Unique features of database applications: recovery, concurrency, data independence, referential integrity, security, portability, data models, performance. Applications development using

Developer/2000: Form module, Menu module, Library module, Built-in Packages, Database objects. Development Life Cycle.

Prototyping with Developer/2000: Guidelines for Setting up Forms and Reports. Prototyping: Developing Form and Report Prototypes, Adding Graphics. Designing for Reuse: Recycling, Forms, Report, and Graphics Parameters. Forms Processes. Control and Menu Standards; Painting Canvas-Views, Viewing through Windows; Creating Custom Menus.

PL/SQL and Developer/2000: PL/SQL and Developer/2000 Built-in Exceptions; Using Blocks to Control Exception Handling; Subprograms; Nesting Blocks; Positioning Blocks in the Navigator; Using Packages; Built-in Packages; Creating, Attaching, and Using Libraries..

PL/SQL Model and Programming Basics: PL/SQL Block Structure; Types, Variables, Exceptions, Operators, and Control Structures. PL/SQL Records and Tables, SQL within PL/SQL, Built-in SQL Functions..

PL/SQL Cursors, Procedures, and Functions: What is a Cursor? Cursor Fetch Loops; Cursor Variables; Creating Procedures and Locations, Subprogram Locations, Subprogram Dependencies, Privileges and Stored Subprograms..

Packages and Triggers: Package Specification and Body; Scope; Package Initialization and Dependencies; Stored Functions. Creating Triggers; Triggers and Data Dictionary; Mutating Tables.

--------