Oracle Advanced PL-SQL - 3 days Online Classroom
2.350,00 EUR
- 3 days
Take your Oracle programming skills to the next level with the Oracle Advanced PL/SQL course. Designed for experienced Oracle developers and database professionals, this hands-on training explores advanced programming techniques that help you build faster, more secure, and scalable database applications. Throughout the course, you'll learn how to optimise PL/SQL performance, work efficiently with collections and large objects (LOBs), implement fine-grained access control, strengthen application security, and integrate PL/SQL with external programs. You'll also gain practical experience using Oracle's built-in packages and performance profiling tools to diagnose bottlenecks and improve application efficiency. By the end of the course, you'll have the advanced skills needed to develop robust, high-performance Oracle applications while following industry best practices for security, maintainability, and performance
Key Features
Language
Course and materials are in English
Level
Intermediate level - Advanced level
3 days (8 hours / day) live classroom
with accredited trainers
40+ recommended study hours
Exercises and solutions
Downloadable PDF documents with detailed content (slides, explanations)
Certificate
Certificate of completion available
Learning Outcomes
At the end of this course, you will be able to:
Improve
Discover when to use each collection type, implement them in practical PL/SQL solutions, and simplify complex data processing tasks. These techniques help improve code readability, boost performance, and support more scalable database applications.
Control
Work with application contexts and policy-based security to control exactly what data users can access, helping you meet security and compliance requirements while maintaining application performance.
Leverage
Reduce unnecessary SQL processing, use bulk operations for large datasets, and leverage compiler options and caching strategies to enhance execution performance. These skills enable you to identify bottlenecks and build faster, more efficient database applications.
Implement
Prevent SQL injection attacks using tools such as the DBMS_ASSERT package, validate user input, and implement defensive programming techniques to create reliable, resilient, and secure Oracle applications.
Course timeline
PL/SQL Performance, Collections and Secure Access
Day 1
- Learn PL/SQL performance best practices, including efficient data types, cursor design, and cursor variables.
- Create and use Oracle collections such as associative arrays, nested tables, and varrays for flexible data handling.
- Build advanced PL/SQL integrations by calling external C libraries, Java programs, and operating system routines.
- Understand application contexts and implement Fine-Grained Access Control (FGAC) to secure database access.
- Configure Oracle security policies using the DBMS_RLS package and manage row-level security.
- Gain practical experience designing high-performance and secure PL/SQL applications.
LOB Management and PL/SQL Performance Tuning
Day 2
- Work with Large Objects (LOBs), including CLOBs, BLOBs, BFILEs, and temporary LOBs.
- Configure and administer SecureFile LOBs with encryption, compression, deduplication, and storage optimization.
- Improve PL/SQL performance using compiler settings, native compilation, bulk processing, and parallel execution.
- Reduce SQL overhead by minimizing database calls and applying efficient coding techniques.
- Enhance application speed using SQL and PL/SQL caching, function result caching, and shared pool optimization.
- Monitor and optimize PL/SQL execution for greater scalability and efficiency.
Code Analysis, Profiling and Application Security
Day 3
- Analyze PL/SQL code using data dictionary views, metadata tools, PL/Scope, and compile-time warnings.
- Profile and trace PL/SQL applications with DBMS_PROFILER, hierarchical profiling, and execution tracing.
- Strengthen application security through privilege management, secure packages, and controlled object access.
- Protect applications against SQL injection using defensive coding techniques and the DBMS_ASSERT package.
- Test, validate, and harden PL/SQL code to improve security, reliability, and maintainability.
- Explore additional Oracle features such as Edition-Based Redefinition, invisible columns, and other modern PL/SQL enhancements.
Who Should Enroll in this Program?
Oracle PL/SQL developers looking to expand their programming expertise
Oracle database administrators who develop or maintain PL/SQL code
Application developers building enterprise Oracle applications
Database programmers responsible for performance optimisation
Technical consultants working with Oracle database solutions
Experienced SQL developers progressing into advanced PL/SQL development
Prerequisites
- A good understanding of Oracle SQL
- Practical experience writing PL/SQL programs
- Knowledge of procedures, functions, packages, and cursors
- Experience working with Oracle databases
Licensing
and equality policy
Licensing and accreditation
This course is offered according to Partner Program Agreement and complies with the License Agreement requirements.
Equity Policy
AVCdoes not provide accommodations due to a disability or medical condition of any students. Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.
Frequently Asked Questions
Need a Custom In-company or Group Training?
Request for in-company training program tailored specifically to your team. We offer flexible customization options to align with your business goals, alongside competitive group rates for larger teams. Fill out the form below, and our corporate training experts will design the perfect solution for you.