Course Objectives

This course covers PL/SQL scripting used in the Oracle RDBMS.

Contents

1. PL/SQL Introduction

1.1 General PL/SQL Concepts

1.2 Programming Units Introduction

2. Language Basics

2.1 Variable Types

2.2 Blocks

2.3 Scope

3. Control Structures

3.1 Conditions

3.2 Iterations

4. Cursors

4.1 Implicit-Explicit

4.2 Parameters

4.3 Access Methods

5. Programming Units

5.1 Functions and Procedures

5.2 Creation Options

5.3 Call by Value – Reference

5.4 Transaction Scope

5.5 Dynamic SQL

6. Packages

6.1 Specification – Body

6.2 Dependencies

6.3 Definer vs Invoker

6.4 Exceptions

7. Triggers

7.1 Trigger Types

7.2 Trigger Actions

8. Package Libraries

8.1 Libraries Overview

 

Entry Requirements

IT concepts understanding with hands-on background is required from the participants.

Target Group

Technical personnel involved in programming using PL/SQL.

 Mode of Delivery:  Distance-instructor-led learning in a virtual classroom

 Duration:  The duration of this course is 3 full training days

Language: Greek

Participants: The maximum number of participants for this course is 10 persons

Time schedule

The time required always depends on the knowledge of the attending participants and the schedule stated below can be used as estimate.

Course Structure		Hours	Days
PL/SQL Introduction	General PL/SQL Concepts	2	Day 1
	Programming Units Introduction
Language Basics	Variable Types	1
	Blocks	1
	Scope
Control Structures	Conditions	1
	Iterations	1
Cursors	Implicit-Explicit	2	Day 2
	Parameters
	Access Methods	1
Programming Units	Functions and Procedures	2
	Creation Options
	Call by Value – Reference
	Transaction Scope	1
	Dynamic SQL
Packages	Specification – Body	2	Day 3
	Dependencies
	Definer vs Invoker
	Exceptions	1
Triggers	Trigger Types	2
	Trigger Actions
Package Libraries	Libraries Overview	1