Information

Follow Us

Super Oracle Developer

PL/SQL

30 Training HoursProcedural Language for SQLTrack 02 of 6

Explore the curriculum All course tracks
Space Code AcademyScroll down

Course overview

PL/SQLProcedural Language for SQL

We provide practical Procedural Language for SQL (PL/SQL) training that helps learners build efficient database programs, manage logic, and develop reliable applications for real business needs.

30Training hours
9Course modules
46Listed topics
1Capstone project
Track 02

PL/SQL

30 Hours
01Introduction4 topics
  • What is PL/SQL?
  • Advantages of using PL/SQL
  • PL/SQL block structure
  • PL/SQL execution environment
02PL/SQL language fundamentals5 topics
  • Data types
  • Variables and constants
  • Scope and visibility
  • Assignments and expressions
  • Operators (arithmetic, relational, logical)
03Control Structures3 topics
  • Conditional statements (IF, IF-THEN-ELSE, CASE)
  • Iterative statements (LOOP, WHILE, FOR)
  • Sequential control (GOTO, NULL)
04Cursors6 topics
  • Implicit and explicit cursors
  • Cursor attributes
  • Cursor FOR loops
  • Cursor variables
  • Parameterized cursors
  • Cursor expressions
05Exceptions6 topics
  • Predefined exceptions
  • User-defined exceptions
  • Raising exceptions
  • Exception handling (EXCEPTION block)
  • Propagating exceptions
  • Exception scope and visibility
06Triggers6 topics
  • Creating and enabling triggers
  • Trigger types (DML, DDL, system, instead-of)
  • Trigger timing (before, after)
  • Trigger scope (statement, row)
  • Trigger predicates (WHEN clause)
  • Mutating tables and triggers
07Stored procedures and functions6 topics
  • Creating and invoking procedures
  • Procedure parameters (IN, OUT, IN OUT)
  • Creating and invoking functions
  • Function return values
  • Overloading procedures and functions
  • Recursion
08Packages5 topics
  • Creating and using packages
  • Package specification and body
  • Private and public package components
  • Package initialization and termination
  • Overloading package subprograms
09Dynamic SQL5 topics
  • Native dynamic SQL (EXECUTE IMMEDIATE)
  • DBMS_SQL package
  • Dynamic SQL for DDL and DML statements
  • Binding variables in dynamic SQL
  • Bulk operations with dynamic SQL
Beyond the modules

Practice & Advanced Assignments

01

Practice

Practical exercises reinforce concepts.

02

Advanced Assignments

Challenge your understanding with more complex tasks.

03

Hands-On Experience

Gain real-world skills through practical application.

04

Comprehensive Learning

Deepen your knowledge through varied learning methods.

Capstone

Apply Your Skills: Capstone Project

  • This capstone project will solidify everything learned throughout the course.
  • The instructor will guide students through selecting and completing a project of their choice.
  • The project should demonstrate a thorough understanding of SQL, PL/SQL, Forms, and Reports.

Continue the journey

More Super Oracle Developer tracks

01
30 Hours

SQL

Structured query language

We provide practical Structured Query Language (SQL) training that helps learners understand databases, write efficient queries, and manage data confidently for real business applications.

ExploreNext
03
20 Hours

Oracle Forms

Oracle Forms Services

We provide practical Oracle Forms Services training that helps learners build data-driven forms, manage business workflows, and develop reliable applications for real organizational needs.

Explore
04
10 Hours

Oracle Reports

Oracle Reports

We provide practical Oracle Reports training that helps learners design professional reports, extract accurate data, and deliver clear insights for real business requirements.

Explore
05
40 + 40 Hours

Oracle APEX

Oracle Application Express

We provide practical Oracle Application Express (APEX) training that helps learners build modern web applications, manage data efficiently, and deliver scalable solutions for real business needs.

Explore
06
20 Hours

HTML – CSS – JavaScript

Enhancing Oracle APEX with HTML, CSS, and JavaScript

We provide practical training on enhancing Oracle APEX applications using HTML, CSS, and JavaScript to improve user experience, design flexibility, and application performance.

Explore
Ready to grow your brand into a legacy?

Lets Make Something

Great together

Call Us
Other courses
Send A Message

Helping
start-ups scale & grow.

Quick links

Contact

info@spacecodeacademy.com +20 111 3335898 +20 112 606 4035 1st Floor, Tower 8 (Mid-Level), Osman Diplomats Towers, Maadi (Next to Galaxy Cinema Maadi)

© 2025 SPACE CODE