Oracle Database 19c- Advanced PL-SQL


Request for price


Length: 3.0 day (24 hours)

 

This course is designed for experienced PL/SQL programmers who want to take their skills to the next level. It delves into advanced PL/SQL concepts and techniques, empowering learners to write efficient, robust, and secure database applications.

  • Database developers
  • Database administrators
  • Application developers
  • Anyone with a solid foundation in PL/SQL who wants to enhance their skills
  • Strong understanding of SQL and basic PL/SQL concepts
  • Familiarity with Oracle Database 19c
  • Experience with programming languages

Start with the customer – find out what they want and give it to them.

Course objectivesCourse outlines

Course objectives

After completing this course, students will be able to:

    • Design and implement complex PL/SQL programs
    • Optimize PL/SQL code for performance
    • Utilize advanced PL/SQL features like collections, object types, and bulk collect
    • Handle exceptions and errors effectively
    • Interface with external applications using PL/SQL
    • Secure PL/SQL code
    • Tune PL/SQL applications for optimal performance

Course outlines

  • Module 1: Advanced PL/SQL Concepts
    • Review of PL/SQL fundamentals
    • Advanced data types: object types, collections, and VARRAYs
    • PL/SQL tables and nested tables
    • Bulk collect and FORALL statements
    • Dynamic SQL
    • Autonomous transactions
  • Module 2: PL/SQL Packages
    • Package specifications and bodies
    • Package variables and constants
    • Package procedures and functions
    • Package triggers
    • Package-level exceptions
  • Module 3: PL/SQL Performance Tuning
    • SQL tuning within PL/SQL
    • PL/SQL performance analysis tools
    • Optimizing cursor performance
    • Bulk collect and FORALL for performance improvements
    • Indexing for PL/SQL queries
  • Module 4: PL/SQL Security
    • Securing PL/SQL code with object privileges
    • Protecting sensitive data with encryption and masking
    • Auditing PL/SQL activity
    • Preventing SQL injection attacks
  • Module 5: PL/SQL and External Interfaces
    • Calling external procedures and functions
    • Using Java stored procedures
    • Interfacing with web services
    • Working with large objects (LOBs)
  • Module 6: PL/SQL and Advanced Database Features
    • Using advanced SQL features within PL/SQL
    • Implementing triggers for complex event handling
    • Working with XML and JSON data
    • Leveraging Oracle Database features like partitioning and compression

​

Download outlines