(Click Category to List Courses)

38 - IT-D Information Technology - Databases and Related Technologies

IT-D 220 - Oracle - Programming with PL/SQL

Code Start Date Duration Venue
IT-D 220 23 October 2023 5 Days Istanbul Registration Form Link
IT-D 220 18 December 2023 5 Days Istanbul Registration Form Link
Please contact us for fees


Course Description

This course provides comprehensive coverage of PL/SQL, Oracle's main programming language. PL/SQL is used to write stored procedures, triggers and other code stored in the powerful Oracle database. In addition, Oracle also uses this language in their frontend development environment, Developer, as well as their Web-based engine, Oracle Application Server.

Course Objectives

  • Creating stored procedures and functions for maximum reuse and minimum code maintenance
  • Developing efficient PL/SQL programs to access Oracle databases
  • Designing modular applications using packages
  • Managing data retrieval for front-end applications
  • Invoking native dynamic SQL to develop high-level abstract code

Who Should Attend?

  • Programmers
  • working with PL/SQL 
  • Application Developers
  • Data Warehouse Administrator
  • Developer
  • Forms Developer
  • PL/SQL Developer

Course Details/Schedule

Day 1

  • Introduction
  • Introduction to PL/SQL
  • Declare PL/SQL Identifiers
  • Write Executable Statements


Day 2

  • Interaction with the Oracle Server 
  • Control Structures
  • Composite Data Types 
  • Explicit Cursors

Day 3

  • Exception Handling 
  • Stored Procedures
  • Stored Functions and Debugging Subprograms
  • Packages

Day 4

  • Deploying Packages
  • Implement Oracle-Supplied Packages in Application Development
  • Dynamic SQL
  • Design Considerations for PL/SQL Code

Day 5

  • Developing Well-Structured and Error-Free Code
  • Debugging PL/SQL blocks
  • Achieving Maximum Reusability