Montreal College of Information Technology
Collège des technologies de l’information de Montréal English flagEN FlagFR


Oracle PL/SQL Developer
State of the Industry

Our Oracle PL/SQL Developer course gives you the tools to create anonymous PL/SQL blocks as well as stored procedures and functions. You will also learn to use the advanced features of program design, packages, cursors, extended interface methods, large objects, and collections.

​Class Schedule: Tuesday and Thursday (5:30PM to 9:30PM)

Who Should Apply

Students and working professionals who wish to gain expertise in advanced PL/SQL programming.

Oracle PL/SQL Developer
Jyothi Puthulatha


Oracle PL/SQL Developer
Sihame B

BI Developer

Oracle PL/SQL Developer
Karla P

Java Developer

Oracle PL/SQL Developer
Chloe D


Under Development


Use conditional compilation to customize the functionality in an PL/SQL application without removing any source code
Create and use stored procedures and functions
Design and use PL/SQL packages to group and contain related constructs
Create overloaded package sub-programs for more flexibility
Use the Oracle supplied PL/SQL packages to generate screen output, file output, and mail output
Write dynamic SQL for more coding flexibility
Describe the features and syntax of PL/SQL
Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
Manage dependencies between PL/SQL sub-programs
Handle runtime errors
Describe stored procedures and functions
Design PL/SQL code for predefined data types, local sub-programs, additional programs and standardized constants and exceptions
Create triggers to solve business challenges
Design PL/SQL anonymous block that execute efficiently

Tune PL/SQL code
Categorize and explain various types of SQL injection attacks
Apply coding standards to eliminate SQL injection vulnerabilities
Create sub-types based on existing types for an application
Create and use collections
Execute external C programs from PL/SQL
Execute Java programs from PL/SQL
Describe the process of fine-grained access control
Create and maintain LOB data types
Use the DBMS_LOB PL/SQL package to control LOBs
Describe SecureFile LOB features
Identify guidelines for cursor design
Enable SecureFile LOB de-duplication, compression, and encryption
Improve memory usage by caching SQL result sets
Set up PL/SQL functions to use PL/SQL result caching
Profile PL/SQL applications


Certificate of participation in ‘Oracle Database 11 G: PL/SQL Developer’ course.

Additionally, students can sit the Oracle Certified Associate (OCA): PL/SQL Developer certification (exam: 1Z1:144), prerequisite:- OCA: Oracle Database 11G: SQL Fundamentals certification (exam: 1Z0-051) is a prerequisite for attaining OCA: Oracle Database 11 G PL/SQL Developer certification.


  • Taught by Industry Experts as instructors
  • Discount on Certification Program
  • Eligible to claim tax credit up to 25% of course fees
  • 24*7 Lab Virtual Desktop access
  • Evening and Weekend schedule
  • Vendor Authorized Training



I am an Engineering grad (Diploma) from Morocco, I discovered MCIT during my master’s at the Technology University Montreal. Studying at MCIT helped me open my Career prospects many folds.

Sihame Benhlima — BI Student
  • Oracle PL/SQL Developer
  • Oracle PL/SQL Developer
  • Oracle PL/SQL Developer
  • Oracle PL/SQL Developer
  • Oracle PL/SQL Developer

Montreal College
of Information Technology

Collège des TI de Montréal   

110-1255 Robert-Bourassa Blvd.
Montreal, Quebec H3B 3V8

+1 514-312-2383
.(JavaScript must be enabled to view this email address)