Oracle 11g – Programming with PL / SQL I – Workshops Training Course


28 hours (usually 4 days including breaks)


  • Basic skills in any programming language, object-oriented structural or
  • The free use of the basics of SQL and knowledge of Oracle database environment (preferably Oracle 11g completion of training – Native SQL for Programmers – Workshops)


For who

Workshops are dedicated to developers, end users and administrators, who until now have had no contact with the language PL / SQL, and the need to exploit its huge potential in working with a database, automate processes, and in building applications

Exams and Certificates

The plan covers the training material required to pass the exam 1Z0-144 Oracle Database 11g Program with PL / SQL and obtain the title of Oracle PL / SQL Developer Certified Associate

Purpose of training

The workshop aims to familiarize participants with the programming language PL / SQL, its capabilities and limitations. This workshop will include a full understanding of the mechanisms involved in the programming language PL / SQL needed to implement the logic of the free applications, automation of data processing and database management.

The content of the training

  • Introduction to PL / SQL architecture solutions based on this language, the organization of the working environment
  • Create scripts and stored program units that operate on data


The workshops are based on the software version 11g XE

Course Outline

Introduction to PL / SQL

  • Runtime Environment
  • Construction and types of PL / SQL blocks
  • Declaring and using variables
  • Control statements, decisions, loops

SQL statements in PL / SQL

  • DML commands
  • DDL and dynamic SQL
  • TCL commands and transactional

Procedures and Functions

  • Create and delete
  • Parameterization
  • Passing parameters by value and reference, nocopy

Handling errors and exceptions

Create and use cursors

  • Records
  • static cursors
  • Parameterizing cursors
  • Cursor FOR UPDATE

Associative arrays


  • The structure of the package: the specification and body
  • Section Initialization and global variables, memory management, an instance of the package
  • Encapsulation, overloading programs, pre-declaration procedures


  • DML triggers
  • The triggers Drives (INSTEAD OF)
  • The triggers system
  • New features in Oracle 11g triggers

Examples of application packages built

  • Writing to a file through UTL_FILE
  • Sending e-mails

Management code and compiler

  • Encryption code (dynamic obfuscation, wrap)
  • conditional Compilation
  • The relationships between objects
  • Warnings

Leave a Reply

Your email address will not be published. Required fields are marked *