Oracle Database 11g: Program With PL/SQL

Course ID

31070

Course Description

This Oracle 11g course will provide an introduction to the PL/ SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming. This course equips students to develop database server-side PL/ SQL program units within an Oracle database. In addition to receiving the print copy of this course book, all students will receive e-Learning modules.

Prerequisites

An understanding of computer concepts and experience with a graphical user interface (GUI) is essential.

Audience

Target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are:
  • Application designers and developers
  • Database administrators
  • Business users and non-technical senior end users

Course Content

Volume 1
    Choosing a SQL & pl/ SQL interface
  • using SQL developer
  • using SQL*plus
  • using application express
  • using jdeveloper studio

    Language features
  • understanding Pl/ SQL
  • structure of a Pl/ SQL program Block•using Pl/ SQL from SQL*plus

    Declare clause
  • about the declare clause
  • declare simple types
  • declare complex types
  • type ... Table
  • type ... Record

    Begin clause
  • about the begin clause
  • performing data manipulation
  • logic control & branching
  • loop
  • if-then-else
  • case

    Exception clause
  • about the exception clause
  • isolating the specific exception
  • pragma exception_init
  • SQL%rowcount & select...into

    Explicit cursors
  • about explicit cursors
  • advanced cursor techniques

    Advanced programming: declared

    Subprograms

Volume 2
    Introducing database program units
  • about database program units
  • types of Pl/ SQL program units
  • types of stored program units
  • advantages of using stored program Units

    Creating stored procedures & functions
  • about stored procedures & functions
  • creating procedures & functions
  • executing procedures & functions

    Maintaining stored procedures & functions
  • recompiling & dropping programs
  • data dictionary storage
  • managing dependencies

    Creating & maintaining packages
  • about packages
  • creating packages
  • advanced programming techniques
  • maintaining packages

    Advanced cursor techniques
  • using cursor variables
  • using cursor expressions

    Using system-supplied packages
  • dbms_output()
  • utl_file()

    Reating database triggers
  • about database triggers
  • statement-level triggers
  • row-level triggers
  • examples of triggers
  • instead of triggers
  • employing triggers within an Application

    Maintaining database triggers
  • call syntax
  • trigger maintenance tasks
  • show errors trigger
  • drop trigger
  • alter trigger
  • handling multiple triggers for a table
  • handling mutating table issues

    Implementing system event triggers
  • what are system event triggers?
  • defining the scope
  • available system events
  • system event attributes

For More Information

For training inquiries, call 850-308-1376

or email us at eramos@gbsi.com

Course Details

Duration - 5 days
Price - $2995.00 USD


(Discounts may apply. Call for more information.)

Course Actions

Schedule

Acceletrain Collaborative Learning Environment (formerly know as VILT) places industry certified and expert instructors, peers, learners and multi-media components into a "borderless classroom", and interactive learning environment that can span multiple physical locations. VILT combines the benefits of the traditional brick-and-mortar classroom with innovative learning techniques and the cost savings of internet-based training.