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

CERTIFICATES

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.

* Morning, evening, weekends

Who Should Apply

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

Oracle PL/SQL Developer
Jyothi Puthulatha

STQA

Oracle PL/SQL Developer
Sihame B

BI Developer

Oracle PL/SQL Developer
Karla P

Java Developer

Oracle PL/SQL Developer
Chloe D

STQA

Under Development

Under Development

WHAT YOU WILL LEARN COURSE OUTLINE

ORACLE PL/SQL DEVELOPER

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

CERTIFICATION EXAMS

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.

TOP REASON
TO JOIN MCIT

  • Industry-relevant, job-ready programs
  • Internship possibilities
  • Eligibility for off-campus work permit program [ocwpp]
  • Eligibility for post-graduation work permit [pgwp]
  • Eligibility for points under Quebec’s immigration policy
  • Scholarships and financial aid

INSTRUCTOR SPOTLIGHT

COMMUNITY TESTIMONIAL

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