Oracle PL/SQL Oracle8i PL/SQL Oracle 8i PL/SQL - Database Objects and Security Training available online e-learning

This course is aimed at familiarizing the learner with the inbuilt objects and security options in Oracle. The course includes creating and managing sequences indexes and users. It also includes PL/SQL block PL/SQL records and tables PL/SQL variables and datatypes. 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:

Create maintain and use the sequences using the SQL command

Create and maintain indexes using the SQL command

Describe database objects and their uses

Create public and private synonyms

Create users and grant and revoke privileges

Describe the benefits of PL/SQL

Describe the basic PL/SQL block its sections and nested blocks

Create PL/SQL records tables and table of records

Declare variables in PL/SQL and use them

Describe the significance of the executable section in PL/SQL block and writing statements into it

Topics Include

Unit 1: Sequences

Creating a Sequence
Referencing Sequence Values
Altering a Sequence

Unit 2: Indexes

Indexes: Types
Creating an Index
Removing an Index
Other Database Objects

Unit 3: Controlling User Access

Creating a Synonym
Creating a User
System Privileges
Object Privileges

Unit 4: PL/SQL An Introduction

PL/SQL Benefits
Using the PL/SQL Block Structure
Using PL/SQL Records
Using PL/SQL Tables

Unit 5: Datatypes and Variables

Declaring Variables
Declaring Datatypes
Assigning Values to Variables
Executable Statements

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 - Database Objects and Security

Training Provided by Serebra Learning Corporation

Training Avaliability and Delivery