Skip Ribbon Commands
Skip to main content

ORA11g101v1 - Oracle Database 11g: PL/SQL Fundamentals I

Price:

Duration: 2 Days

Audience:

Level:

Technology:

Delivery Method:

Software Assurance Value:

Microsoft CPE:

Course Information

Course Description

​The primary objective of this course is to 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.

Course Objectives

​Specific subject areas to be explored and objectives to be reached are:


Understand the environment and context in which PL/SQL operates.

Consider the advantages and benefits of PL/SQL within a database environment.

Declaring program variables and complex data types.

Developing logic within PL/SQL program blocks.

Fetching data from the database into program variables.

Returning program output to users.

Handling program exceptions.

Using explicit and implicit database cursors.

Using the advanced features of nested blocks and subprograms.

How to take advantage of advanced features such as regular expression support and the handling of string literals within program code.

Course 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 Outline

​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


Course Prerequisites

​ora11g001, Oracle Database 11G: SQL Fundamentals � Complete Library, is a mandatory prerequisite for this course

Course Schedule
This course is not scheduled yet.

Upcoming Training

SEC+ - Security+ Prep
SEC+ - Security+ Prep