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

Oracle PLSQL 21c: Apply, Analyze & Build Programs

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, 2 hours a week
Sessions

Self-Paced
Level

Beginner
Subtitles

English, Hungarian

Found in

PL/SQL Courses

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

Build a practical foundation in Oracle PL/SQL 21c and learn to create structured programs that handle data accurately and make logical decisions. This course guides you through declaring and applying variables, distinguishing constants from variable constraints, and using %TYPE and %ROWTYPE to maintain datatype consistency. You will also work with procedures for modular programming, manipulate and compare strings with LIKE, CHAR, and VARCHAR2, and control program flow using IF-THEN-ELSE and CASE expressions. Designed for beginners and intermediate SQL users, the course helps you translate business requirements into clear PL/SQL blocks and reusable procedures. Through hands-on examples, practice quizzes, and graded assessments, you will strengthen problem-solving skills, improve coding accuracy, and apply reliable data-handling techniques to workplace programming scenarios. The course’s step-by-step structure makes it distinctive: you progress from variables, constants, and constraints to datatype management and conditional logic. By the end, you will be able to design, implement, analyze, and evaluate Oracle PL/SQL solutions with greater clarity and precision.

Syllabus

Foundations of PLSQL Programming
- This module introduces the essentials of Oracle PLSQL programming, including variable and constant declarations, constraints, and procedures. Learners will build a solid foundation in structuring PLSQL blocks, handling data consistently, and preparing for advanced coding practices.
Mastering Conditions and Datatypes
- This module focuses on working with character datatypes and applying conditional logic in Oracle PLSQL. Learners will gain the ability to manipulate strings effectively and design decision-making structures using IF-ELSE and CASE expressions to control program flow.