Oracle Certification Developer Training
Oracle Application Developer Certification CBT CD-ROM Based Training
 In the NETg Complete Oracle Certified Application Developer Track for Developer Release 2 curriculum (Ver. III), students will learn about the
concepts of relational databases and the SQL and PL/SQL programming languages, and writing PL/SQL procedures. In addition, they will learn about functions and packages,
customizing forms, using Project Builder, enhancing applications, and creating and enhancing reports. This curriculum is based on Developer/2000 Release 2, Forms 5, Reports 3. This
comprehensive curriculum consists of 15 courses to help sharpen your application development skills:
Live Boot Camp Classes
This curriculum helps Oracle Certified Professional (OCP) candidates prepare for 5 Certification exams: 1Z0-001, 1Z0-101, 1Z0-121, 1Z0-122, 1Z0-123
|
Oracle Certification 8i Certified Database Administrator CBT Exams 1Z0-001,023,024,025,026
|
n63312D
|
$1375.00
|
|
|
Oracle Certified Application Developer
|
n61222D
|
$1750.00
|
|
Oracle Certification Certified Application Developer Track
2000 Course on CD-ROM for SQL and PL/SQL Programming, Forms and Report Builder
Course Overview
61110 - Oracle SQL and PL/SQL: Basic SELECT Objectives
Unit 1: Relational Database Concepts
• Define components of the relational model.
• Identify the structural elements of a relational database.
• List the properties of a relational database.
• Identify the phases of the system development life cycle.
• Identify the three components of an entity relationship model.
• Indicate the diagramming conventions used in entity relationship modeling.
• List characteristics of object relational database management systems.
• Identify the benefits of Oracle's implementation of object relational technology.
• Define the tools used to interact with the Oracle server.
• Identify the types of SQL statements.
Unit 2: Writing Basic SQL 1
• List capabilities of SQL SELECT statements.
• Identify the mandatory elements of a SELECT statement.
• Identify methods for executing SELECT statements.
• Write a SELECT statement that displays all columns and rows of a table.
• Write a SELECT statement that displays specific columns from a table.
• Identify precedence in evaluating an arithmetic expression within a SQL statement.
• Specify an alias for a column heading when extracting data from a table.
• Concatenate multiple columns that are selected from a table.
• Embed a literal character string in a SELECT clause to customize the output displayed.
• Use the DISTINCT keyword to eliminate duplicate rows from the output of a query.
• Manage null values using the NVL function in a SELECT statement.
• Identify the differences between SQL*Plus commands and SQL statements.
• Log in to SQL*Plus through a Window environment.
• Display the structure of a table using the DESCRIBE command.
• Identify SQL*Plus commands used to edit SQL statements.
• Identify SQL*Plus commands used to manage the contents of the SQL buffer.
Unit 3: Restricting and Sorting Data: Write a query that restricts rows returned by using the WHERE clause
• Identify guidelines for specifying literal strings in a WHERE clause.
• Compare one expression to another within a WHERE clause.
• Display rows within a range of values by using the BETWEEN operator.
• Display rows that match a list of values by using the IN operator.
• Perform wildcard searches by using the LIKE operator.
• Display rows containing null values by using IS NULL operator.
• Write a combined expression by using the AND operator in a WHERE clause.
• Write a combined expression by using the OR operator in a WHERE clause.
• Restrict rows by using the NOT operator in a WHERE clause.
• Identify precedence rules when evaluating conditions that use comparison and logical operators.
• Sort rows retrieved in ascending order using the ORDER BY clause.
• Sort rows retrieved in descending order using the DESC keyword in the ORDER BY clause.
• Sort rows retrieved by using a column alias in the ORDER BY clause.
• Sort rows retrieved by more than one column.
Unit 4: Single-Row Functions
• Identify features of a SQL function.
• Identify the two types of SQL functions.
• Identify the features of a single-row function.
• Convert alpha characters to lowercase by using the LOWER function.
• Convert alpha characters to uppercase by using the UPPER function.
• Capitalize the first letter of each work in a character value by using the INITCAP function.
• Display the number of characters in a value by using the LENGTH function.
• Round a value to a specified decimal place by using the Round function.
• Truncate a value to a specified decimal place by using the TRUNIC function.
• Return the remainder of one value divided by another by using the MOD function.
• Identify the common Oracle date formats.
• Select the current date by using the SYSDATE function.
• Perform arithmetic operations on dates.
• Identify common SQL date functions.
• Identify common data type conversion functions.
• Convert a date value to a character string by using the TO_CHAR function.
• Convert a number to a character string by using the TO_CHAR function.
• Evaluate single row functions that are nested.
back to top
61111 - Oracle SQL and PL/SQL: Data Retrieval Techniques
Objectives
Unit 1: Displaying Data From MultipleTables
• Identify the four join types used to display data from more than one table.
• Identify a Cartesian product.
• Retrieve rows from two tables by using an equijoin.
• Specify additional search conditions in an equijoin by using the AND operator in the WHERE clause.
• Simplify a query by using a table alias in an equijoin.
• Retrieve rows from more than two tables by using an equijoin.
• Retrieve rows from two tables by using a non-equijoin.
• Retrieve rows from two tables by using an outer join.
• Retrieve rows within the same table by using a self join.
Unit 2: Group Functions
• Identify the features of a group function.
• Write SQL statements that contain common group functions.
• Manage null values when using group functions in a SQL statement.
• Group rows retrieved by using the GROUP BY clause.
• Retrieve a subgroup of rows from within a larger group retrieved by using the GROUP BY clause.
• Restrict groups of rows retrieved by using the HAVING clause.
• Identify illegal queries involving group functions.
• Write a SQL statement that contains nested group functions.
Unit 3: Subqueries
• Identify the requirements for using subqueries.
• Identify the characteristics of three subquery types.
• Write a single-row subquery to return one row in the WHERE clause of a SELECT statement.
• Retrieve data that is dependent upon the value of a group function in a single-row subquery.
• Write a single-row subquery in the HAVING clause of a SELECT statement.
• Identify two common errors that occur when using single-row subqueries.
• Identify the guidelines for using multiple-row subqueries.
• Write a multiple-row subquery.
• Identify how a query handles null values returned from a multiple-row subquery.
• Write a multiple-column subquery.
• Identify the different output that results from pairwise and nonpairwise subqueries.
• Write a multiple-column subquery in the FROM clause of a SELECT statement.
Unit 4: Reporting with SQL*Plus 2 hours
• Identify the characteristics of substitution variables.
• Prompt the user for a number value using a variable prefixed with a single ampersand.
• Prompt the user for character and date values using a variable prefixed with a single ampersand and surrounded by single quotation marks.
• Specify column names and expressions at run time using substitution variables.
• Prompt the user for a value using a variable prefixed with a double ampersand.
• Accept user input at run time using the ACCEPT command.
• Maintain a variable at run time using the DEFINE and UNDEFINE commands.
• Match the SET command variables with their functions.
• Identify the guidelines for using the SQL*Plus format commands.
• Control the display of a column using the COLUMN command options.
• Group related rows using the BREAK command.
• Format page headers and footers using the TTITLE and BTITLE format commands.
• Run a formatted report using a SQL*Plus script file.
back to top
61112 - Oracle SQL and PL/SQL: DML and DDL Objectives
Unit 1: Creating Tables and Constraints
• Identify the main database objects and their structures.
• Reference the tables of another user when appropriate permission has been granted.
• Name database objects according the Oracle naming conventions and guidelines.
• Identify the syntax of the CREATE TABLE statement.
• Identify the use of constraints as a means of enforcing data integrity.
• Prohibit null values using the NOT NULL constraint.
• Define a unique constraint for a column to ensure that two rows do not contain the same value.
• Define a PRIMARY KEY constraint using the CREATE TABLE statement.
• Create a referential integrity constraint for a foreign key column.
• Define a check constraint to ensure that appropriate values are stored in the table.
• Create a table within the SQL*Plus environment.
• Create a table using the rows from an existing table.
• Display the structure of a table, using the DESCRIBE command.
Unit 2: Manipulating Data
• Identify the DML functions and the transaction control commands.
• Insert new rows in a table.
• Insert specific date, time, and user values in a table.
• Insert rows from one table into another table.
• Update a row without violating the integrity constraints for that table.
• Update an entire column in a database table.
• Delete rows from a table.
• Identify the actions that start and end a transaction.
• Execute the COMMIT, SAVEPOINT, and ROLLBACK statements.
• Roll back pending data changes.
• Rollback pending changes to a specified savepoint.
Unit 3: Altering Tables and Constraints
• Add a new column to an Oracle database table by using the ALTER TABLE statement.
• Modify the columns of an Oracle8 table by using the ALTER TABLE statement.
• Add a constraint to an Oracle table by using the ALTER TABLE statement.
• Remove a constraint from a table by using ALTER TABLE statement.
• Manage constraints by using the DISABLE and ENABLE clauses.
• Remove a table from an Oracle database.
• Rename a table in an Oracle database.
• Remove all rows from a table without generating rollback information.
• Manage comments on a table or column in an Oracle database by using the COMMENT clause.
Unit 4: Creating Sequences
• Identify the features of a sequence.
• Create a sequence by using an SQL statement.
• Display sequence values from a data dictionary table.
• Identify the rules of using NEXTVAL and CURRVAL.
• Modify a sequence using the ALTER SEQUENCE statement.
• Remove a sequence using the DROP SEQUENCE statement.
Unit 5: Creating Views
• Identify the advantages of creating views.
• Identify CREATE VIEW statement syntax used to create a view in an Oracle database.
• Create a simple view.
• Create a complex view, to display values from two tables.
• Remove a view from an Oracle database.
• Identify the rules for performing DML operations on views in an Oracle database.
• Restrict the use of DML operations on a base table by using the WITH CHECK OPTION clause.
• Prevent the use of DML operations on a view by using the WITH READ ONLY clause.
• Display details about a user's views by selecting data from the data dictionary.
Unit 6: Creating Indexes
• Identify the characteristics of an index.
• Identify the different index types.
• Create an index.
• Display the indexes in the data dictionary view.
• Drop an index.
Unit 7: Controlling User Access
• Identify the features of database security.
• Create a user with an identifying password.
• Change the password of a user by using the ALTER USER statement.
• Grant privileges to a user by using the GRANT statement.
• Grant privileges to a role.
• Grant object privileges to a user by using the GRANT statement.
• Grant object privileges to a user by using the option WITH GRANT OPTION.
• Identify the seven privilege-related views in the data dictionary.
• Revoke the privileges granted to a user by using the REVOKE statement.
• Create a synonym for a table using the CREATE SYNONYM statement.
• Remove a synonym by using the DROP SYNONYM statement.
back to top
61113 - Oracle PL/SQL: Basics Objectives
Unit 1: PL/SQL: An Introduction
• Identify the features of PL/SQL.
• Identify the benefits of PL/SQL.
• Select the actions by which a PL/SQL engine processes a block of code.
• Identify the features of the sections of a basic PL/SQL block.
• Match the PL/SQL program constructs with their features.
• Identify the syntax rules to be applied in creating a PL/SQL block.
Unit 2: Developing a Simple PL/SQL Block
• Identify the functions of PL/SQL variables.
• Identify the guidelines for declaring PL/SQL variables.
• Match the PL/SQL datatypes with their descriptions.
• Match the scalar datatypes with their descriptions.
• Declare a scalar variable.
• Declare a scalar variable with the %TYPE attribute.
• Write the code to assign a value a to a variable by using the assignment operator.
• Use operators with the PL/SQL variables.
• Manipulate data in PL/SQL variables by using SQL functions.
• Convert the datatype of a variable by using a data conversion function.
• Identify the features of variable scoping in nested PL/SQL blocks.
• Create a bind variable in the SQL*Plus environment.
• Identify the case conventions for writing PL/SQL code.
• Match the identifiers with their naming conventions.
Unit 3: Accessing the Database Using PL/SQL
• Retrieve data from a table by using the SELECT statement..INTO statement.
• Identify the conditions in which various SELECT exceptions are raised.
• Write the code to add rows to a table by using the INSERT statement.
• Write the code to modify the existing data in a table by using the UPDATE statement.
• Write the code to delete data from a table by using the DELETE statement.
• Identify the features of a SQL cursor.
• Match the SQL cursor attributes with their descriptions.
• Write the code to confirm the current transaction by using the COMMIT command.
• Write the code to discard the changes made to the table by using the ROLLBACK command.
• Write the code to control the transaction at the intermediate point by using the SAVEPOINT command.
Unit 4: Controlling Flow in PL/SQL Blocks
• Write PL/SQL code using the IF-THEN-ELSE statement.
• Write PL/SQL code using the IF-THEN-ELSIF statement.
• Match a condition that uses logical operators with its result.
• Write the code for a basic loop to insert records into a table by using the LOOP keyword.
• Write the code to execute a set of statements repeatedly by using the FOR LOOP keyword.
• Write the code to execute a set of statements repeatedly by using the WHILE LOOP.
• Identify the features of a nested loop.
Unit 5: Composite Datatypes
• Declare a PL/SQL record by using the RECORD datatype.
• Reference a PL/SQL record.
• Declare PL/SQL records with %ROWTYPE.
• Declare a PL/SQL table by using the TABLE datatype.
• Reference a PL/SQL table.
• Match the methods used to operate on PL/SQL tables with their descriptions.
• Identify the syntax to reference a table of records.
• Match the LOB datatypes with their descriptions.
• Identify the features of LOB variables in PL/SQL.
Unit 6: Explicit Cursors
• Identify the declaration methods of cursors, both implicit and explicit.
• Sequence the steps for controlling explicit cursors.
• Write the code to declare a cursor by using the CURSOR statement.
• Write the code to open a cursor by using the OPEN statement.
• Retrieve rows from a cursor by using the FETCH statement.
• Close a cursor by using the CLOSE statement.
• Check the status of a cursor by using the %ISOPEN attribute.
• Check the status of a cursor by using the %FOUND attribute.
• Check the status of a cursor by using the %NOTFOUND attribute.
• Write the code to fetch a specified number of rows from a cursor by using the %ROWCOUNT attribute.
• Write the code to process the rows of the active set conventionally by fetching values into a
PL/SQL record.
• Write the code to process rows in an explicit cursor using cursor FOR loops.
• Pass parameters to a cursor when a cursor is opened by using the cursor_name parameter.
• Lock the records by using the FOR UPDATE clause.
• Write the code to update the latest fetched row by using the WHERE CURRENT OF clause.
Unit 7: Handling Exceptions
• Match the types of exceptions with their properties.
• Match some common predefined Oracle server exceptions with their descriptions.
• Identify the guidelines to trap exceptions.
• Complete the code to trap predefined exceptions.
• Complete the code to trap nonpredefined exceptions.
• Complete the code to trap user-defined exceptions.
• Match the functions for identifying the associated error message or error code with their descriptions.
• Match each calling environment with its error-handling method.
• Use the RAISE_APPLICATION_ERROR procedure to raise user-defined error codes and messages.
back to top
61114 - Oracle PL/SQL: Procedures, Functions and Packages Objectives
Unit 1: Subprograms: Procedures
• Match the various sections of a subprogram with their contents.
• Identify the components of developing environments.
• Identify the steps to create a subprogram.
• Identify the features of the different types of parameter modes.
• Perform the steps to create a client-side procedure by using Procedure Builder.
• Perform the steps to create a server-side procedure by using SQL*Plus.
• Identify the different methods for passing parameters.
• Perform the steps to create a bind variable by using SQL*Plus.
• Perform the steps to invoke a procedure from SQL*Plus.
• Perform the steps to invoke a procedure from another procedure by using SQL*Plus, a debug session in Procedure Builder.
Unit 2: Subprograms: Functions
• Perform the steps to create a client-side function by using Procedure Builder.
• Perform the steps to create a server-side function by using SQL*Plus.
• Perform the steps to invoke a function using Procedure Builder.
• Perform the steps to invoke a function using SQL*Plus.
• Identify the advantages of user-defined functions in SQL expressions.
• Identify the restrictions when calling user-defined functions from SQL expressions.
• Perform the steps to remove a subprogram.
• Identify the differences between a procedure and a function.
Unit 3: PL/SQL Packages
• Identify the uses of packages.
• Identify the features of package components.
• Identify the advantages of using packages.
• Create the statement of a package specification in SQL*Plus.
• Create the statement of a package body by using SQL*Plus.
• Match the Procedure Builder built-in packages with their features.
• Create the statement to invoke package constructs by using SQL*Plus.
• Identify how to reference a global variable within a package by using SQL*Plus.
• Identify the effect of the persistent state of a package cursor on dependent processor.
• Create the statement to remove a package.
• Perform the steps to start a debug session for a subprogram by using the PL/SQL Interpreter.
• Perform the steps to set a breakpoint by using the PL/SQL Interpreter in the Procedure Builder.
• Step through the code to determine the cause of an error by using the debug command icons.
• Perform the steps to modify local variable values in a debug session by using Procedure Builder
back to top
61115 - Oracle PL/SQL: Database Programming Objectives
Unit 1: Developing Program Units
• Select the processes involved in creating a stored procedure and a stored function using SQL*Plus.
• Identify the effects of storing code separately on the server and on the client.
• Perform the steps required to create a stored procedure using SQL*Plus.
• Perform the steps required to create a stored function using SQL*Plus.
• Match runtime exceptions with their descriptions and the directions for their handling.
• Perform the steps required to create a stored package using SQL*Plus.
• Perform the steps to invoke stored procedures in SQL* Plus using IN and OUT parameters.
• Perform the steps required to invoke a stored function using SQL* Plus.
• Perform the steps required to invoke a stored subprogram with multiple arguments in SQL* Plus.
• Identify the rules for calling user-defined functions in SQL expressions.
Unit 2: Oracle Supplied Packages
• Match the different Oracle supplied packages with their uses.
• Identify correct combinations of DBMS_PIPE subprograms and their uses.
• Identify the uses of the DBMS_DDL package.
• Match the subprograms of the DBMS_JOB package with their uses.
• Match the subprograms of the DBMS_OUTPUT package with their uses.
• Perform the steps to output messages onto the screen using the DBMS_OUTPUT package.
• Identify the uses of dynamic SQL.
• Sequence the steps needed to use the DBMS_SQL package to write dynamic SQL.
• Match the DBMS_SQL subprograms with their descriptions.
• Perform the steps required to write dynamic SQL using EXECUTE IMMEDIATE.
• Identify the distinctive properties of a LOB datatype.
• Identify the features of internal LOBs.
• Identify the features of external LOBs.
Unit 3: Managing Subprograms and Packages
• Identify the steps involved in managing subprograms using SQL*Plus.
• Perform the steps to display details about stored subprograms from the Oracle data dictionary.
• Perform the steps required to display compile time errors stored in the Oracle data dictionary.
• Perform the steps required to grant privileges on a stored subprogram using SQL*Plus.
• Identify the correct combination of different types of dependencies and their description.
• Perform the steps required to display dependencies stored in the Oracle data dictionary.
• Identify the situations in which a dependent subprogram can be recompiled.
• Identify how the Oracle server remote dependency mechanism works.
• Match the different tasks involved in managing packages with the methods of implementing them.
• Identify the features of package dependency.
Unit 4: Developing Database Triggers
• Match the sections of a database trigger with their descriptions.
• Perform the steps required to create statement level and row level database triggers.
• Perform the steps required to create an INSTEAD_OF database trigger.
• Perform the steps required to create a schema level trigger.
• Perform the steps required to create a BEFORE and an AFTER trigger.
• Identify the rules to be followed while reading or writing data using triggers.
• Match the components of the Procedure Builder Trigger Editor with their uses.
• Match the tasks performed in an Oracle database with the role triggers have in achieving them.
• Perform the steps required to manage database triggers.
back to top
61211 - Oracle Form Builder: Forms Fundamentals Objectives
Unit 1: Developer/2000 and Form Builder: An Overview
• Identify the features of Developer/2000.
• Match the components of Developer/2000 with the tasks that they enable.
• Identify the common features of Developer/2000 Components.
• Identify the features of Oracle Toolkit.
• Identify the features of the Developer/2000 main menu.
• Set preferences to customize a Developer/2000 session by using the Preferences dialog box.
• Match the main environment variables with their descriptions.
• Identify the tasks that various Form Builder executables enable.
• Match each Form Builder module type with its corresponding description.
• Identify the descriptions of the main components of a Form Module.
• Identify the features of the Form Builder block types.
• Match each Form module object type with its description.
Unit 2: Running and Creating a Form Module
• Match the components of the Form Builder runtime environment with their features.
• Match the different methods for navigating the Form Builder Runtime with their features.
• Identify the tasks that can be performed in the two modes of Forms Runtime operation.
• Perform an unrestricted query by using the default functionality.
• Perform a restricted query by using the Query Where dialog box.
• Insert a record by using the default functionality.
• Update a record by using default functionality.
• Delete a record by using the default functionality.
• Make changes permanent by using the menu option.
• Display runtime errors by using the help option.
• Exit a runtime session by using the menu option.
• Using a specified option, create a new form module by invoking the Form Builder Wizard.
• Create a new form module in a Form Builder component by using a given method.
• Set the properties of a form module in the Object Navigator by using the Property Palette.
• Identify the features of the Form Builder wizards.
• Create a new data block by using the Data Block Wizard.
• Modify a layout of a data block by using the Layout Wizard in reentrant mode.
• Deliver a form module based on given specifics.
• Match the module type extensions with their storage format.
• Identify and create a master-detail relationship.
• Identify the definition of a master-detail relationship.
• Create a master-detail form module by using the Data Block Wizard.
Unit 3: Customizing a Form Module
• Match the component names with their components in the Property Palette.
• Create a visual attribute in the Object Navigator by using the Create icon.
• Modify the properties that control the behavior of a data block by using the Property Palette.
• Modify the properties that control the appearance of a data block by using the Property Palette.
• Modify the frame properties of a data block by using the Property Palette.
• Set properties on multiple objects by using the Property Palette.
• Create a control block in the Object Navigator by using the Create icon.
• Delete a data block in the Object Navigator by using the Delete icon.
• Create a text item in a builder component by using a specific method.
• Modify the appearance of a text item by using the Property Palette.
• Modify the properties that control the data of a text item by using the Property Palette.
• Modify the properties that enhance the relationship between text item and database by using
the Property Palette.
• Modify the properties that add functionality to a text item by using the Property Palette.
• Modify the properties that alter the navigational behavior of a text item by using the Property Palette.
• Modify the properties that provide context sensitive help by using the Property Palette.
back to top
61212 - Oracle Form Builder: Enhancing the User Interface Objectives
Unit 1: Creating
• Identify and create input items.
• Identify the input item types.
• Create a check box in the Layout Editor by using the Check Box tool.
• Convert an existing item into a check box in the Layout Editor by using the Property Palette.
• Create a list item in the layout Editor by using the List Item tool.
• Convert an existing item into a list item in the Layout Editor by using the Property Palette.
• Create a radio group item in the Layout Editor by using the Radio Button tool.
• Convert an existing item into a radio group item in the Layout Editor by using the Property Palette.
• Identify non-input item types.
• Create a display item in the Layout Editor by using the Display Item tool.
• Create an image item in the Layout Editor by using the Image Item tool.
• Create a sound item in the Layout Editor by using the Sound Item tool.
• Create a button in the Layout Editor by using the Button tool.
• Create a calculated field based on a formula by creating a new item using the Create icon in the Object Navigator.
• Create a calculated field based on a summary by creating a new item using the Create icon in the Object Navigator.
Unit 2: LOVs and Editors
• Create and attach LOVs and Editors.
• Identify the features of LOVs.
• Identify the objects required to design a LOV.
• Identify the uses of record groups.
• Create a LOV by using the New LOV dialog box.
• Set LOV properties by using the Property Palette.
• Attach a LOV with a text item by using the Property Palette.
• Create a customized editor by using the Create icon in the Object Navigator.
• Attach an editor with a text item by using the Property Palette.
Unit 3: Windows and Canvases
• Match the display objects with their definitions.
• Match the types of windows with their features.
• Identify the definition of a content canvas.
• Identify the benefits of creating a new window.
• Create a new window by using the Create icon in the Object Navigator.
• Set the window object properties by using the Property Palette.
• Create a content canvas by using the Create icon in the Object Navigator.
• Set the Window property of a content canvas by using the Property Palette.
• Create a stacked canvas by using an appropriate method.
• Set the stacked canvas properties by using the Property Palette.
• Check the display position of a stacked canvas in the Layout Editor.
• Create a toolbar canvas by using the Object Navigator.
• Set the toolbar canvas-related properties by using the Property Palette.
• Create a tab canvas by using an appropriate method.
• Set tab canvas-related properties by using the Property Palette.
Unit 4: Form Builder Triggers
• Identify the events that invoke a trigger.
• Identify the trigger type given their description.
• Match the scope of a trigger with their description.
• Identify the statements that are allowed in trigger code.
• Match the execution hierarchy of a trigger with their description.
• Create a trigger by using an appropriate method.
• Match the PL/SQL Editor components with their description.
• Match the trigger properties with their descriptions.
• Identify the rules for writing trigger code.
• Match the Form builder variable name with their type.
• Match the standard built-in subprogram names with their descriptions.
• Copy a built-in name and argument in an existing code.
Unit 5: Adding Functionality
• Create a trigger to add functionality to a radio group.
• Add functionality to a check box by creating a trigger containing the CHECKBOX_CHECKED built-in.
• Add functionality to a List Item by creating a trigger containing built-ins.
• Display LOV from a button by creating a trigger containing the SHOW_LOV built-in.
• Display an image in an image item by creating a trigger containing the READ_IMAGE_FILE built-in.
• Identify the built-ins that can be used to hide or display or get information about each
component of a sound item control programmatically.
back to top
61213 - Oracle Form Builder: Writing and Debugging Code Objectives
Unit 1: Runform Messages and Alerts
• Match the communication formats used by Form Builder with their descriptions.
• Write the code for detecting an error by using built-ins.
• Write the code to control system messages by using system variables.
• Write the code to explicitly fail a trigger by using the FORM_TRIGGER_FAILURE exception.
• Identify the uses of the Error triggers.
• Create an alert by using the Create icon in the Object Navigator.
• Write the code to control an alert at runtime by using the built-in sub programs.
Unit 2: Debugging PL/SQL Code
• Run a form module in the Debug mode by using the Debug Mode toolbar button in the Object Navigator.
• Match the PL/SQL Debugger components with the tasks that they enable.
• Set a breakpoint in code by using the Source pane of the Forms Debugger window.
• Identify the user-defined debug actions that occur automatically during debugging.
• Match the debug commands with their functions.
• Debug PL/SQL code to identify the cause of an error by using the Forms Debugger window.
Unit 3: Query Processing
• Sequence the events that take place when a query is initiated on a data block.
• Identify the sources for the different clauses of the default SELECT statement.
• Write the code for a Pre-Query trigger at the data block level.
• Write the code for a Post-Query trigger at the data block level.
• Implement query array processing in a Form Builder application.
• Write a code for a trigger to fire in the Enter Query mode by using the SYSTEM.MODE variable.
• Match the transactional triggers that override default query processing in Form Builder with
their characteristics.
• Match the block properties with the associated built-ins that can be used to manipulate query information.
Unit 4: Validation and Navigation
• Sequence the steps of the validation process used by Form Builder.
• Set the Validation Unit property of a form by using the pop-up menu.
• Validate a value entered in an item by using a List Of Values (LOV).
• Write the code for a trigger to validate user inputs at different levels.
• Match the built-ins for validation with their functions.
• Sequence the Form Builder navigation units according to their navigation hierarchy.
• Match the navigation properties with their characteristics.
• Match the navigation trigger types at different levels with their uses.
• Write the code for the When-New-Object-Instance trigger at different levels.
• Specify the built-ins used for navigation, given their functions.
Unit 5: Transaction Processing
• Identify the events that take place during the different phases of transaction processing.
• Sequence the events that take place during commit processing.
• Match the different types of commit triggers with the conditions under which they fire.
• Match the different types of commit triggers with their common uses.
• Write a Pre-Delete trigger to implement a validation before the deletion of a row.
• Write a Pre-Insert trigger to assign sequence numbers to records.
• Write a Post-Update trigger to record audit information about the changes applied to base tables.
• Write the code to test the result of a DML operation in a trigger by using the attributes of
PL/SQL implicit cursors.
• Identify the rules followed by Form Builder while issuing DML statements during commit processing.
• Write an On-Logon trigger to override the default logon process.
• Identify the different ways to run Form Builder against non-Oracle data sources.
• Match the commit status values returned by different system variables with their implications.
• Write the code to manipulate the commit status of a record by using built-ins in the code.
• Implement array DML processing in a Form Builder application.
Unit 6: Writing Flexible Code
• Identify the benefits of writing flexible code.
• Write the code to determine which block should have the input focus by using system variables in the code.
• Write the code to perform an action based on the status of the current block by using system variables in the code.
• Write the code to obtain information about the current application by using the
GET_APPLICATION_PROPERTY built-in.
• Write the code to modify the properties of an item in the current application by using the SET_ITEM_PROPERTY built-in.
• Identify the benefits of referencing objects by using their object IDs.
• Reference an object within the initial PL/SQL block by using its internal ID.
• Reference a local object outside the initial PL/SQL block by using its internal ID.
• Identify the characteristics of the built-in subprograms used to indirectly refer to objects
• Match the subprograms of the DBMS_LOB package with their uses.
• Identify the features of using SQL to create, insert, update, select, and remove LOBs.
back to top
61214 - Oracle Form Builder: Managing Module Types Objectives
Unit 1: Project Builder
• Identify the benefits of using Project Builder.
• Match the terms used in Project Builder with their definitions.
• Create a connection in Project Builder by using the pop-up menu.
• Create an empty standalone project using the Project Wizard.
• Add files to an empty project using Project Wizard.
• Identify the operations that are possible using the Project Builder.
• Establish explicit dependency in a project using Project Builder.
• Build dependencies in Projects by using the Project Builder compile options.
• Deliver a project using the Project Builder.
• Identify the items from which an entry can inherit properties.
• Create a new file type in the Project Builder by using the Default Menu.
• Match the Project Builder action types with their features.
• Modify a type by adding actions using the pop-up menu.
• Match the types of macros with their descriptions.
• Create a macro in a project by using the pop-up menu.
• Customize the Launcher by using the Project Builder default menu.
Unit 2: Menu Module Creation
• Match components of the Menu Module with their functions.
• Match the menu styles in Form Builder with their menus they display.
• Match the components of Menu Editor toolbar with their functions.
• Create a Menu Module by using the Menu Editor.
• Match the menu Module properties with their functions.
• Match the menu properties with their functions.
• Match the menu item properties with their functions.
• Manipulate the menu item properties to change the appearance and behavior of a menu item
by using the Property Palette.
• Create a Menu Toolbar by using the Property Palette visible in the horizontal Menu Toolbar visible in the vertical Menu Toolbar.
• Attach the Menu Module to a Form Module by using the Property Palette.
• Create a pop-up menu in a Form Module.
Unit 3: Menu Module Management
• Identify the methods by which a form module and a menu module share code.
• Match the menu item built-ins with their functions.
• Replace the current menu in a form module by using the REPLACE_MENU built-in.
• Match the predefined substitution parameters with their descriptions.
• Create a user-named substitution parameter from the Form Builder Object Navigator.
• Reference a substitution parameter by using the QUERY_PARAMETER built-in.
• Validate a substitution parameter value by using the QUERY_PARAMETER built-in.
• Sequence the steps to implement menu security in a form module.
• Assign a role to a menu module by using the Menu Module Property Palette.
• Assign access to a menu item by using the Menu Editor.
back to top
61215 - Oracle Form Builder: Handling Multiple Object Relationships Objectives
Unit 1: Key Triggers and Mouse Events
• Create a Key trigger in a form module by using PL/SQL Editor.
• Identify the rules for defining Key triggers.
• Match the types of key triggers with their descriptions.
• Identify the functions of key triggers in a form module.
• Type in the PL/SQL code to associate a built-in with the DO_KEY built-in.
• Match the mouse system variables with their functions.
• Specify the mouse movement trigger for a specific function.
• Create a mouse button action trigger for a specified task by using PL/SQL Editor.
• Identify the guidelines to follow while implementing the drag-and-drop functionality.
Unit 2: Window and Canvas: RunTime Management
• Match the window-interaction triggers with their characteristics.
• Match the built-ins used for manipulating windows with their functions.
• Write the code to change the appearance of a window in a form by using built-ins.
• Write the code to display multiple windows at specified positions in a form by using the built-ins.
• Write the code to close a window by using built-ins.
• Match the built-ins for manipulating canvases with their functions.
• Write the code to manipulate tab-style canvases by using built-ins.
Unit 3: Data Block Relationships
• Create an explicit relation between two associated blocks by using the New Relation dialog box.
• Modify the delete behavior between related blocks by using the relation Property Palette.
• Modify the query coordination behavior between related blocks by using the relation Property Palette.
• Identify the block-coordination phases in a relation.
• Identify the features of the default relation-handling triggers.
• Match the default relation-handling procedures with the triggers that call them.
• Write the code to implement the coordination-type toggle between blocks by using built-ins.
• Write the code to implement the coordination-type toggle between blocks by using built-ins.
Unit 4: Working with Multiple Form Applications
• Identify the behavior of a multiple form application.
• Identify the methods by which multiple form modules in an application share information.
• Identify the built-ins used to programmatically invoke another form module.
• Write the code to invoke a form module in a modeless fashion by using a built-in.
• Write the code to perform a query at form startup by using a trigger.
• Match the built-ins used for navigating forms with their descriptions.
• Identify the features of transaction processing for opened form modules.
• Write the code to call a form module in a modal fashion from an open form module by using the built-in.
• Write code to modify the default functionality of transaction processing for called forms.
• Write the code to invoke a new form after exiting the current form by using a built-in.
• Identify the restrictions on using OPEN_FORM with CALL_FORM.
• Match the various methods of invoking forms with the tasks they enable you to perform.
• Create a form parameter by using the Object Navigator.
• Match the built-ins used for manipulating parameter lists with their functionality.
• Write the code to pass data between forms by using the form parameters.
• Write the code to close a form by using the CLOSE_FORM built-in.
• Write the code to close a form by using the EXIT_FORM built-in.
Unit 5: Record Groups and List Items
• Identify the uses of record groups.
• Match the record group types with their functionality.
• Create a query record group at design time by using the Object Navigator.
• Create a static record group at design time by using the Object Navigator.
• Modify a record group at design time by using the Property Palette.
• Match the built-ins used to manage the record group structures with their functionality.
• Identify the built-ins used to manage the data in record groups.
• Match the built-ins used to process record group rows with their functionality.
• Identify the built-in functions that are used to search for record group objects.
• Define a query record group by using built-ins.
• Define a non-query record group by using built-ins.
• Write the code to manipulate record group rows by using built-ins.
• Write the code to manipulate selected record group rows by using built-ins.
• Identify the built-ins used for manipulating list items.
• Write the code to implement dynamic list item by using built-ins.
• Write the code to add values to a combo box list item at runtime by using built-ins.
back to top
61216 - Oracle Form Builder: Including Reusable Oracle Components
Objectives
Unit 1: Additional Data Sources
• Identify the types of data sources used for performing database operations on data blocks.
• Base a data block on a FROM clause query by using the Property Palette.
• Write the code to base a data block on a stored procedure that returns a Ref cursor.
• Write the code to base a data block on a stored procedure that returns a table of records.
• Identify the properties of a data block based on a stored procedure.
• Identify the performance implications specific to database calls using a particular data access mechanism.
• Identify the guidelines to base a data block on a stored procedure.
• Identify the restrictions on performing database operations on data source objects.
Unit 2: Charts, Reports and Timers: Integration in Forms
• Create a chart item in a Form module by using the Chart Wizard.
• Identify the type of a chart on the basis of its appearance.
• Identify the properties of Chart Items.
• Create a report object based on a data block in a Form module by using the Report Wizard.
• Identify the properties of Report Object.
• Identify the built-ins used to programmatically control reports in a Form module.
• Write the code to run a report against a local server by using built-ins.
• Write the code to run a report against a remote server by using built-ins.
• Identify the built-ins for timers.
• Identify the features of the When-Timer-Expired trigger.
• Write the code to manage timers by using built-ins.
• Sequence the steps involved in managing expired timers.
Unit 3: Reusing Components, Objects and Code
• Identify the benefits of reusing objects and code.
• Create a Property class with properties by using the Object Navigator.
• Create a Property Class by using the Property Palette.
• Set the properties of an object by using a named Property class.
• Create a populated Object Group by using the Object Navigator.
• Copy an object in a Form Builder application.
• Identify the features of subclassed objects.
• Reuse an object by using subclassing.
• Create an object library by using the Object Navigator.
• Populate a Form Builder module with objects from an object library.
• Identify the methods to reuse PL/SQL in subprograms.
• Identify the features of PL/SQL libraries.
• Write the code to accept a reference to bind a module variable of local scope in PL/SQL library subprogram by using the IN and INOUT parameters.
• Populate a PL/SQL library module with objects by using different methods.
• Attach a PL/SQL library to form module by using the Attach Library dialog box.
• Write the code to reference a library program unit within an attached library in a form module trigger by using a variable.
• Identify the included reusable components in Form Builder.
• Create a calendar in a form module by using the Calendar object group in the Standard Object Library.
• Write the code to manipulate the calendar at run-time by using the Date_LOV.Get_Date built
-in in the Calendar.pll attached library.
• Create a picklist in a form module by using the Picklist object group in the Standard Object Library.
• Display a populated picklist by using Form Builder built-ins.
Unit 4: New Features in Form Builder
• Identify the features available in Form Builder to handle possible errors.
• Identify the order of preference for the location of PL/SQL code.
• Identify the features of error messages caused by failed Form Builder calls to the Oracle Server.
• Match the predefined error messages with the DML declarative constraint violations that generate them.
• Complete the code for the ON-ERROR trigger to display error information caused by an implicit call to the Oracle Server.
• Complete the code to display error information caused by an explicit call to the Oracle Server.
• Complete the code to dynamically perform database operations by using FORMS_DDL.
back to top
61221 - Oracle Report Builder: Report Fundamentals Objectives
Unit 1: Developer/2000 Report Builder
• Identify the feature of Developer/2000
• Match the components of Developer/2000 with the tasks that they enable.
• Invoke Report Builder by using the Project Builder.
• Identify the common features of Developer/2000 components.
• Identify the features of Oracle Toolkit.
• Identify the features of the Developer/2000 main menu.
• Set preferences to customize a Developer/2000 session by using the Preferences dialog box.
• Identify the description of the main environment variables.
• Match the report design styles with their graphical representations.
• Identify the guidelines for efficiently designing a report.
• Identify the methods of invoking a report.
• Identify the method to cancel report execution.
• Identify the destination options for viewing the report output.
• Label the options available in the Previewer.
• Split the Previewer window to view large pages.
Unit 2: Building a Standard Tabular Report
• Match the report executable files with their functions.
• Identify the Report Builder module types.
• Match the Report Editor views with their uses.
• Match the report level objects with their uses.
• Identify the different categories of objects available in a Report Module.
• Match the Data Model objects with their uses.
• Match the Layout Model objects with their descriptions.
• Identify the functions of the Parameter Form objects.
• Identify the statements that describe the interrelationship among the objects in the Report Editor views.
• Identify the definition of the report wizard.
• Create a query by using the Query Builder in the Report Wizard.
• Select the fields to be displayed from a list of available fields by using the Report Wizard.
• Create a summary by using the Report Wizard.
• Edit a label by using the Report Wizard.
• Select a template from a list of predefined templates by using the Report Wizard.
• View a report created by using the Report Wizard in the Live Previewer.
Unit 3: Building Additional Report Layout Styles
• Enter the wizard by using the specific methods.
• Create a new report by using the Create button.
• Identify the features of a Form Like report.
• Generate a Group Left report from an existing report by using the Report Wizard.
• Generate a Mailing Label report from an existing report by using the Report Wizard.
• Generate a Matrix report from an existing report by using the Report Wizard.
Unit 4: Using the Live Previewer
• Identify the features of the Live Previewer.
• Align the columns in the Live Previewer.
• Set a specified format mask on a numeric field in the Live Previewer.
• Manipulate objects in the Live Previewer.
• Edit boilerplate text in the Live Previewer.
• Modify visual attributes in the Live Previewer.
• Insert page numbers to a report in the Live Previewer.
• Insert the current date and time in a given report in the Live Previewer.
Unit 5: Report Storage Methods
• Identify the situations in which a Report Builder module needs to be saved to a database.
• Match the types of report files with their descriptions.
• Convert an .rdf file to a .rep file by using the conversion utility.
• Match the types of report files with their portability features.
• Sequence the order in which Developer/2000 searches for a file referenced in Report Builder.
• Document a report by using Report Builder.
• Identify the tasks that are performed to migrate report definitions from Developer/2000 Release 1 to Developer/2000 Release 2.
back to top
61222 - Oracle Report Builder: Enhancing Reports Objectives
Unit 1: Enhancing a Report - Data Model 1
• Match the Data Model objects with their characteristics.
• Identify the advantages of modifying the properties of a query statement.
• Change the structure of a group in the Object Navigator.
• Update the layout of a report using the Report Wizard.
• Identify the methods of ordering data in a group.
• Create a group filter by using the Property Palette dialog box.
• Add new data to a report by creating a query in the Data Model.
• Create an external query by using the Object Navigator.
• Create a data link between objects by using the link tool in the Data Model.
• Identify the instances where it will be advantageous to use a single query or a multiple query.
• Match the Data Model column types with their functions.
• Identify the properties of a summary column.
• Create a formula column using the tool palette in the Data Model.
• Identify the uses of the placeholder column.
Unit 2: Enhancing a Report - Layout Model
• Identify the descriptions of the Layout Model regions.
• Design a multipanel report by modifying the logical and physical panel properties of objects
in the Layout Model.
• Sequence the layers of a tabular report in the Layout Model.
• Sequence the steps in report processing.
• Identify the situation in which the confine mode and the flex modes are used to avoid common hierarchy errors.
• Match the components of the tool palette with the tasks that they enable.
• Create a variable length line between columns of a report in the Live Previewer using the tool palette.
• Create a button in a report using the tool palette in the Layout Model.
• Create an explicit anchor using the tool palette in the layout model.
• Sequence the steps to suppress space in a conditional report using explicit anchors.
• Create a chart using the Chart Wizard in the Layout Model.
• Embed a chart in the Layout Model using the tool palette.
Unit 3: Modifying the Layout Object - Properties
• View the properties of multiple layout objects in Object Navigator simultaneously by opening the property palettes.
• Identify the relationship type to be used in a given situation.
• Create a link file object in the layout model using the tool palette.
• Identify the differences between the properties of a link file and a file column.
• Identify the properties that are common among the layout objects.
• Identify what the elasticity values specify.
• Match the pagination properties with their functions.
• Identify what the field properties are used for.
• Identify the functions of the repeating frame properties.
Unit 4: Enhancing Matrix Reports
• Match the Data Model objects with the matrix structure.
• Match the Layout Model objects with the matrix structure.
• Identify the product order values to be set for creating matrix summaries for a given situation.
• Create a cross product group to build a nested matrix using the tool palette.
• Create a nested matrix summary for a report by using the Report Wizard.
back to top
61223 - Oracle Report Builder: Controlling Reports Objectives
Unit 1: Developing Report Templates
• Match regions of a report template with their purpose.
• Customize the template margin.
• Customize the template body.
• Sequence the steps to register a customized template.
• Sequence the steps to add a template image.
Unit 2: Creating and Using Report Parameters
• Create a user parameter by using the Create button.
• Identify the purpose of user parameter properties.
• Distinguish between the ways of referencing a user parameter in a report query.
• Create a static list of values.
• Create a dynamic list of values.
• Identify the purpose of system parameter properties.
• Display a currency symbol by using the CURRENCY system parameter.
• Build a parameter form by using the menu bar.
• Identify the purpose of the parameter form properties.
Unit 3: Coding PL/SQL Triggers in a Report
• Identify the time when specific Report Builder triggers fire in a report execution phase.
• Select the report-level trigger that will be used for a specific purpose.
• Create a report-level trigger by using the Object Navigator window.
• Set a PL/SQL group filter by using the Property Palette for a group.
• Create a validation trigger by using the Property Palette for a parameter.
• Identify the features of a format trigger.
• Create a format trigger for a layout object by using the Property Palette.
• Create a report-level program unit by using the Object Navigator.
• Create a library program unit by using the Object Navigator.
Unit 4: Report Builder Built-In Package
• Match the contents of the SRW package with their functions.
• Display a message by using a SRW packaged procedure.
• Restrict the number of records retrieved for a query by using a SRW packaged procedure.
• Initialize the value in a layout field by using a SRW packaged procedure.
• Set the format attributes for an object by using the SRW packaged procedure.
• Create a drill-down report by using a SRW packaged procedure.
• Execute a SQL statement in a report by using a SRW packaged procedure.
Unit 5: Reports for Different Environmentsr
• Identify the features of different environments.
• Identify the factors to be considered while developing the reports that will be executed in
different graphical user interfaces (GUIs).
• Identify the guidelines to be considered while building bitmapped reports executed in the character mode environment.
• Identify the syntax of the NLS_LANG language environment variable.
• Sequence the steps to translate a resource file by using Translation Builder.
|
Oracle Certified Application Developer
|
n61222D
|
$1750.00
|
|
NETg and Oracle are dedicated to establishing an industry standard of competence for IT
professionals using Oracle technologies. NETg technology-based training (TBT) directly maps to the content of the Oracle Certified Professional program exams (OCP). NETg partners with
Oracle to provide interactive TBT for the Oracle Certified Professional Program. Each course is co-developed by Oracle University's leading curriculum developers and NETg to offer step
-by-step instruction and hands-on practice in key topic areas. These courses compliment Oracle's instructor-led training (ILT) or can also be used as stand-alone courses.
"In NETg, we've found a partner who has vision, technology, and breadth of experience required to help Oracle® effectively meet the demand for quality interactive courseware
both in CD-ROM and Web-based delivery formats. With more than 400 NETg courses available directly from Oracle, customers can access NT, Novell NetWare and Unix.
In addition, by developing a comprehensive library of interactive courseware on Oracle technologies, NETg is a valued partner in helping us meet the customer need for
convenient, cost-effective, self-service training."
back to top
|
