0

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Job Ready Oracle PL/SQL Developer: From Basics to Master

Job Ready Oracle PL/SQL Developer: From Basics to Master: Become a Job-Ready Oracle PL/SQL Developer with Real-World Application Skills

Mayko Silva

$39.99

Video Feb 2026 12hrs 38mins 1st Edition

Renews at $19.99p/m

Mayko Silva

$39.99

Video Feb 2026 12hrs 38mins 1st Edition

Renews at $19.99p/m

Renews at $19.99p/m

What do you get with a video?

Download this video in MP4 format

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

View table of contents

Key benefits

Includes practical exercises for hands-on experience in PL/SQL
Covers both fundamental and advanced PL/SQL concepts with real-world examples
Structured to support beginners transitioning into advanced PL/SQL roles

Description

Begin your Oracle PL/SQL journey by setting up your lab environment, including installing Oracle Express Edition and configuring essential tools like SQL Developer. The course takes you through essential concepts such as database interaction, transactions, and control structures, providing the foundation for successful development. The course then progresses into more advanced topics, including cursor management, exception handling, and dynamic SQL. As you move through each section, you will work with real-world examples, developing critical skills in database optimization, error logging, and debugging, ensuring you can produce efficient and reliable code. The final modules cover complex data structures, triggers, and PL/SQL packages, equipping you with the knowledge to handle real-world database problems. By the end of the course, you'll have mastered PL/SQL and will be ready for advanced database roles, including Oracle certification and technical leadership positions.

Who is this book for?

This course is ideal for entry to mid-level SQL developers looking to expand their skill set, database administrators aiming to enhance their PL/SQL proficiency, and software developers working with Oracle databases. It’s also suitable for professionals interested in improving their PL/SQL expertise to take on advanced database development roles, as well as those transitioning from basic SQL to complex PL/SQL programming.

What you will learn

Set up Oracle PL/SQL tools and development environments
Master cursors, triggers, and dynamic SQL in Oracle PL/SQL
Implement advanced error handling and debugging strategies
Create and manage PL/SQL packages and stored procedures
Optimize database performance with PL/SQL best practices
Develop real-world applications using PL/SQL techniques

What do you get with a video?

Download this video in MP4 format

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

Product Details

Last updated date : Feb 11, 2026

Publication date : Feb 11, 2026

Length: 12hrs 38mins

Edition : 1st

Language : English

ISBN-13 : 9781807603175

Category :

Data

Languages :

SQL

Concepts :

Database Programming

Table of Contents

26 Chapters

How to Create Your Own Free Lab to Practice

Oracle PL/SQL Training: Setting Up Your Lab Environment

How to Access PDFs and Source Codes

Install Oracle Express Edition on Your Windows Machine

How to Install Oracle Sample Schema on Oracle Express Edition on Windows

How to Connect With HR Schema on Oracle Express Edition on Windows

How to Install Oracle Virtual Box

How to Install Oracle VirtualBox Extension Pack

How to Import Oracle Virtual Machine Template

How to Start Your Virtual Machine Template

How to Start the Oracle Database and Listener in Your Lab

How to Connect to Your Virtual Machine Using SSH with Putty or MobaXterm

How to Check Environment Variables in Your Oracle Server

Oracle Pluggable Databases vs Container Databases

Oracle TNS Alias, TNSNAMES.ORA and Easy Connect

Introduction to Oracle Databases

Getting to Know Oracle Database

Introduction to Oracle Databases

Schema Objects: The Building Blocks of Your Oracle Database

Data Access: Getting Your Hands on the Data

Oracle Database Transaction Management: A Comprehensive Beginner's Guide

Oracle Database Architecture: An Overview

Structured Query Language: Crash Course for Everyone

What is a Database and Why it Matters?

What is SQL and Why is it So Important?

Diving Deeper into Relational Databases

How to Create a Table on Oracle

SQL Queries: The Basics for Everyone

Data Model in SQL: The Basics for Everyone

Introduction to PL/SQL

Introduction to Oracle PL/SQL

Oracle PL/SQL Architecture

How to Install Oracle SQL Developer

How to Install Oracle SQL*Plus

How to Configure the TNS File for Oracle Connections

Development Tools for Oracle PL/SQL Programmers

The Basic PL/SQL Block Structure

PL/SQL Variables

Introduction to Control Structures

Using the DBMS_OUTPUT PL/SQL Package to Show Data on Screen

Asking for User Information on Oracle PL/SQL

SQL Inside PL/SQL

Exception Handling

PL/SQL Language Fundamentals

Language Fundamentals

Anchored Data Types in PL/SQL

Scope and Visibility in Oracle PL/SQL

Labels on PL/SQL Blocks

Using SQL Within Oracle PL/SQL

Using the SELECT INTO Statement

DML Operations and Sequences in Oracle PL/SQL

Transaction Control in Oracle PL/SQL

Set Isolation Level on PL/SQL

Conditional Control in Oracle PL/SQL with IF Statements and Nested IF Statements

IF-THEN and IF-THEN-ELSE Statements

ELSIF Statements in Oracle PL/SQL

Nested IF Statements in Oracle PL/SQL

Logical Operators

Advanced Conditional Control in Oracle PL/SQL

CASE Statements in Oracle PL/SQL

Searched CASE Statements in Oracle PL/SQL

CASE Expressions in Oracle PL/SQL

NULLIF and COALESCE Functions in Oracle PL/SQL

Mastering Iterative Control Structures in PL/SQL – Part 1

SIMPLE LOOPS in Oracle PL/SQL

WHILE LOOPS in Oracle PL/SQL

NUMERIC FOR LOOPS in Oracle PL/SQL

Mastering Iterative Control Structures in PL/SQL – Part 2

Skipping Ahead with CONTINUE Statement in Oracle PL/SQL

CONTINUE Position Matters in Oracle PL/SQL

CONTINUE Position Matters – Part 2

Nested Loops and Loop Labels in Oracle PL/SQL

Mastering Error Management and Built-in Exceptions in Oracle PL/SQL

UNDERSTANDING ERROR HANDLING IN ORACLE PL/SQL

Built-In Exceptions in Oracle PL/SQL

Advanced Exception Handling in Oracle PL/SQL

Mastering Exception Scope in Oracle PL/SQL

User-Defined Exceptions in Oracle PL/SQL

ERROR PROPAGATION AND RE-RAISING EXCEPTIONS IN ORACLE PL/SQL

Mastering Advanced Exception Handling in Oracle PL/SQL

RAISE_APPLICATION_ERROR - Your Custom Alarm System

THE EXCEPTION INIT PRAGMA IN ORACLE PL/SQL

SQLCODE & SQLERRM IN ORACLE PL/SQL

Introduction to Cursors: The Basics that Everyone Needs to Know

Understanding Implicit and Explicit Cursors

Working with Table-Based and Cursor-Based Records

Simplifying Cursor Processing with Cursor FOR Loops

Mastering Nested Cursors

Advanced Cursor Techniques – Taking Your Oracle Database Skills to the Next Level

Enhancing Cursors with Parameters

Mastering Cursor Variables and Expressions

Updating Data with FOR UPDATE Cursors

Database Triggers: Your Automatic Assistants

Getting to Know Your Triggers

Autonomous Transactions on Triggers

Row-Level Triggers vs Statement-Level Triggers

Instead of Triggers: For Non-Updatable Views

Mutating Tables and Oracle Compound Triggers

Mutating Tables

Compound Triggers in Oracle PL/SQL

Oracle PL/SQL Collections: PL/SQL Tables, V-Arrays, Collections

PL/SQL Tables in Oracle

Multi-Dimensional Collections in Oracle PL/SQL

Collection Iteration Controls and Qualified Expressions in PL/SQL

Advanced Data Structures in PL/SQL – Records and Collections of Records

User-Defined Records in Oracle PL/SQL

Qualified Expressions with Records in Oracle PL/SQL

Record Compatibility in Oracle PL/SQL

Collection of Records

Native Dynamic SQL

Introduction to this Module

EXECUTE IMMEDIATE Statement in Oracle PL/SQL

Mastering Bind Variables and Placeholders in Dynamic SQL

DDL and DML Statements Dynamically in Oracle PL/SQL: RETURN AND RETURN INTO

OPEN, FETCH, and CLOSE in Dynamic SQL with Oracle PL/SQL

Mastering Bulk SQL in Oracle PL/SQL

FORALL Statements in Oracle PL/SQL

SAVE EXCEPTIONS with FORALL Loops in Oracle PL/SQL

FORALL Loops with Indices of in Oracle PL/SQL

FORALL Loops with Values of in Oracle PL/SQL

BULK COLLECT with SELECT Statements in Oracle PL/SQL

BULK COLLECT with Record Types

BULK COLLECT with Limit Clause for Batch Operations and Large Datasets

BULK COLLECT with RETURNING Clause for Immediate Auditing or Logging in Oracle

Binding Collections When Using EXECUTE IMMEDIATE Statements in Oracle PL/SQL

Collections with OPEN FOR Statements in Oracle PL/SQL

FETCH and CLOSE with Collections in Dynamic SQL

Dynamic Native SQL Binding Using Collections as Parameters in Oracle PL/SQL

Oracle PL/SQL Procedures

Creating Nested Procedures in Oracle PL/SQL

IN, OUT and IN OUT Parameters in Oracle PL/SQL

Forward Declaration: Solve the Classic "Chicken and Egg" Problem in Programming

Create Stand-Alone Procedures: How to Create Super Mini Applications in PL/SQL

Oracle PL/SQL Functions

Introduction to Oracle PL/SQL Functions

Oracle PL/SQL Nested Functions: Russian Nesting Dolls

Mastering Standalone Functions in Oracle PL/SQL

Advanced Concepts in Oracle PL/SQL Functions: Deterministic and Result_Cache

Practical Project – Building a Student Management System with PL/SQL

Mastering Oracle PL/SQL Packages

How to Create Packages in Oracle PL/SQL

Package Instantiation, Initialization, and Package State in Oracle PL/SQL

Serially_Reusable Packages in Oracle PL/SQL

Bonus Section – Oracle Database Architecture

Introduction to Oracle Database 23C Architecture

Oracle 23c Memory Structures: SGA and PGA

Oracle 23c Background Processes: New and Enhanced Background Processes

Logical and Physical Storage Structures in Oracle 23c

Oracle Database 23c Architecture: Summary and Best Practices

Bonus Section – Restricting and Sorting Data in Oracle SQL

Comparison Operators and the BETWEEN Operator

The IN Operator

Using the LIKE Operator for Pattern Matching

Recommendations for you

LLM Engineer's Handbook

LLM Engineer's Handbook

Oct 2024 522 pages

eBook

$43.19 ~~$47.99~~

Getting Started with Tableau 2018.x

Getting Started with Tableau 2018.x

Sep 2018 396 pages

eBook

$39.59 ~~$43.99~~

Semantic Kernel SDK for Intelligent Applications

Semantic Kernel SDK for Intelligent Applications

Feb 2026 3hrs 35mins

Video

$120.99

AI Ecosystem for the Absolute Beginners - Hands-On

AI Ecosystem for the Absolute Beginners - Hands-On

Feb 2026 5hrs 7mins

Video

$119.99

Python for Algorithmic Trading Cookbook

Python for Algorithmic Trading Cookbook

Aug 2024 406 pages

eBook

$43.19 ~~$47.99~~

RAG-Driven Generative AI

RAG-Driven Generative AI

Sep 2024 338 pages

eBook

$32.39 ~~$35.99~~

Machine Learning with PyTorch and Scikit-Learn

Machine Learning with PyTorch and Scikit-Learn

Feb 2022 774 pages

eBook

$39.59 ~~$43.99~~

Building LLM Powered Applications

Building LLM Powered Applications

May 2024 342 pages

eBook

$35.99 ~~$39.99~~

Python Machine Learning By Example

Python Machine Learning By Example

Jul 2024 526 pages

eBook

$33.29 ~~$36.99~~

AI Product Manager's Handbook

AI Product Manager's Handbook

Nov 2024 488 pages

eBook

$28.79 ~~$31.99~~

About the author

Mayko Silva

Mayko Silva

Mayko Silva is an IT professional with over 18 years of experience, specializing in administering critical Oracle and DB2 databases. His expertise in system performance extends to SAP and Linux operating systems. Mayko is committed to delivering high-quality, affordable training. His certifications include Oracle Certified Professional (OCP), Oracle Real Application Cluster Specialist, DB2 Advanced Administrator, and SAP System Netweaver Administrator.

See other products by Mayko Silva

FAQs

How can I download a video package for offline viewing?

Login to your account at Packtpub.com.
Click on "My Account" and then click on the "My Videos" tab to access your videos.
Click on the "Download Now" link to start your video download.

How can I extract my video file?

All modern operating systems ship with ZIP file extraction built in. If you'd prefer to use a dedicated compression application, we've tested WinRAR / 7-Zip for Windows, Zipeg / iZip / UnRarX for Mac and 7-Zip / PeaZip for Linux. These applications support all extension files.

How can I get help and support around my video package?

If your video course doesn't give you what you were expecting, either because of functionality problems or because the content isn't up to scratch, please mail customercare@packt.com with details of the problem. In addition, so that we can best provide the support you need, please include the following information for our support team.

Video
Format watched (HTML, MP4, streaming)
Chapter or section that issue relates to (if relevant)
System being played on
Browser used (if relevant)
Details of support

Why can’t I download my video package?

In the even that you are having issues downloading your video package then please follow these instructions:

Disable all your browser plugins and extensions: Some security and download manager extensions can cause issues during the download.
Download the video course using a different browser: We've tested downloads operate correctly in current versions of Chrome, Firefox, Internet Explorer, and Safari.