Course Outline
Introduction
Complex Data Types and Collections
- Leveraging subtypes for specialized data representations.
- Implementing cursor variables and dynamic cursors for flexible data retrieval.
- Managing sets of data using associative arrays and collections.
- Executing bulk operations via
BULK COLLECTandFORALLstatements. - Effectively handling exceptions within bulk operations.
Object-Oriented Features in Oracle Databases
- Defining object types (classes) and their associated methods.
- Creating persistent collections for long-term data storage.
- Developing table functions for advanced data manipulation.
- Implementing streaming functions for real-time data processing.
- Designing custom aggregate functions to extend SQL capabilities.
Advanced Function Usage in SQL
- Invoking PL/SQL functions within SQL statements.
- Understanding constraints, purity levels, and determinism in function design.
Organizing PL/SQL Program Units
- Managing permissions and security within PL/SQL code.
- Utilizing naming contexts to prevent identifier conflicts.
Integrating PL/SQL with Other Languages
- Incorporating Java methods into PL/SQL programs.
- Linking C language procedures for performance-critical operations.
- Employing native compilation techniques to enhance execution speed.
Pre-built Solutions and Security Mechanisms
- Creating application contexts for session-specific information.
- Implementing Virtual Private Database (VPD) for fine-grained access control.
- Managing user sessions and contexts effectively.
- Profiling and tracing PL/SQL code to identify performance bottlenecks.
Optimizing PL/SQL Code Performance
- Utilizing bind variables in SQL statements to enhance execution plans.
- Understanding cursor sharing and its impact on performance.
- Applying query optimization techniques for efficient data retrieval.
- Configuring compilation settings for optimal performance.
- Implementing caching strategies for functions and query results.
Preventing SQL Injection Attacks
- Adopting best practices to safeguard PL/SQL code against injection vulnerabilities.
Summary and Next Steps
Requirements
- Proficiency in SQL and familiarity with the Oracle database environment.
- A solid understanding of basic PL/SQL concepts along with experience in writing PL/SQL code.
Audience
- Developers.
- PL/SQL practitioners.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 4800 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (3)
he explained very well, and gave guidance on the exercises.
Stoyan - OPEN COURSE
Course - Oracle Database 19c PL and Advanced SQL
I liked the hands-on experience and the opportunity to work on actual coding activities
Kristine - Isuzu Philippines Corporation
Course - ORACLE PL/SQL Fundamentals
The PL/SQL session basics. I used PL/SQL but never got the basics of it and this course helped me a lot understand PL/SQL queries.
