Oracle Certified Database/Internet Application Developer (OCDBD)

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

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

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

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