Certification In

Certification in Database Programming with PL/SQL

Database

80,000.00 (LKR)

Department

School Of Computing

Campus

Colombo Campus

Level

Certification Hub

Duration

60 hours

(Including Theory, Hands On Practical, Exam Prep)

Course Overview

  • Certification in Database Programming with PL/SQL
  • This comprehensive course provides foundational knowledge in PL/SQL programming, Oracle database development, and database application creation. Students will learn essential PL/SQL programming skills including procedures, functions, packages, triggers, exception handling, and performance optimization. The course is designed for individuals seeking to develop their database programming capabilities and prepare for Oracle development roles.

Course Structure and Modules

  • Fundamentals
  • Defining Variables and Datatypes
  • Using SQL in PL/SQL
  • Program Structures to Control Execution Flow
  • Using Cursors and Parameters
  • Using Composite Datatypes
  • Exception Handling
  • Using and Managing Procedures
  • Using and Managing Functions
  • Using and Managing Packages
  • Getting the Best Out of Packages
  • Improving PL/SQL Performance
  • Using and Managing Triggers
  • Recognizing and Managing Dependencies
  • Using the PL/SQL Compiler

NIBM internal students only.

  • Schedule:
  • Delivery Format:
  • Practical Labs and Hands-on Experience:
  • Program Fees:
  • Hours:
  • Course Director: Contact for details