Basic PL/SQL Programming

Course Code IP1460

Contents

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Screenshot

Description

The Basic PL/SQL Programming WBT is the second course in this curriculum. This course will enable users to create views, sequences, synonyms, records, tables, functions, and procedures. Additionally, it will enable users to create different kinds of PL/SQL blocks.

Audience

This course is designed for Application Developers who want to create database components using Oracle 8.

Prerequisites

Knowledge of database concepts.

Objective

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

Create views Identify the different data dictionary views Create and maintain sequences Create synonyms Identify the different kinds of PL/SQL blocks Describe the Lexical units of a PL/SQL block Declare variables Identify the uses and types of control structure Construct different types of loop statements Create a PL/SQL Record Create a PL/SQL Table Identify the different types of PL/SQL DML statements Construct PL/SQL Functions Construct PL/SQL Procedures Track procedural dependencies Manage procedural dependencies

Topics Include

Creating Database Objects

• Working with Views
• Working with other database objects
• Quiz

Developing a PL/SQL Block

• Working with PL/SQL blocks
• Writing Control Statements
• Working with Composite Datatypes
• Quiz

Working with Functions and Procedures

• Introducing Stored Functions and Procedures
• Implementing Procedures & Dependencies
• Quiz

Duration

4 hrs

Minimum Requirements

Netscape or Internet Explorer (versions 4.0 or higher). Browsers should be capable of accepting cookies; SVGA Hi-color mode 800x600 resolution display. Macromedia Shockwave 6.02 or higher.

Media

Web Based Training