Oracle Database 19c: Advanced PL/SQL Advanced
The Oracle Database 19c: Advanced PL/SQL course teaches developers and database administrators how to write, tune, and secure high-performance PL/SQL code using collections, large objects, and advanced security mechanisms. Designed for professionals managing complex Oracle environments, it solves the critical pain point of inefficient, insecure database programming. Over 40% of Fortune 500 companies rely on Oracle databases, creating sustained demand for certified PL/SQL developers who can optimize mission-critical systems.
This course prepares learners for the Oracle 1Z0-149: Program with PL/SQL certification exam. Koenig Solutions delivers official Oracle University courseware with 30-day lab access, enabling hands-on mastery. Graduates gain the expertise to pursue roles like PL/SQL Developer or Database Architect, with professionals in these positions earning average salaries up to $147,500.
Training Formats & Pricing
100% Happiness Guarantee · Free Rescheduling · Secure Payment
Course Overview
The Oracle Database 19c: Advanced PL/SQL course by Oracle is designed for database administrators, PL/SQL developers, and software engineers seeking to master advanced programming techniques within the Oracle ecosystem. This comprehensive training prepares candidates for the Oracle Database Program with PL/SQL (1Z0-149) certification exam, a key credential for professionals targeting the Oracle PL/SQL Developer Certified Professional designation. Geared toward individuals with prior PL/SQL experience, the course addresses critical industry demands, as Oracle remains the backbone of 97% of Fortune 500 enterprises’ database systems, driving sustained need for skilled developers who can optimize complex database operations. Participants will gain expertise in high-performance code design, secure application development, and integration with modern data types including JSON and SecureFile LOBs.
Students engage with core Oracle technologies such as Oracle Database 19c, Oracle Exadata Express Cloud Service, DBMS_LOB, DBMS_RLS, UTL_FILE, and DBMS_PROFILER, building proficiency in real-world development scenarios. The hands-on lab environment leverages Oracle SQL Developer and Oracle Cloud Console, where learners configure advanced PL/SQL applications using collections, bulk binding, and dynamic SQL. A key project involves designing a secure, high-performance financial transaction processing system that uses fine-grained access control, result caching, and SecureFile LOBs to store encrypted documents, simulating enterprise-level data handling requirements. Through these labs, participants gain practical experience in profiling code with DBMS_PROFILER, implementing conditional compilation, and safeguarding against SQL injection using DBMS_ASSERT.
This course directly prepares learners for the Oracle 1Z0-149 certification, which is globally recognized for validating advanced PL/SQL expertise and is often required for senior database roles. Certified professionals report average annual salaries of $99,000, with senior developers earning up to $159,586 based on experience and specialization. Koenig Solutions enhances this learning path with Guaranteed-to-Run batches and official Oracle University courseware, ensuring consistent access to up-to-date content and expert instruction. Upon completion, graduates are positioned to advance into roles such as Senior PL/SQL Developer, Database Architect, or Cloud Database Engineer, equipped to design scalable, secure, and high-performance database solutions in enterprise environments.
What You'll Learn
Skills You'll Gain
Prerequisites
- Formal Prerequisite: Completion of 'Oracle Database: Program with PL/SQL' is required to establish the necessary baseline for Oracle Database 19c: Advanced PL/SQL.
- Skill-based Prerequisites: Proficiency in SQL, hands-on experience with PL/SQL program units (procedures, functions, and packages), and practical application development experience are essential.
- Technical Environment Requirements: Learners must have access to an Oracle Database 19c instance and a functional development environment, such as Oracle SQL Developer or SQL*Plus, to complete course exercises.
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– Oracle Database 19c: Advanced PL/SQL Foundations
2
Day 2– Advanced Collections and Oracle PL/SQL Logic
3
Day 3– Managing Large Objects in Oracle Database 19c
4
Day 4– JSON Integration and Advanced Oracle Interfaces
5
Day 5– Performance Tuning and Oracle Database Security
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
- Senior PL/SQL Developer
- Database Architect
- Oracle Database Administrator
- PL/SQL Application Developer
- ETL Developer
- Database Systems Engineer
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
Frequently Asked Questions
Everything you need to know about the 1Z0-149 training course
Is the Oracle Database 19c: Advanced PL/SQL certification exam included in the course fee, and what is the exam cost?
What training formats does Koenig offer for Oracle Database 19c: Advanced PL/SQL, including Guaranteed-to-Run scheduling?
How long is lab access provided, and what environment is used for Oracle Database 19c: Advanced PL/SQL?
What is Koenig's rescheduling and cancellation policy for this course?
What is the format, number of questions, time limit, and passing score for the Oracle 1Z0-149 exam?
How long is the Oracle Advanced PL/SQL Developer certification valid, and what is the renewal process?
What post-training support does Koenig provide after completing Oracle Database 19c: Advanced PL/SQL?
What are the prerequisites or prior experience needed for Oracle Database 19c: Advanced PL/SQL?
What is the average salary impact or career advancement after earning the Oracle Advanced PL/SQL certification?
How does Koenig's instructor-led training compare to self-study for Oracle Database 19c: Advanced PL/SQL?
Still have questions?
Chat with a Training Advisor →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.