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. Describing PL/SQL


2. Describing the Use of PL/SQL for the Developer and the Database Administrator


3. Explaining the Benefits of PL/SQL


4. PL/SQL program constructs


5. PL/SQL anonymous block structure


6. Subprogram block structure


7. Course objectives and overview

1. Recognizing the Basic PL/SQL Block and Its Sections


2. Describing the Significance of Variables in PL/SQL


3. Distinguishing Between PL/SQL and Non-PL/SQL Variables


4. Declaring Variables and Constants Executing a PL/SQL Block

1. Recognizing the Significance of the Executable Section


2. Writing Statements Within the Executable Section


3. Describing the Rules of Nested Blocks


4. Executing and Testing a PL/SQL Block

1. Writing a Successful SELECT Statement in PL/SQL


2. Declaring the Data type and Size of a PL/SQL Variable Dynamically


3. Writing Data Manipulation Language (DML) Statements in PL/SQL

1. Identifying the Uses and Types of Control Structures


2. Constructing an IF Statement


3. Constructing and Identifying Different Loop Statements


4. Controlling Block Flow Using Nested Loops and Labels


5. Using Logic Tables

1. Creating User-Defined PL/SQL Records


2. Creating a PL/SQL Table


3. Creating a PL/SQL Table of Records


4. Differentiating Among Records, Tables, and Tables of Records