Basic PL/SQL Programming

Oracle PL/SQL

Serebra Learning Corporation
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.
This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Duration:4 hours
Training Presented in:English
Training Provided by Serebra Learning Corporation
  • V asked: I want to do online pl/ sql class. What is the fees and total duration of course and how do you teach online?
  • E asked: How to study the basic concepts of PL/ SQL and gain sound knowledge can you refer any study material?
  • P asked: why we are using cursor? where to use cursor?
  • S asked: I would like to know the cost for the Oracle SQL PL/SQL background course and this Basic PL/SQL programming course. I may be ordering these two courses for a staff member of mine. Associate Director of ITC Bozeman, MT -
  • K asked: wud like to take it free!
  • A asked: How much does this online training cost and what is the duration of the training?
  • J asked: Need training for about folks. this looks like a good starting point for them
  • R asked: please give me info about plsql programming
  • M asked: Hi I am preparing for OCA oracle certification... So I want this tutorial to start with. Similarly I would like to have other tutorials too ! . Please send me online to my mail id or let me know. Thanks
Basic PL/SQL Programming
Course Outline - IP1460 - Basic PL/SQL Programming

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


click to enlarge

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

Serebra Learning Corporation, 1660 - 999 W Hastings St, Vancouver, BC, Canada   V6C 2W2
Tel: (604) 676-5480 or 1-800-567-7766 - Fax: (604) 676-5490
E-Mail: sales@serebra.com - Web Site: www.serebra.com
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1, 825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
Custom Search
tcw11-v473M-01/23/12-20:02:15-()[B]-[A]-[A] -04:53:31