Oracle PL/SQL Subprograms: Design, Apply & Optimize

This course is part of Oracle PL/SQL 21c: Programming & Triggers Specialization

Instructor: EDUCBA

Access provided by Meerut Institute of Engineering and Technology

2 modules

Gain insight into a topic and learn the fundamentals.

6 hours to complete

Flexible schedule

Learn at your own pace

2 modules

Gain insight into a topic and learn the fundamentals.

6 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Differentiate system vs. object privileges and apply debugging.
Design PL/SQL packages with overloading and persistent states.
Use Oracle utilities & manage LOBs, BFILEs, and automation tasks.

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

8 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Oracle PL/SQL 21c: Programming & Triggers Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 2 modules in this course

By the end of this course, learners will be able to differentiate system and object privileges, apply debugging techniques, design and implement PL/SQL packages, utilize Oracle-supplied utilities, and manipulate large objects (LOBs) effectively.

This comprehensive course empowers database professionals to move beyond basic SQL and harness the full power of PL/SQL subprograms. Through structured modules, learners will analyze core privileges, create modular packages, apply overloading and forward declarations, and manage persistent states in PL/SQL applications. They will also evaluate and implement Oracle-supplied packages such as DBMS_SQL, DBMS_OUTPUT, DBMS_JOB, and UTL_FILE to automate tasks, integrate with web services, and debug applications. Finally, the course dives deep into LOBs and BFILEs, enabling learners to store, read, write, and optimize large data efficiently. Unlike generic PL/SQL courses, this program emphasizes real-world application and optimization with practical examples and Oracle-supplied tools that professionals use daily. Learners will leave with the confidence to design scalable, maintainable, and high-performing PL/SQL solutions for enterprise systems.

This module introduces learners to the fundamentals of PL/SQL subprograms and packages, focusing on privileges, debugging, and advanced package techniques. Learners will explore how to design, manage, and optimize procedures, functions, and packages to build modular and maintainable database applications.

What's included

10 videos4 assignments1 plugin

10 videosTotal 83 minutes

Reqiured Privileges, Invokers Rights and User Objects8 minutes
User Source,User errors and Debugging8 minutes
Managing Subprograms6 minutes
Package, Developing Package, Public Constructs9 minutes
Creating Package, Bodiless Package, removing Package11 minutes
Practical Examples Packages8 minutes
Overloading, Forward Declarations7 minutes
Overloading6 minutes
User Defined Packages , PACK_Cur9 minutes
Controlling the Persistent State of a Package Cursor6 minutes

4 assignmentsTotal 80 minutes

Graded - Mastering PL/SQL Subprogram Foundations30 minutes
Subprogram Essentials30 minutes
Untitled10 minutes
Advanced Package Techniques10 minutes

1 pluginTotal 30 minutes

Designing and Optimizing PL/SQL Subprograms and Packages30 minutes

This module dives into Oracle’s built-in packages, system utilities, and advanced large object (LOB) management. Learners will explore how to leverage Oracle-supplied packages for dynamic SQL, job scheduling, file handling, and network communication, as well as how to store, manipulate, and optimize large objects efficiently.