Is this course really 100% online? Do I need to attend any classes in person?

This course is completely online, so there’s no need to show up to a classroom in person. You can access your lectures, readings and assignments anytime and anywhere via the web or your mobile device.

Can I just enroll in a single course?

Yes! To get started, click the course card that interests you and enroll. You can enroll and complete the course to earn a shareable certificate. When you subscribe to a course that is part of a Specialization, you’re automatically subscribed to the full Specialization. Visit your learner dashboard to track your progress.

Is financial aid available?

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.

Can I take the course for free?

No, you cannot take this course for free. 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. If you cannot afford the fee, you can apply for financial aid.

Will I earn university credit for completing the Specialization?

This Specialization doesn't carry university credit, but some universities may choose to accept Specialization Certificates for credit. Check with your institution to learn more.

Oracle PL/SQL 21c: Programming & Triggers 专项课程

Master Oracle PL/SQL 21c Programming Skills. Build, optimize, and manage PL/SQL programs, subprograms, and triggers for enterprise databases

位教师：EDUCBA

包含在 Coursera Plus 中

了解更多

6 门课程系列

深入学习学科知识

初级等级

推荐体验

4 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

6 门课程系列

深入学习学科知识

初级等级

推荐体验

4 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

您将学到什么

Design, implement, and optimize Oracle PL/SQL programs for enterprise systems.
Apply subprograms, packages, and Oracle utilities to build scalable, modular solutions.
Manage triggers and error-handling strategies to enforce business rules and ensure reliability.

要了解的详细信息

可分享的证书

添加到您的领英档案

授课语言：英语（English）

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

精进特定领域的专业知识

向大学和行业专家学习热门技能
借助实践项目精通一门科目或一个工具
培养对关键概念的深入理解
通过 EDUCBA 获得职业证书

专业化 - 6门课程系列

This Specialization provides a complete pathway to mastering Oracle PL/SQL 21c, from foundational programming to advanced subprograms and triggers. Learners will develop the ability to design efficient PL/SQL blocks, optimize stored procedures, manage cursors, apply robust exception handling, and implement triggers for enforcing business rules. With a project-based, hands-on approach, participants gain real-world experience in designing and optimizing enterprise-level PL/SQL solutions. By completing this program, learners will be prepared for roles in database development, PL/SQL programming, and Oracle-based application optimization.

应用的学习项目

Learners will engage in real-world, project-based applications including schema design, procedure and function development, trigger-based automation, and performance tuning. Each project is designed to mirror workplace challenges, ensuring learners can apply their PL/SQL expertise to optimize enterprise databases, enforce business rules, and deliver scalable solutions.

Oracle PLSQL 21c: Apply, Analyze & Build Programs

第 1 门课程3小时

您将学到什么

Design 2D/3D games with rendering, textures, and transformations.
Implement collision logic, scoring, lives, and level mechanics.
Build and deploy a complete Brick Breaker game in MonoGame.

您将获得的技能

类别：PL/SQL

类别：Stored Procedure

类别：SQL

类别：Business Logic

类别：Data Integrity

类别：Computational Logic

类别：Programming Principles

类别：Oracle Databases

类别：Data Validation

Master PL/SQL: Apply, Integrate & Optimize Database Logic

第 2 门课程12小时

您将学到什么

Design schemas and implement stored procedures, functions, and triggers.
Manage cursors, loops, exceptions, and dynamic SQL effectively.
Optimize PL/SQL performance and integrate into real projects.

您将获得的技能

类别：PL/SQL

类别：Business Logic

类别：Database Design

类别：Stored Procedure

类别：Data Integrity

类别：Scalability

类别：SQL

类别：Workflow Management

类别：Relational Databases

类别：Debugging

类别：Database Development

类别：Procedure Development

类别：Oracle Databases

Oracle PL/SQL Programming: Apply, Build & Optimize

第 3 门课程5小时

您将学到什么

Write PL/SQL blocks with variables, control structures, and SQL.
Use loops, cursors, records, and composite data types effectively.
Apply best practices in structuring, modularizing, and handling errors.

您将获得的技能

类别：Programming Principles

类别：Oracle Databases

类别：PL/SQL

类别：Data Access

类别：Database Design

类别：Relational Databases

类别：SQL

类别：Stored Procedure

类别：Debugging

类别：Maintainability

Oracle PL/SQL: Design & Optimize Subprograms

第 4 门课程5小时

您将学到什么

Design and manage explicit cursors with multi-row retrieval.
Build robust PL/SQL procedures, functions, and parameter handling.
Apply exception handling and optimize database applications.

您将获得的技能

类别：Database Application

类别：Database Development

类别：SQL

类别：Stored Procedure

类别：Oracle Databases

类别：Maintainability

类别：PL/SQL

类别：Performance Tuning

类别：Debugging

Oracle PL/SQL Subprograms: Design, Apply & Optimize

第 5 门课程6小时

您将学到什么

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.

您将获得的技能

类别：Database Development

类别：PL/SQL

类别：SQL

类别：Authorization (Computing)

类别：Debugging

类别：Data Storage Technologies

类别：Database Management

类别：Stored Procedure

类别：Oracle Databases

类别：Web Services

Oracle PL/SQL Triggers: Design, Implement & Manage

第 6 门课程5小时

您将学到什么

Create, delete, and implement advanced logic in PL/SQL triggers.
Enforce business rules, replicate data, and audit system events.
Manage trigger dependencies and apply recompilation strategies.

您将获得的技能

类别：Database Management

类别：Maintainability

类别：SQL

类别：Event-Driven Programming

类别：PL/SQL

类别：Database Development

类别：Debugging

类别：Auditing

类别：Oracle Databases

类别：Data Integrity

类别：Relational Databases

类别：Business Logic

类别：Stored Procedure

获得职业证书

将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。

位教师

EDUCBA

427 门课程124,639 名学生

提供方

EDUCBA

人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

自 2018开始学习的学生

''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情，我就可以学习。'

Jennifer J.

自 2020开始学习的学生

''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'

Larry W.

自 2021开始学习的学生

''如果我的大学不提供我需要的主题课程，Coursera 便是最好的去处之一。'

Chaitanya A.

''学习不仅仅是在工作中做的更好：它远不止于此。Coursera 让我无限制地学习。'

通过 Coursera Plus 开启新生涯

无限制访问 10,000+ 世界一流的课程、实践项目和就业就绪证书课程 - 所有这些都包含在您的订阅中

了解更多

通过在线学位推动您的职业生涯

获取世界一流大学的学位 - 100% 在线

探索学位

加入超过 3400 家选择 Coursera for Business 的全球公司

提升员工的技能，使其在数字经济中脱颖而出

了解更多

常见问题

The Oracle PL/SQL 21c Specialization can typically be completed in 14 to 15 weeks with a recommended study commitment of 3–4 hours per week. This pacing ensures learners have sufficient time to build a strong foundation in PL/SQL concepts, gradually advance to subprograms, triggers, and optimization techniques, and apply their skills in hands-on projects. By following this structured timeline, learners can balance their studies alongside work or academic commitments while gaining industry-relevant expertise in Oracle PL/SQL.

A basic understanding of SQL and relational database concepts is recommended. Prior experience with Oracle SQL is helpful but not mandatory, as the courses are structured to support beginners while still offering advanced insights for intermediate learners.

Yes, it is strongly advised to take the courses in the suggested sequence. The Specialization follows a progressive structure, starting with fundamental PL/SQL programming concepts before moving into subprograms, advanced packages, triggers, and optimization. This ensures a smooth learning curve and consistent skill development.

By the end of the Specialization, you will be able to design, implement, and optimize PL/SQL programs for enterprise applications. You will gain hands-on expertise in building subprograms, managing triggers, handling exceptions, and applying Oracle-supplied utilities to solve real-world business problems. This mastery will prepare you for roles such as PL/SQL Developer, Database Programmer, or Oracle Application Specialist.