Oracle Database 19c: PL/SQL Workshop Intermediate
The Oracle Database 19c: PL/SQL Workshop teaches database developers and application programmers how to build efficient, automated database solutions using Oracle’s procedural language, solving the critical industry gap where 68% of enterprises report a shortage of skilled PL/SQL developers. You’ll gain hands-on expertise in writing maintainable code, managing exceptions, and creating stored procedures, functions, and triggers essential for high-performance Oracle applications.
This course prepares learners for the Oracle PL/SQL Developer Certified Professional credential, featuring Koenig Solutions’ Guaranteed-to-Run scheduling and 30-day lab access. Mastering these skills enables career advancement into senior database development roles with average salaries exceeding $110,000 annually.
Training Formats & Pricing
100% Happiness Guarantee · Free Rescheduling · Secure Payment
Course Overview
The Oracle Database 19c: PL/SQL Workshop by Oracle is designed for database developers, application programmers, and DBAs seeking to master procedural programming within the Oracle ecosystem. This course prepares learners for the Oracle Database Program with PL/SQL (1Z0-149) certification exam, a key credential for achieving Oracle PL/SQL Developer Certified Professional status. Participants will gain expertise in writing efficient, modular PL/SQL code to build robust database applications. With over 420,000 Oracle Database installations worldwide relying on PL/SQL for business logic automation, this skill set remains critical for organizations across finance, healthcare, and enterprise IT sectors.
Students engage with core Oracle technologies including Oracle Database 19c, Oracle SQL Developer, and Oracle-supplied packages like DBMS_OUTPUT and UTL_FILE. The hands-on labs are conducted within Oracle’s cloud-based learning environment, accessible via ouconnect.oracle.com, where students configure and manage database-resident program units. Learners build reusable procedures, functions, triggers, and packages while implementing advanced features such as dynamic SQL and bulk data processing using BULK COLLECT and FORALL. A key real-world scenario involves designing a transaction monitoring system using compound triggers to enforce data integrity and log changes automatically.
This course provides direct preparation for the Oracle 1Z0-149 certification, which is recognized globally for validating advanced PL/SQL proficiency. Certified professionals report an average salary increase of 18%, with senior PL/SQL developers earning between $95,000 and $130,000 annually in North America. Koenig Solutions enhances learning with official Oracle courseware, Guaranteed-to-Run batches, and optional 1-on-1 mentoring to ensure mastery. Completing the Oracle Database 19c: PL/SQL Workshop opens pathways to roles such as Senior Database Developer, PL/SQL Architect, or Oracle Application Engineer, positioning graduates at the forefront of enterprise database innovation.
What You'll Learn
Skills You'll Gain
Prerequisites
- Required: Completion of Oracle Database: SQL Workshop or equivalent experience.
- Required: Working knowledge of relational database concepts, including tables, views, and indexes.
- Required: Experience with SQL Developer or SQL*Plus for executing SQL and PL/SQL commands.
- Recommended: Understanding of Oracle Database 19c architecture to support PL/SQL integration.
- Recommended: Ability to write and execute complex SQL queries for practical application in Oracle Database 19c: PL/SQL Workshop.
- Recommended: Familiarity with procedural programming constructs to assist in mastering PL/SQL scripting within Oracle Database 19c.
Certification Exam
Everything you need to know about the 1Z0-149 certification exam
Course Curriculum
Structured learning with hands-on labs and real-world scenarios
1
Day 1– Master Oracle Database 19c: PL/SQL Workshop Essentials
2
Day 2– Defining PL/SQL Variables and Data Types
3
Day 3– Executable Statements and Control Structures
4
Day 4– SQL Integration and Cursor Management
5
Day 5– Error Handling and Stored Program Units
What's Included in Your Training
Every enrollment comes packed with resources to maximise your learning and exam success
Exam Preparation Materials
Practice Test Questions (200+)
Certificate of Completion
Post-Training Support (30 days)
Session Recording Access
Free Rescheduling (7+ days notice)
Career Outcomes
of 1Z0-149 certified professionals report career advancement within 6 months
Salary Impact
Average salary increase reported after obtaining the 1Z0-149 certification
*Source: Glassdoor / LinkedIn 2025
Job Roles
- PL/SQL Developer
- Database Developer
- Oracle Application Developer
- Database Programmer
- Database Analyst
- Data Warehouse Analyst
Companies Hiring
and 5,000+ organizations worldwide seeking 1Z0-149 certified professionals
Course Student Reviews
Real results from IT professionals who trained with Koenig — rated 4.9/5 from 18,400+ verified reviews.
-
★★★★★
“Passed AZ-104 on first attempt. The MCT knew the exact exam patterns and the labs were exactly what Microsoft tests. Worth every penny.”
AZ-104 Certified ✓ Verified -
★★★★★
“I trained 15 of my team members for SC-200. Koenig's on-site delivery was seamless and all 15 passed within 3 months.”
Enterprise Client ✓ Verified -
★★★★★
“The 1-on-1 format was a game changer. My trainer adjusted the pace to my schedule and I cleared PL-300 while working full-time.”
PL-300 Certified ✓ Verified -
★★★★★
“From AZ-900 to AZ-305 in 6 months. Koenig's structured roadmap and MCT mentoring made the expert level achievable.”
AZ-305 Expert ✓ Verified -
★★★★★
“As an L&D head I've used 5 training vendors. Koenig's MCT quality, MOC materials, and ESI compliance is in a different league.”
100+ Learners Trained ✓ Verified -
★★★★★
“SC-900 and SC-300 back to back — both cleared first try. The security curriculum at Koenig is incredibly thorough and up to date.”
SC-300 Certified ✓ Verified -
★★★★★
“AI-102 was daunting but the trainer broke it down perfectly. Real Azure OpenAI labs made the difference. Highly recommend.”
AI-102 Certified ✓ Verified -
★★★★★
“DP-600 Fabric certification done in 3 weeks of part-time study. The customised schedule around my timezone was a lifesaver.”
DP-600 Certified ✓ Verified -
★★★★★
“Our whole DevOps team got AZ-400 certified through Koenig's corporate training. Smooth logistics and top-tier MCTs throughout.”
AZ-400 Team Training ✓ Verified -
★★★★★
“Passed AZ-104 on first attempt. The MCT knew the exact exam patterns and the labs were exactly what Microsoft tests. Worth every penny.”
AZ-104 Certified ✓ Verified -
★★★★★
“I trained 15 of my team members for SC-200. Koenig's on-site delivery was seamless and all 15 passed within 3 months.”
Enterprise Client ✓ Verified -
★★★★★
“The 1-on-1 format was a game changer. My trainer adjusted the pace to my schedule and I cleared PL-300 while working full-time.”
PL-300 Certified ✓ Verified -
★★★★★
“From AZ-900 to AZ-305 in 6 months. Koenig's structured roadmap and MCT mentoring made the expert level achievable.”
AZ-305 Expert ✓ Verified -
★★★★★
“As an L&D head I've used 5 training vendors. Koenig's MCT quality, MOC materials, and ESI compliance is in a different league.”
100+ Learners Trained ✓ Verified -
★★★★★
“SC-900 and SC-300 back to back — both cleared first try. The security curriculum at Koenig is incredibly thorough and up to date.”
SC-300 Certified ✓ Verified -
★★★★★
“AI-102 was daunting but the trainer broke it down perfectly. Real Azure OpenAI labs made the difference. Highly recommend.”
AI-102 Certified ✓ Verified -
★★★★★
“DP-600 Fabric certification done in 3 weeks of part-time study. The customised schedule around my timezone was a lifesaver.”
DP-600 Certified ✓ Verified -
★★★★★
“Our whole DevOps team got AZ-400 certified through Koenig's corporate training. Smooth logistics and top-tier MCTs throughout.”
AZ-400 Team Training ✓ Verified
-
★★★★★
“Passed AZ-104 on first attempt. The MCT knew the exact exam patterns and the labs were exactly what Microsoft tests. Worth every penny.”
AZ-104 Certified ✓ Verified -
★★★★★
“I trained 15 of my team members for SC-200. Koenig's on-site delivery was seamless and all 15 passed within 3 months.”
Enterprise Client ✓ Verified -
★★★★★
“The 1-on-1 format was a game changer. My trainer adjusted the pace to my schedule and I cleared PL-300 while working full-time.”
PL-300 Certified ✓ Verified -
★★★★★
“Passed AZ-104 on first attempt. The MCT knew the exact exam patterns and the labs were exactly what Microsoft tests. Worth every penny.”
AZ-104 Certified ✓ Verified -
★★★★★
“I trained 15 of my team members for SC-200. Koenig's on-site delivery was seamless and all 15 passed within 3 months.”
Enterprise Client ✓ Verified -
★★★★★
“The 1-on-1 format was a game changer. My trainer adjusted the pace to my schedule and I cleared PL-300 while working full-time.”
PL-300 Certified ✓ Verified
-
★★★★★
“From AZ-900 to AZ-305 in 6 months. Koenig's structured roadmap and MCT mentoring made the expert level achievable.”
AZ-305 Expert ✓ Verified -
★★★★★
“As an L&D head I've used 5 training vendors. Koenig's MCT quality, MOC materials, and ESI compliance is in a different league.”
100+ Learners Trained ✓ Verified -
★★★★★
“SC-900 and SC-300 back to back — both cleared first try. The security curriculum at Koenig is incredibly thorough and up to date.”
SC-300 Certified ✓ Verified -
★★★★★
“From AZ-900 to AZ-305 in 6 months. Koenig's structured roadmap and MCT mentoring made the expert level achievable.”
AZ-305 Expert ✓ Verified -
★★★★★
“As an L&D head I've used 5 training vendors. Koenig's MCT quality, MOC materials, and ESI compliance is in a different league.”
100+ Learners Trained ✓ Verified -
★★★★★
“SC-900 and SC-300 back to back — both cleared first try. The security curriculum at Koenig is incredibly thorough and up to date.”
SC-300 Certified ✓ Verified
-
★★★★★
“AI-102 was daunting but the trainer broke it down perfectly. Real Azure OpenAI labs made the difference. Highly recommend.”
AI-102 Certified ✓ Verified -
★★★★★
“DP-600 Fabric certification done in 3 weeks of part-time study. The customised schedule around my timezone was a lifesaver.”
DP-600 Certified ✓ Verified -
★★★★★
“Our whole DevOps team got AZ-400 certified through Koenig's corporate training. Smooth logistics and top-tier MCTs throughout.”
AZ-400 Team Training ✓ Verified -
★★★★★
“AI-102 was daunting but the trainer broke it down perfectly. Real Azure OpenAI labs made the difference. Highly recommend.”
AI-102 Certified ✓ Verified -
★★★★★
“DP-600 Fabric certification done in 3 weeks of part-time study. The customised schedule around my timezone was a lifesaver.”
DP-600 Certified ✓ Verified -
★★★★★
“Our whole DevOps team got AZ-400 certified through Koenig's corporate training. Smooth logistics and top-tier MCTs throughout.”
AZ-400 Team Training ✓ Verified
Resources
Learn more about 1Z0-149 before you enroll
What to Expect in an Oracle MySQL Training Course
In the world of databases, MySQL stands as one of the most widely used open-source relational database management systems. Whether it's powe…
Read GuideTop Skills You’ll Gain from Oracle GoldenGate Training
As data-driven decision-making becomes increasingly mission-critical, the demand for real-time data replication and integration tools has sk…
Read ArticleWhat You’ll Learn in an Oracle Development Certification Program
In the world of data-driven enterprise applications, Oracle databases remain a cornerstone technology across industries like finance, health…
Read ArticleHappiness Guarantee
We are so confident in the quality of our training that we offer a full money-back guarantee. Not satisfied? Contact us within 24 hours of your first session — we'll refund you completely, no questions asked.