ORACLE DATABASE 11G R2: PL/SQL FUNDAMENTALS I – GTD3

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.

^^

Duration

2 days

^^

Target 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 Prerequisites

Those who wish to attend this course require attendance of the courses below, similar courses, or have the equivalent experience.

If you have any questions or doubts as to whether you meet the pre-requisites for this course, or indeed are wondering which course best suits you, please consult with us to discuss your suitability for course attendance.

^^

Suggested Follow on Courses

^^

Course Content

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

© 2011 Sideris Courseware Corporation

^^

See more Database Technologies courses