0
Item added to cart

Search For Courses

Shopping Cart

Your cart is empty.

Your Account

Login or Create an Account

Contact By Phone

877-442-3915



Contact By Email

Your Account

Login or Create an Account

Contact By Phone

877-442-3915



Contact By Email

Oracle Database: PL/SQL Fundamentals

$2995 | 5-Day Course

Master Oracle PL/SQL from the basics to advanced triggers and packages.

Course Overview

The Oracle Database: PL/SQL Fundamentals course introduces you to procedural database programming in Oracle, from core syntax through advanced application design.

The class will cover the following topics:
  • PL/SQL block structure: DECLARE, BEGIN, EXCEPTION sections
  • Language fundamentals: syntax rules, embedding SQL, readable code
  • Data types and composite types: %TYPE, RECORD, TABLE
  • Error handling and exception propagation with PRAGMA and SQLCODE
  • Cursors and cursor programs: explicit cursors, FOR…LOOP, WHERE CURRENT OF
  • Stored program units: procedures, functions, packages
  • Database triggers: statement‐level, row‐level, system events
  • Advanced features: BULK COLLECT, conditional compilation, PLSCOPE_SETTINGS

This class is ideal for Oracle professionals aiming to write high‑performance, maintainable PL/SQL applications on Oracle 11c–19c.

Oracle Training

TARGETED FOR: End Users | Business Analysts | Database Administrator

Learn from Professional Instructors and move forward in your field with industry-aligned Oracle training.

+ Full Course Details
Overview
  • This course introduces Oracle PL/SQL programming language syntax, structure, and features.
  • It lays the foundation for the Sideris Oracle PL/SQL series, from introductory blocks to high-performance applications.
  • The focus is on database-resident program units: procedures, functions, packages, and triggers.
  • New features from Oracle 12c, 18c, and 19c are explained and demonstrated.
Objective
  • Explain PL/SQLs role in database application architecture and design.
  • Build executable PL/SQL blocks with DECLARE, BEGIN, and EXCEPTION sections.
  • Implement robust error handling using PRAGMA EXCEPTION_INIT and SQLERRM.
  • Create and maintain stored procedures, functions, and modular packages.
  • Develop database triggers for DML and system events.
  • Use advanced PL/SQL features‚BULK COLLECT, conditional compilation, PLSCOPE_SETTINGS.
Target Student
  • Application designers and database developers using Oracle
  • Database administrators enhancing application logic
  • Web server administrators integrating Oracle back-ends
Prerequisites
  • Successful completion of Oracle Database 12c: SQL Fundamentals
+ Course Delivery Format
Virtual Instructor-Led

All of our Public Classes are taught by a virtual live instructor. How it works is a live instructor conducts the class from a remote location regardless if you attend at one of the local training centers or if you attend remotely.

For of Private Group Training classes we can arrange to have the instructor conduct the class live at your location. Need Group Training?

+ What's Included

  • Professional Instructor Delivery - You will learn with our expert trainers with over 15 years of experience.
  • Free Course Materials - You will receive free reference materials for your class.
  • Small Class Sizes - Our classes are limited to 12 students, so you have plently of opportunity to ask questions and get feedback from the instructor.
  • Free Repeat - If you need a refresher your are able to retake the class free of charge within one year of your original class date.
  • Hands-On Training - Our classes are designed for you work hands on during the session so can stay engaged and really learn the material.
  • Certificate of Completion - Each student will receive a certificate of completion after completing the course.

+ Course Outline
  • SELECTION & SETUP OF THE DATABASE INTERFACE
    • CONSIDERING AVAILABLE TOOLS
    • SELECTING THE APPROPRIATE TOOL
    • ORACLE NET DATABASE CONNECTIONS
    • ORACLE PAAS DATABASE CONNECTIONS
    • SETUP SQL DEVELOPER
    • SETUP SQL*PLUS
    • SETUP JDEVELOPER
  • ABOUT BIND & SUBSTITUTION VARIABLES
    • USING SQL DEVELOPER
    • USING SQL*PLUS
  • CHOOSING A DATABASE PROGRAMMING LANGUAGE
    • WHAT IS DATABASE PROGRAMMING?
    • PL/SQL PERFORMANCE ADVANTAGES
    • INTEGRATION WITH OTHER LANGUAGES
  • PL/SQL LANGUAGE FUNDAMENTALS
    • PL/SQL PROGRAM STRUCTURE
    • LANGUAGE SYNTAX RULES
    • EMBEDDING SQL
    • WRITING READABLE CODE
    • GENERATING DATABASE OUTPUT
    • SQL*PLUS INPUT OF A PROGRAM BLOCK
  • DECLARE SECTION
    • ABOUT THE DECLARE SECTION
    • DECLARE PRIMITIVE TYPES
    • DECLARATION OPTIONS
    • NOT NULL
    • CONSTANT
    • DATA DICTIONARY INTEGRATION
    • %TYPE
    • DECLARE SIMPLE USER-DEFINED TYPES
    • TYPE ... TABLE
    • TYPE ... RECORD
    • EXTENDED USER-DEFINED TYPES
  • BEGIN SECTION
    • ABOUT THE BEGIN SECTION
    • MANIPULATING PROGRAM DATA
    • LOGIC CONTROL & BRANCHING
    • GOTO
    • LOOP
    • IF-THEN-ELSE
    • CASE
  • EXCEPTION SECTION
    • ABOUT THE EXCEPTION SECTION
    • ISOLATING THE SPECIFIC EXCEPTION
    • PRAGMA EXCEPTION_INIT
    • SQLCODE & SQLERRM Example
    • SQL%ROWCOUNT & SELECT…INTO
  • BEYOND THE BASICS: EXPLICIT CURSORS
    • ABOUT EXPLICIT CURSORS
    • EXTENDED CURSOR TECHNIQUES
    • FOR UPDATE OF Clause
    • WHERE CURRENT OF Clause
    • Using FOR…LOOP Cursors
  • INTRODUCING DATABASE-RESIDENT PROGRAM UNITS
    • ABOUT DATABASE-RESIDENT PROGRAMS
    • PHYSICAL STORAGE & EXECUTION
    • TYPES OF STORED PROGRAM UNITS
    • STORED PROGRAM UNIT ADVANTAGES
    • MODULAR DESIGN PRINCIPLES
  • CREATING STORED PROCEDURES & FUNCTIONS
    • STORED PROCEDURES & FUNCTIONS
    • CREATE PROCEDURE / CREATE FUNCTION
    • CREATING PROCEDURES & FUNCTIONS
    • RAISE_SALARY() Procedure
    • SALARY_VALID() Function
    • THE PARAMETER SPECIFICATION
    • DEFAULT Clause
    • SYSTEM & OBJECT PRIVILEGES
    • USING THE DEVELOPMENT TOOLS
  • EXECUTING STORED PROCEDURES & FUNCTIONS
    • CALLING PROCEDURES & FUNCTIONS
    • UNIT TESTING WITH EXECUTE
    • ANONYMOUS BLOCK UNIT TESTING
    • SPECIFYING A PARAMETER NOTATION
    • SQL WORKSHEET UNIT TESTING
    • CALLING FUNCTIONS FROM SQL
  • MAINTAINING STORED PROGRAM UNITS
    • RECOMPILING PROGRAMS
    • Mass Recompilation Using UTL_RECOMP()
    • DROPPING PROCEDURES & FUNCTIONS
    • DROP PROCEDURE / FUNCTION
    • DATA DICTIONARY METADATA
    • Using USER_OBJECTS
    • Using USER_SOURCE
    • Using USER_ERRORS
    • Using USER_OBJECT_SIZE
    • Using USER_DEPENDENCIES
  • MANAGING DEPENDENCIES
    • DEPENDENCY INTERNALS
    • TRACKING DEPENDENCIES
    • THE DEPENDENCY TRACKING UTILITY
    • SQL DEVELOPER DEPENDENCY INFO
    • DEPENDENCY STRATEGY CHECKLISTS
  • CREATING & MAINTAINING PACKAGES
    • ABOUT PACKAGES
    • CREATING PACKAGES
    • MAINTAINING PACKAGES
    • PERFORMANCE CONSIDERATIONS
  • ADVANCED PACKAGE CAPABILITIES
    • DEFINER & INVOKER RIGHTS
    • WHITE LISTS & ACCESSIBLE BY
    • PERSISTENT GLOBAL OBJECTS
    • DEFINING INITIALIZATION LOGIC
    • OBJECT ORIENTATION SUPPORT
  • ADVANCED CURSOR TECHNIQUES
    • USING CURSOR VARIABLES
    • Using SYS_REFCURSOR
    • USING CURSOR EXPRESSIONS
  • USING SYSTEM-SUPPLIED PACKAGES
    • DBMS_OUTPUT()
    • UTL_FILE()
    • FOPEN() Example
  • DATABASE TRIGGER CONCEPTS
    • ABOUT DATABASE TRIGGERS
    • DML EVENT TRIGGER SUB-TYPES
    • DATABASE TRIGGER SCENARIO
    • TRIGGER EXECUTION MECHANISMS
    • TRIGGERS WITHIN SQL WORKSHEET
  • CREATING DATABASE TRIGGERS
    • STATEMENT-LEVEL TRIGGERS
    • Using RAISE_APPLICATION_ERROR()
    • ROW-LEVEL TRIGGERS
    • EXAMPLES OF TRIGGERS: EMPLOYEE_SALARY_CHECK, EMPLOYEE_JOURNAL, BUDGET_EVENT
    • INSTEAD OF TRIGGERS
    • TRIGGERS WITHIN AN APPLICATION
  • MAINTAINING DATABASE TRIGGERS
    • CALL SYNTAX
    • TRIGGER MAINTENANCE TASKS
    • SHOW ERRORS TRIGGER
    • DROP TRIGGER
    • ALTER TRIGGER
    • MULTIPLE TRIGGERS FOR A TABLE
    • HANDLING MUTATING TABLE ISSUES
  • IMPLEMENTING SYSTEM EVENT TRIGGERS
    • WHAT ARE SYSTEM EVENT TRIGGERS?
    • DEFINING THE SCOPE
    • AVAILABLE SYSTEM EVENTS
    • SYSTEM EVENT ATTRIBUTES
  • RECENT ENHANCEMENTS
    • PLSCOPE_SETTINGS
    • DEPRECATE pragma
    • Conditional Compilation Using $IF, $ELSE, $END, and $ERROR
    • NOCOPY, PARALLEL_ENABLE Hints, and DETERMINISTIC Clause
    • INDEX_BY tables
    • BULK COLLECT
    • PLSQL_CODE_TYPE and PLSCOPE_SETTINGS
    • RETURNING clause with INSERT, UPDATE, DELETE
    • Code-Based Access Control (CBAC)
    • Handling Specific Warnings with PLSQL_WARNINGS
    • ACCESSIBLE BY clause
+ Prerequisites

Please check the course description to find prerequisite information.

+ Related Courses

Related Oracle Instructor-Led Courses

Click Class Title for Dates and Details Days Course Fee
Oracle 19c Database Administration5$2895
Oracle 19c PL/SQL Fundamentals3$2395
Oracle Database: SQL Fundamentals5$2995

As part of our commitment to supporting learners at every stage, we’re working to develop a library of free Oracle tutorials designed to help you tackle common tasks and workflows. We understand that not every situation calls for a full course, so these resources offer quick, practical guidance to help you get the job done efficiently.

Available Oracle On-Demand Courses

Course Title (Click For Details) Course Fee
No courses available

We have earned the trust of 15,481 customers, including these fine organizations:

United States Army Cisco United States Marine Corp HBO United States Air Force New York United States Navy Michigan Department of Homeland Security

Course Benefits

Certified Instructor Delivery

Learn with experienced professionally certified trainers that are subject matter experts.

Free Repeat

You have the option to retake this class one time within a year of your original class date.

Hands-On Training

Our courses are all designed for the students to have hands-on interaction throughout the course.

Local and Remote Options

Learn a local training center, or as a Remote Attendee from your home or office.

Offical Training Materials/Labs

We use Official Training Materials and Labs when available to ensure you have the most up to date training.

Convenient Scheduling

You are busy, we get it. Our classes are regularly scheduled to give you a number of convenience training options.

Financing Available

We offer affordable financing options for all of our courses to make sure cost is not a barrier to your progress.

Group Training Options

Have a team to train? We offer On-Site, Blended and Online Private Group Training services.

Boost Your Career

Getting professional training is one of the fastest ways to improve your skills and marketability.

Get Started Today!

Course Registration

Benefits of Virtual Live-Instructor Training Include:

  • Learn from Experts in Real Time
  • Hands-On Skill Development
  • Train Anywhere, Anytime
  • Boost Your Career Prospects
  • Conveniently Scheduled Sessions
Get a Free Consultation

SAVE 10% FOR A LIMITED TIME

$2995 / 5 Day Course



  • Professional Instructors
  • Official Course Materials
  • Small Class Sizes
  • Financing Available

Course Schedule

Course Title Dates Times Location Fee
Oracle Database: PL/SQL Fundamentals 11/17/2025 – 11/21/2025 10:00AM-4:45PM EST Local/Remote $2,995.00
Oracle Database: PL/SQL Fundamentals 12/15/2025 – 12/19/2025 10:00AM-4:45PM EST Local/Remote $2,995.00
Oracle Database: PL/SQL Fundamentals 1/12/2026 – 1/16/2026 10:00AM-4:45PM EST Local/Remote $2,995.00
Oracle Database: PL/SQL Fundamentals 2/9/2026 – 2/13/2026 10:00AM-4:45PM EST Local/Remote $2,995.00
Oracle Database: PL/SQL Fundamentals 3/9/2026 – 3/13/2026 10:00AM-4:45PM EST Local/Remote $2,995.00
Oracle Database: PL/SQL Fundamentals 4/6/2026 – 4/10/2026 10:00AM-4:45PM EST Local/Remote $2,995.00

Related Oracle Instructor-Led Courses

Click Class Title for Dates and Details Days Course Fee
Oracle 19c Database Administration5$2895
Oracle 19c PL/SQL Fundamentals3$2395
Oracle Database: SQL Fundamentals5$2995

As part of our commitment to supporting learners at every stage, we’re working to develop a library of free Oracle tutorials designed to help you tackle common tasks and workflows. We understand that not every situation calls for a full course, so these resources offer quick, practical guidance to help you get the job done efficiently.

Available Oracle On-Demand Courses

Course Title (Click For Details) Course Fee
No courses available
NEED GROUP TRAINING?

We Offer Live-Instructor Private Group Training

Benefits of Group Training Include:

  • Experienced Professional Instructor Trains Your Team
  • Content Focused On Your Team’s Needs
  • Convenient Scheduling and Class Setup
  • Significant Per/Student Cost Savings
  • Online, On-Site and Blended Options Available

Learn How Group Training Can Benefit Your Team

Request A Free Quote

Oracle Certifications Available

Oracle certifications are a powerful way to validate your Oracle skills, and gain recognition as a trusted expert in the field. Whether you're an individual looking to boost your career or an organization investing in team development, our courses are designed to help you earn these industry-recognized credentials.

» View All Oracle Certifications

Let us help you or your team get certified and stay competitive.

CompTIA A+ (Core 1 & Core 2) – V15

This certification equips students with the skills required to install, configure, secure, and troubleshoot today’s devices and operating systems in business environments.

Topics Include:

  • PC hardware installation & configuration
  • Wired/Wireless networking fundamentals & SOHO setup
  • Operating systems – Windows, macOS, Linux & mobile OS basics
  • Security best practices for endpoints & small networks
  • Virtualization & cloud computing concepts
  • Mobile devices, peripherals & printing
  • Troubleshooting methodology for hardware, OS, and networks
  • Operational procedures, safety, documentation & professionalism

This certification is ideal for individuals starting an IT career path or transitioning from another field into technical support and help desk roles.

learn more →
CompTIA A+ (Core 1 & Core 2) – V15

This certification equips students with the skills required to install, configure, secure, and troubleshoot today’s devices and operating systems in business environments.

Topics Include:

  • PC hardware installation & configuration
  • Wired/Wireless networking fundamentals & SOHO setup
  • Operating systems – Windows, macOS, Linux & mobile OS basics
  • Security best practices for endpoints & small networks
  • Virtualization & cloud computing concepts
  • Mobile devices, peripherals & printing
  • Troubleshooting methodology for hardware, OS, and networks
  • Operational procedures, safety, documentation & professionalism

This certification is ideal for individuals starting an IT career path or transitioning from another field into technical support and help desk roles.

learn more →
Autodesk Certified Professional (ACP) – AutoCAD

This certification is aimed at professionals who have advanced skills in AutoCAD and have experience working on more complex projects. It is typically recommended for those with around 400 hours of real-world experience.

Key areas covered:

  • Drawing objects, editing, and organizing objects
  • Advanced annotation techniques (hatch patterns, annotations)
  • Creating and managing reusable content (blocks, symbols)
  • Managing layouts and viewports
  • Output formats and publishing files
  • Working with external references (Xrefs) and data linking
  • Using AutoCAD’s productivity tools (parametric constraints, sheet sets)
learn more →
Autodesk Certified Expert (ACE) – AutoCAD (New)

Autodesk introduced an expert-level certification to cater to professionals who are highly skilled in AutoCAD and involved in more specialized, complex tasks like 3D modeling, parametric design, and custom workflows.

Key areas covered:

  • 3D modeling and design
  • Collaboration workflows with external data sets
  • Customizing AutoCAD using scripts and macros
  • Advanced rendering techniques
  • Interoperability with other Autodesk products

These certifications help individuals and professionals stand out in the job market by proving their expertise in AutoCAD to employers. Autodesk often updates its certification paths, so it’s always a good idea to check their official site or authorized training centers for the most current information.

learn more →

Flexible Oracle Training Formats

Choose the training experience that fits your schedule, learning style, and professional goals. We offer flexible options for individuals and teams—whether you prefer virtual live instruction, on-demand access, or private group training.

Virtual Instructor-Led

Attend scheduled classes taught by expert instructors in real time. You can join remotely or from one of 250+ training center locations—for engaging, skill-based instruction with real-time support.

Learn More →

On Demand Training

Access pre-recorded Oracle courses 24/7. Learn at your own pace with flexible, self-guided modules—ideal for busy professionals or those who prefer to study independently.

Learn More →

Private Group Training

Tailored Oracle training for your organization—delivered either online or onsite. Designed to meet your team’s specific needs and schedule. Perfect for teams needing consistent, tailored instruction.

>Learn More →

Over 250 Locations Nationwide

Alabama
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
Florida
Georgia
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
Tennessee
Texas
Utah
Virginia
Washington
Washington DC
Wisconsin

Client Reviews

Here’s what professionals and teams across the country are saying about their experience with Business Computer Skills

★★★★★
Rating 5.0 / 5.0

This was the class I needed. The instructor Jeff took his time and made sure we understood each topic before moving to the next. He answered all of our questions, and I don’t know about the rest of the students, but was very pleased with this experience.

Amanda T.,
Yale New Haven Hospital

★★★★★
5 / 5