Oracle PL/SQL Subprograms: Design, Apply & Optimize

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

Instructor: EDUCBA

Included with Coursera Plus

Learn more

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

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

Subprogram Essentials30 minutes
Untitled10 minutes
Advanced Package Techniques10 minutes
Graded - Mastering PL/SQL Subprogram Foundations30 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.

What's included

16 videos4 assignments

16 videosTotal 130 minutes

More Package Concepts7 minutes
More Package Concepts 27 minutes
DBMS_SQL,DBMS_DDL and DBMS_JOB6 minutes
Using DBMS_SQL8 minutes
Submitting Jobs, UTL_FILES and Exceptions in UTL_FILES7 minutes
Using the DBMS_OUTPUTPackage7 minutes
UTL_HTTP and UTL_TCP11 minutes
Oracle Supplied Packages 16 minutes
Oracle Supplied Packages 26 minutes
LOBs and BFILEs8 minutes
Internal LOBs6 minutes
DIRECTORIES, BFILENAME functions8 minutes
Loading BFILEs & Migrating from LONG to LOB7 minutes
DBMS_LOB READ and DBMS_LOB WRITE11 minutes
Removing LOBs and Temporary LOBs10 minutes
Manipulating Large Objects7 minutes

4 assignmentsTotal 60 minutes

Oracle-Supplied Power Tools10 minutes
Utilities & System Packages10 minutes
Working with LOBs10 minutes
Graded - Exploring Oracle Supplied Packages & LOBs30 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

EDUCBA

522 Courses134,730 learners

Offered by

EDUCBA

Explore more from Data Analysis

Status: Free Trial
Packt
Comprehensive Tuning and Optimization for Oracle Databases
Course
Packt
The Oracle Database Multitenant Administration Course
Course
Status: Free Trial
Packt
Fundamentals of Oracle Database Performance Tuning
Course
Status: Free Trial
Packt
Intermediate Oracle Database Administration
Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.