(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 03 October 2022 5 Days Istanbul Registration Form Link
IT-D 220 28 November 2022 5 Days Istanbul Registration Form Link
IT-D 220 26 December 2022 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