Course duration(in hrs): 28

1. Use iSQL*Plus to format reports


2. Use basic iSQL*Plus commands


3. Retrieve, insert, update, and delete data


4. Describe relational and object relational database concepts


5. Create and maintain database objects


6. Control transactions


7. Control data and user access

1. Using a PL/SQL Record Variable


2. Distinguishing Between the Implicit and Explicit Cursor


3. Writing a Cursor that Uses Parameters


4. Determining When a FOR UPDATE Clause in a Cursor Is Required


5. Using a PL/SQL Table Variable


6. Using a PL/SQL Table of Records

1. Defining PL/SQL Exceptions


2. Recognizing Unhandled Exceptions


3. Listing and Using Different Types of PL/SQL Exception Handlers


4. Describing the Effect of Exception Propagation in Nested Blocks


5. Customizing PL/SQL Exception Messages

1. Describe the uses of procedures


2. Create procedures


3. Create procedures with arguments


4. Invoke a procedure


5. Remove a procedure

1. Describe the uses of functions


2. Create a function


3. Invoke a function


4. Remove a function


5. Differentiate between a procedure and a function

1. Describe system privilege requirements


2. Describe object privilege requirements


3. Query the relevant data dictionary views


4. Debug subprograms

1. Describe packages and list their possible components


2. Create packages that include public and private subprograms, as well as global and local variables


3. Invoke objects in a package


4. Remove packages


5. Write packages that use the overloading feature of PL/SQL

1. Overview of Oracle-supplied packages


2. View examples of some supplied packages


3. Write dynamic SQL

1. Describe different types of triggers


2. Describe database triggers and their use


3. Create database triggers


4. Describe database trigger firing rules


5. Drop database triggers

1. Create triggers that fire when certain database actions occur


2. List some of the limitations of database triggers


3. Determine when to use database triggers or Oracle Server features


4. Create triggers by using alternative events (not INSERT/UPDATE/DELETE)


5. Create triggers by using alternative levels (not STATEMENT/ROW)


6. Query the relevant data dictionary views