(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 05 December 2020 5 Days Istanbul $ 3950 Registration Form Link
IT-D 220 30 January 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 220 27 February 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 220 27 March 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 220 24 April 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 220 22 May 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 220 19 June 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 220 14 August 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 220 11 September 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 220 09 October 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 220 06 November 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 220 04 December 2021 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