iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

. Online Accounting        .Copyright & User Agreement   |

.Vision      .Biography     .Acknowledgement .Contact Us      .Comments/Suggestions       Email2aFriend    |

More Resources by Google:

Oracle Certified Database/Internet Application Developer (OCDBD)

In this course, participants will be introduced to Oracle 9i and SQL. Participants will learn how to create and maintain database objects and how to store, retrieve, and manipulate data. In addition, they will also learn how to create User Access Control (creating users, granting and revoking privileges).

Explore the Lifecycle Development Phases

• Define a database

• Discuss the theoretical, conceptual and physical aspects of a relational database

• Describe the Oracle implementation of the RDBMS and the ORDBMS

• Describe PL/SQL

Write and Execute a Basic SQL Statement

• Describe the SQL SELECT capabilities

• Differentiate between SQL and SQL*Plus commands

• Limit and sort the rows retrieved by a query

• Customize the SQL*Plus environment

• Save customizations

Examine Single Row Functions

• Use a variety of character, number, and date functions in SELECT statements

• Describe different types of join

• Group functions and their uses

• Insert and update rows in a table

• Delete rows from a table

• Define subqueries

• Write single-row, multi-row, and multi-column subqueries

• Control transactions

Create Tables and Views

• Describe the the main database objects

• Create tables

• Alter table definitions

• Drop, rename and truncate tables

• Including Constraints

• Retrieve data via a view

• Insert, update and delete data through views

• Drop views

• Alter the definition of a view

• Create and maintain sequences and indexes

Control User Access

• Understand the concepts of users, roles, and privileges

• GRANT and REVOKE object privileges

• Using Roles to Manage Database Access

In this course, participants will learn to write PL/SQL procedures, functions and packages. Working in both the Procedure Builder and the SQL*Plus environments, participants will learn how to create and manage PL/SQL program units and database triggers. Participants will also learn how to use some of the Oracle supplied packages.

Overview of PL/SQL

• PL/SQL Syntax

• Declaring Variable, Datatypes, Constants

• Expressions, Assignment Statements, Conditional Statments

• Loops

• Cursors

• Advanced Datatypes

• Exception Handling

• Working with Blocks, Nested Blocks

• An Introduction to Program Units

Work with Procedure Builder

• Describe the features of Procedure Builder

• Manage program units using the Object Navigator

• Create and compile program units using the Program Unit Editor

• Invoke program units using the PL/SQL interpreter

Create Procedures

• Describe the uses of procedures

• Create client-side and server-side procedures

• Create procedures with arguments

• Invoke a procedure

• Remove a procedure

Create Functions

• Describe the uses of functions

• Create client-side and server-side functions

• Invoke a function

• Remove a function

• Differentiate between a procedure and a function

Create Packages

• Describe packages and list their possible components

• Create a package to group together related variables, cursors, constructs, exceptions, procedures and functions

• Make a package construct either public or private

• Invoke a package construct

• Write packages that make use of the overloading feature of PL/SQL

• Avoid errors with mutually referential subprograms

• Initialize public or private variables with an automatic one time only procedure

• Declare ref cursors in a package

• Control the extent to which functions permit database operations

• describe the use and application of the Oracle supplied packages

Create Database Triggers

• Describe database triggers and their use

• Create database triggers

• Describe database trigger firing rules

• Drop database triggers

Manage Subprograms

• Describe system privilege requirements

• Track procedural dependencies

• Predict the effect of changing a database object upon stored procedures and functions

• Describe object dependencies

• Debug client-side and server-side subprograms

Work with Object Types

• Describe object types

• Create transient objects

• Manipulate objects in object tables

Manage Large Objects

• Compare and contrast LONG and LOB (large object) datatypes

• Create and maintain LOB datatypes

• Differentiate between internal and external LOBs

• Utilize the DBMS_LOB PL/SQL packages

In this course, participants will learn how to build and test interactive applications and will work in a graphical user interface (GUI) environment. They will learn how to customize forms with user input items such as check boxes, list items and radio groups. Participants will also learn how to modify data access by creating event-related triggers.

Introduction to Oracle Forms 6i

• Overview of the Oracle Forms 6i Package 

• Features and Benefits of Using Oracle Forms 6i 

• Component Groups in Oracle Forms 6i 

• Introduction to Oracle Forms 6i Builder Tools 

• Builder Tools for Project Management

• Builder Tools for Front-End Development

• Builder Tools for Back-End Development 

Form Builder

• Working in the Form Builder Environment

• Identifying the Main Components of Form Builder 

• Identifying the Main Objects in a Form Module

• Creating Basic Form Modules 

• Creating a Form Module

• Using the Data Block Wizard to Create and Modify Data Blocks

• Creating and Modifying Layouts Using the Layout Wizard  

• Creating, Saving, Compiling, and Running a Form Module                                

• Form Builder File Formats and Their Characteristics                                

• Creating Data Blocks with Relationships                                

• Running a Master/Detail Form Module                                

•  Running a Form Builder Application                                

• Understanding the Runtime Environment                                

• Navigating a Form Builder Application                                

• Understanding the Two Modes of Forms Runtime Operation                                

• Retrieving Data into a Form Builder Application                                

• Inserting, Updating, and Deleting Records                                 

Forms Design

• Working with Text Items 

• Introduction to Text Items 

• Modifying a Text Item's Appearance 

• Controling the Data i n a Text Item 

• Modifying the Navigational Behavior of a Text Item 

• Enhancing the Relationship Between the Text Item and a Database

• Modifying the Functionality of a Text Item  

• Including Help Messages in Your Applications                                

• Creating LOVs and Editors

• Introduction to LOVs and Editors

• Creating Additional Input Items   

• Introduction to Item Types that Allow Input   

• Creating a Check Box 

• Creating a List Item

• Creating a Radio Group

• Creating Noninput Items 

• Introduction to Item Types that Do Not Allow Input 

• Creating a Display Item 

• Creating an Image Item

• Creating a Sound Item

• Creating a Button 

• Creating a Calculated Field

• Creating Windows and Content Canvases

• Introduction to Windows and Content Canvases 

• Window and Content Canvases Properties 

• Displaying a Form Module in Multiple Windows

• Working with Other Canvases

• Introduction to Canvas Types

• Creating an Overlay Effect Using Stacked Canvases

• Creating a Toolbar

• Creating a Tabbed Interface

Working with Triggers

• Introduction to Form Triggers 

• Definition of a Trigger

• Form Trigger Categories 

• Form Trigger Types and Scope

• Form Trigger Properties

• How to Produce Triggers 

• Writing Trigger Code 

• Understanding the Use of Built-in Subprograms

• Introduction to the When-Window-Closed Trigger

• Adding Functionality to Form Items

• Supplementing the Functionality of Input Items

• Supplementing the Functionality of Noninput Items 

• Using Query Triggers

• Data Block Query Process and Triggers

• Writing Triggers That Screen Query Conditions

• Writing Triggers to Supplement Query Results 

• Debugging Triggers

• Running a Form Module in Debug Mode

• Understanding the Components of the Debugger

• Debugging PL/SQL Code

Forms Processing

• Forms Runtime Messages and Alerts

• Introduction to the Default Messaging 

• Handling Errors Using Built-in Subprograms 

• Controlling System Messages

•  Creating and Controlling Alerts 

• Data Validation 

• Effects of the Validation Unit on a Form

• Introduction to Form Builder Validation Properties 

• Controlling Validation Using Triggers 

• Navigation 

• Internal versus External Navigation 

• Using Navigation Triggers 

• Introduction to Built-Ins That Cause Navigation

• Transaction Processing

• Commit Processing, Transaction Processing, and Triggers

• Allocating Automatic Sequence Numbers to Records

Forms Programming

• Writing Flexible Code

• Flexible Code and System Variables

• Built-In Subprograms that Assist Flexible Coding 

• Writing Code to Reference objects by internal ID

• Writing Code to Reference Objects Indirectly

•  Sharing Objects and Code

• Inheriting Properties from Property Classes 

• Grouping Related Objects for Reuse

• Reusing objects from an Object Library

• Reusing PL/SQL Code 

• Managing Multiple-Form Applications

• Defining Multiple-Form Functionality

• Calling One Form from Another

In this course, participants will gain an opportunity to broaden their form-building skills. Participants will create Menu Modules. Participants will also learn how to create multiple-form applications and will practice enhancing their applications with custom menus, and advanced programming.

Course Topics

Working with Menu Modules

• Creating Menu Modules

• Menu Components

• Creating, Saving, and Attaching Menu Modules

• Setting Menu Properties Using the Property Palette

• Creating Menu Toolbars

• Creating Pop-up Menus

• Managing Menu Modules

• Controlling the Menu Programmatically

• Customizing Menu Modules with Substitution Parameters 

• Implementing Menu Security

Advanced Forms Programming I

• Programming Function Keys

• Redefining Function Keys 

• Determining When Key Triggers Should Be Used 

• Responding to Mouse Events 

• Introduction to Mouse Events

• Causing a Form Module to Respond to Mouse Movement

• Causing a Form Module to Respond to Mouse Button Actions

• Controlling Windows and Canvases Programmatically 

• Creating Trigger Code to Interact with Windows

• Controlling Windows Programmatically 

• Controlling  Canvases 

• Controlling Data Block Relationships

• Definition of Block Coordination 

• Creating and Modifying Relations

• Characteristics of Relation-Handling Code

• Implementing a Coordination-Type Toggle

Advanced Forms Programming II

• Building Multiple-Form Application

• Different Ways to Invoke Forms

• Building Robust Multiple-Form Transactions

• Passing Data Between Forms Using Parameter Lists

• Defining Data Sources

• Introduction to Diverse Data Source Types

• Selecting Appropriate Data Sources for Data Blocks

• Working with Record Groups

• Creating Record Groups at Design time

• Creating and Modifying Record Groups Programmatically  

• Building Dynamic List Items by Using Record Groups 

• Using a Global Record Group to Communicate Between Forms                                             

Advanced Forms Programming III

• Including Charts in Forms

• Using the Chart Wizard to Embed Charts in a Form

• Applying Timers to Form Objects

• Creating a Timer 

• Deleting a Timer

• Modifying a Timer 

• Utilizing Reusable Components 

• Introduction to the Reusable Components 

• Using the Calendar Class in an Application

• Using Server Features in Form Builder

• Introduction to Oracle Server Features in Form Builder

• Partitioning PL/SQL Program Units

• Recognizing the PL/SQL8 Features Supported in Forms 6i

• Handling Errors Raised by the Oracle Server

• Performing DDL Commands