Training Classes | Learning and Development Resources | Training Directory | New Training Seminars | New Training Providers | Site Map | Promote Training Seminars | Training Keywords | Training Seminars | Training Providers | Regions | Training Search | Advertise Training Seminars | Login
Provided by: Serebra Learning Corporation

Advanced PL/SQL Programming

Click here for more information or to take this course
Serebra Learning Corporation


  home  : Computer  : Databases and SQL  : Oracle PL/SQL

Get More Information
Search for Training
Find Your Genius!
What do you want to learn about?

Training Provided by Serebra Learning Corporation

Advanced PL/SQL Programming

Training Avaliability and Delivery

This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Serebra Learning Corporation for more information
Schedule:6 hours
Training Presented in:English

Related Keywords:  sql   advanced   objects   advanced   sql   programming 

Training Program Details


Course Outline - IP1470 - Advanced PL/SQL Programming

Advanced PL/SQL Programming

Course Code IP1470

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 Advanced PL/SQL Programming WBT is the third course in this curriculum. This course will enable users to create functions, packages, database objects, collections, and triggers. Additionally, it will enable users to create transactions, apply locks, and use dynamic SQL.

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 PL/SQL packages Manage PL/SQL packages Identify various Oracle server-supplied packages Use stored functions in PL/SQL packages Manage database objects Manipulate database objects Manipulate PL/SQL variables using collections Implement varrays Integrate database using PL/SQL triggers Apply database triggers Manipulate data using cursors Declare a cursor variable Integrate transactions with database Restrict database access by applying locks Control user access Define dynamic SQL Use DBMS_SQL to execute non-query DDL and DML statements Use the DBMS_SQL package to execute queries Identify the different types of exceptions Handle user-defined exceptions List PL/SQL debugging techniques Minimize the occurrence of bugs using special programming methodologies

Topics Include

Working with Oracle8 Packages

  • Introducing PL/SQL Packages
  • Applying Advanced Package Concepts
  • Quiz

Working with Objects and Collections

  • Configuring Objects and Methods
  • Grouping Objects using Collections
  • Working with Database Triggers and Cursors
  • Developing Database Triggers
  • Manipulating Data with Cursors
  • Quiz

Maintaining Data Concurrency and Consistency

  • Adding Transactions and Locks
  • Quiz

Using Dynamic SQL

  • Removing Errors and Bugs from PL/SQL Programs
  • Handling Exceptions
  • Debugging PL/SQL
  • Quiz

Duration

6 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, 600 - 1188 West Georgia, Vancouver, BC    V6E 4A2 Canada
Tel: (604) 676-5480 or 1-800-567-7766 - Fax: (604) 676-5490
E-Mail: sales@serebra.com - Web Site: www.serebra.com

About Serebra Learning Corporation - Training Provider

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...

More Training from Serebra Learning Corporation

Click here for more information or to take this course

Training Directory | New Training Seminars | New Training Providers | Search | Site Map | Promote Training | Login | Links


Connecting people who want to learn with people who love to teach
 Are you a Sql training provider?
You could be on this page today - for FREE!