(Click Category to List Courses)

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


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

Code Start Date Duration Venue Fees
IT-D 220 21 February 2022 5 Days Istanbul $ 3950 Registration Form Link
IT-D 220 18 April 2022 5 Days Istanbul $ 3950 Registration Form Link
IT-D 220 13 June 2022 5 Days Istanbul $ 3950 Registration Form Link
IT-D 220 08 August 2022 5 Days Istanbul $ 3950 Registration Form Link
IT-D 220 03 October 2022 5 Days Istanbul $ 3950 Registration Form Link
IT-D 220 28 November 2022 5 Days Istanbul $ 3950 Registration Form Link
IT-D 220 26 December 2022 5 Days Istanbul $ 3950 Registration Form Link
DOWNLOAD PDF

 

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