PL/SQL – programming language in Oracle databases

This course is designed to familiarize trainees with the programming language PL/SQL as a programming language in Oracle databases and programming language in an integrated development environment Oracle Developer. There are presented the principle of operation of this language on the database server, creating both basic and complex programming structures. The course covers the building code, automating the operation in the database, the construction of dynamic code as well as issues of protection of created programs.

Full program

Training objectives

Skills

After completing the course, participants will know how to:

create anonymous blocks
create and execute procedures and functions, pass and return values.
generate, capture and handle exceptions.
use cursors
create, share and use records
create and manage packages.
create DML triggers to automate operations manipulating data
create autonomous transactions

Audience profile

The course is intended for all who create applications based on Oracle relational databases using the PL/SQL programming language.

Requirements

Trainees should be familiar with basic SQL functionality as well as bases of programming knowledge.

Training delivery method

The training is carried out in the form of theoretical part in the form of mini lectures and the practical part in the form of computer exercises.

Duration

2 days, 16 training hours

Theoretical and practical knowledge

se of PL / SQL language

• Anonymous blocks

• objects stored on the server side

• objects stored at format application and reports application level

PL / SQL in SQL * Plus and SQL Developer

• Running the code

• bind variables

• capturing the results

Data Types

• scalar

• complex

• Anchored

• LOB

Cooperation with the database

Blocks anonymous PL / SQL

• Running

• Parameters passing

Conditional instructions

Iteration instructions

Procedures

Functions

• different modes of passing parameters

• returning values

Handling Exceptions

• Built-in errors

• User errors

• Codes and names of errors

• Exceptions handle built-in functions

Cursors

• Implicit cursors

• Creating and using explicit cursors

• Cursor attributes

• Cursor parameterization

Dynamic SQL

• Execute immediate

Records

Packages

• specification

• body

• Overloading procedures and functions

• Code wrapping

Database Triggers

• Types of triggers

• DML triggers

• Row level and statement level triggers

• Use of pseudo-records

• Use of Conditional Predicates

• Triggers restrictions

• Triggers management

Autonomous transaction

Development path

Upcoming training dates & Price

Current training dates are available in the form!

PL/SQL – programming language in Oracle databases

PL/SQL – programming language in Oracle databases

Quick Facts

Full program

Similar trainings

📩 Any questions? Get in touch with us!