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
  • SELECT

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

Packages

  • 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

Triggers

  • 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

Requirements

  • 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)
  28 Hours
 

Need help picking the right course?
Call us +971 4871 6715

Testimonials

Very high competence of the trainer!!.

Heino Eilers

exercises (tasks) to be carried out, examples from the professional experience of the trainer

Tomasz Niewiadomski

Showing how well-known mechanisms are performed on the database side, e.g. they are processed in memory

Marcin Czerwiec

The training was perfectly prepared, I liked the way of running based on real-time examples with a detailed discussion of the impact of individual instructions on the database.

Joanna Dymarczyk

Related Courses

SQL in Microsoft Access

  14 hours
This SQL training course is for people who want to gain the necessary skills to extract and analyse data using Microsoft Access. Course members will learn: how to write SQL queries what relational databases are and how we can use them what
Read More...

Microsoft Access - download the data

  14 hours
The course is designed for persons with pre-information databases using SQL queries or queries.
Read More...

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

  14 hours
The aim of this course is to provide a clear understanding of the advanced use of (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL. For more in depth coverage of the topics this course can be run as a three day
Read More...

SQL in SQL Server

  14 hours
This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn: how to write SQL queries what relational databases are and how we can
Read More...

Transact SQL Basic

  14 hours
Delegates will gain an understanding of the basic principles of Structured Query Language as well as being able to do each of the following: Construct queries to extract and filter data from an SQL Server database Create summarised
Read More...

Transact SQL Advanced

  7 hours
Delegates will gain an understanding of some of the more advanced features of Transact SQL as well as being able to do each of the following: Use queries to return complex result sets Manage database objects to aid query performance Tune
Read More...

SQL Fundamentals

  14 hours
This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn: how to write SQL queries what relational databases are and how we can
Read More...

SQL Advanced in MySQL

  7 hours
This course has been created for people already acquainted with SQL. The course introduces you into secrets common to all SQL databases as well as MySQL specific syntax, functions and
Read More...

SQL in MySQL

  14 hours
How to build a query? What is a relational database? What is the structure and SQL commands?
Read More...

ORACLE PL/SQL Fundamentals

  21 hours
This 3 day course gives an introduction to ORACLE PL/SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/SQL commands. The course takes the format of a workshop,
Read More...

ORACLE SQL Fundamentals

  14 hours
This 2 day course gives an introduction to SQL Developer, SQL*Plus and to SQL, the Structured Query Language used to access a Relational Database and includes the new features of the latest version of ORACLE. The principles learnt may also be
Read More...

Oracle SQL Language

  14 hours
The course answers questions How to build a query? What possibilities have SQL? What is a relational database? What is the structure and SQL commands
Read More...

Oracle SQL for beginners

  21 hours
Listeners This training is addressed for people starting to work with the SQL language in Oracle database The course answer for questions: How to build a query? What possibilities have SQL? What is a relational database? What is
Read More...

Oracle SQL Advanced

  14 hours
Listeners This course is designed for people who want to use the advanced features of SQL in Oracle The course answers the questions How to build advanced queries? How to create advanced
Read More...

Developing Applications with Oracle Application Express (APEX)

  21 hours
Oracle APEX or Oracle Application Express is an application development service in Oracle Database. It provides a fully-integrated, secure, and low-code platform for building and deploying applications. This instructor-led, live training (online
Read More...