Oracle PL/SQL Oracle8i PL/SQL Oracle 8i PL/SQL - Oracle PL/SQL Basic Operations Training available online e-learning

The course is aimed at familiarizing the learner with the basic concepts of PL/SQL. It describes the different datatypes and variables available with PL/SQL. The course provides an overview of PL/SQL records and tables and explains how to access a database from PL/SQL. It also describes the steps to write conditional constructs and controlling structures in PL/SQL along with different types of explicit cursors and their controlling parameters. Finally the course would enable the learner to identify exceptions trap those exceptions and handle the un-handled exceptions. Related Exam: Oracle Exam #1Z0-001: Introduction to Oracle: SQL and PL/SQL.

Training Program Details

Audience

This course is designed for database administrators application developers business analysts designers/developers managers systems analysts and technical support professionals. It will prepare students for the Introduction to Oracle: SQL and PL/SQL Exam.

Prerequisites

The audience of this curriculum should be familiar with RDBMS concepts and Graphical User Interface (GUI).

Objective

Upon completion of this course the student will be able to:

Retrieve data using Pl/SQL

Manipulate data using PL/SQL

Control transaction

Build conditional constructs looping constructs and Boolean conditions

Create and manage cursors

Handle exceptions during run time

Topics Include

Unit 1: Accessing Databases Using PL/SQL

Retrieving Data Using PL/SQL
Manipulating Data Using PL/SQL
Controlling Transactions

Unit 2: Controlling Structures in PL/SQL

Using Conditional Constructs
Using Boolean Conditions
Working with Loop Statements

Unit 3: Working with Cursors

Defining Cursor Types
Processing of Implicit Cursors
Controlling Explicit Cursors
Using Explicit Cursor Attributes
Working with Advanced Explicit Cursors
Using the Cursor FOR Loop
Using the SELECT FOR UPDATE Cursor

Unit 4: Handling Exceptions in a PL/SQL Block

Raising Exceptions
Trapping Exceptions
Handling Unhandled Exceptions

Duration

5 Hours

Minimum Requirements

IBM-compatible PC with 166 MHz or higher processor 32 MB RAM (64 MB RAM recommended); 800x600 SVGA color monitor with 16-bit high color display; Internet Explorer 4 or Netscape Navigator 4 or later with Shockwave 7.0.1; Windows 95 Windows 98 Windows NT; 3.5 diskette (for tracking); 28.8 kbps connection or higher for on-line use.

Media

CDROM
Web Based Training

Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada

Oracle 8i PL/SQL - Oracle PL/SQL Basic Operations

Training Provided by Serebra Learning Corporation

Training Avaliability and Delivery