Euro-training Center
 ORACLE PL SQL B1614 QR Code
Share (38) Like Download Brochure (PDF) Dates and locations

ORACLE PL SQL

Overview:

Introduction:

This training program provides participants with essential knowledge and skills in Oracle PL/SQL programming. It empowers them to develop, execute, and manage PL/SQL programs effectively within Oracle databases.

Program Objectives:

At the end of this program, participants will be able to:

  • Understand the basics of PL/SQL programming language.

  • Write and execute PL/SQL programs.

  • Use PL/SQL for data manipulation and transaction control.

  • Handle exceptions and debug PL/SQL code.

  • Develop stored procedures, functions, and triggers.

Targeted Audience:

  • Database Administrators.

  • Application Developers.

  • IT Professionals involved in database management.

  • Oracle Developers seeking foundational PL/SQL skills.

  • Professionals aiming to enhance their Oracle database skills.

Program Outline:

Unit 1:

Introduction to PL/SQL:

  • Overview of PL/SQL and its advantages.

  • Understanding PL/SQL architecture.

  • PL/SQL block structure.

  • Writing simple PL/SQL programs.

  • Executing PL/SQL programs in SQL*Plus and Oracle SQL Developer.

Unit 2:

PL/SQL Language Fundamentals:

  • Declaring variables and constants.

  • Data types and data conversion.

  • Using operators and expressions.

  • Control structures (IF statements, loops).

  • Working with composite data types (records, collections).

Unit 3:

SQL in PL/SQL:

  • Embedding SQL statements in PL/SQL.

  • Data manipulation (SELECT, INSERT, UPDATE, DELETE).

  • Using cursors for query processing.

  • Explicit and implicit cursors.

  • Cursor attributes and loops.

Unit 4:

PL/SQL Subprograms and Packages:

  • Creating and using procedures.

  • Creating and using functions.

  • Parameter modes (IN, OUT, IN OUT).

  • Introduction to packages.

  • Creating package specifications and bodies.

Unit 5:

Triggers and Advanced PL/SQL:

  • Introduction to triggers and their uses.

  • Creating DML triggers.

  • Working with collections (associative arrays, nested tables, VARRAYs).

  • Bulk operations (BULK COLLECT, FORALL).

  • Principles of secure coding in PL/SQL.

Select training course venue