Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Oracle PL/SQL: Design & Optimize Subprograms

EDUCBA via Coursera

Go to class Write review

Details

Go to class

Provider

Coursera
Pricing

Paid Course
Languages

English
Certificate

Certificate Available
Effort

2 weeks, 3 hours a week
Sessions

Self-Paced
Level

Intermediate
Subtitles

English, Hungarian

Found in

Part of

Oracle PL/SQL 21c: Programming & Triggers

Overview

Google, IBM & Meta Certificates – 40% Off

One Coursera Plus subscription covers most Professional Certificates on Coursera.

Unlock All Certificates

Master Oracle PL/SQL subprogram development through a structured, hands-on study of cursors, exception handling, procedures, functions, and parameters. Designed for learners who want practical Oracle database programming skills, this course shows you how to declare, open, fetch, and manage explicit cursors for efficient multi-row data processing. You will learn to identify, trap, and resolve predefined and user-defined errors, helping you build more reliable PL/SQL programs. You will also differentiate between procedures and functions, use IN, OUT, and IN OUT parameters, and create, invoke, and drop stored procedures. As you progress, you will construct stored functions, integrate them into SQL expressions, and evaluate when functions offer advantages over procedures. The course stands out for its step-by-step progression from foundational concepts to advanced implementation. Practical demonstrations, real-world examples, and targeted quizzes connect conceptual clarity with Oracle-focused use cases. By the end, you will be prepared to design reusable PL/SQL subprograms and improve the reliability, maintainability, and scalability of Oracle database applications.

Syllabus

Mastering Cursors & Exception Handling
- This module introduces learners to the fundamentals of working with cursors in Oracle PL/SQL and equips them with practical techniques to handle exceptions effectively. Through detailed lessons, students will explore how to declare, open, fetch, and manage explicit cursors for multi-row queries, leverage cursor records for efficient data handling, and implement robust exception handling strategies to ensure error-free PL/SQL programs.
Procedures & Functions in Depth
- This module explores the core concepts of PL/SQL subprograms, focusing on how to design, create, and manage procedures and functions effectively. Learners will gain practical skills in parameter handling, procedure creation, error management, and function development to enhance reusability and maintainability of Oracle PL/SQL applications. Through hands-on examples, the module demonstrates best practices in passing parameters, handling IN, OUT, and IN OUT modes, and implementing stored functions for business logic that integrates seamlessly with SQL queries.