Oracle Database 12c: Advanced PL/SQL Training (12c-DB-ADV-PLSQL)
Oracle Database 12c: Advanced PL/SQL Training Course Description
This Oracle Database 12c: Advanced PL/SQL Training course teaches you how to use the advanced features of PL/SQL to design and tune PL/SQL to interface with the database and other applications. Expert Oracle University instructors will help you explore advanced features of program design, packages, cursors, extended interface methods and collections.
Write powerful PL/SQL programs.
Explore programming efficiency.
Use external C and Java routines.
Apply PL/SQL designing best practices.
Create PL/SQL applications that use collections.
Implement a virtual private database with fine-grained access control.
Write code to interface with external C and Java applications.
Write code to interface with large objects and use SecureFile LOBs.
Write and tune PL/SQL code effectively to maximize performance.
With onsite Training, courses can be scheduled on a date that is convenient for you, and because they can be scheduled at your location, you don’t incur travel costs and students won’t be away from home. Onsite classes can also be tailored to meet your needs. You might shorten a 5-day class into a 3-day class, or combine portions of several related courses into a single course, or have the instructor vary the emphasis of topics depending on your staff’s and site’s requirements.
Duration: 3 days
Basic Knowledge of SQL, PL/SQL
Familiarity with programming languages
Design PL/SQL packages and program units that execute efficiently
Write code to interface with external applications and the operating system
Create PL/SQL applications that use collections
Write and tune PL/SQL code effectively to maximize performance
Implement a virtual private database with fine-grained access control
Write code to interface with large objects and use SecureFile LOBs
Describe the development environments
Identify the tables, data, and tools used in this course
PL/SQL Programming Concepts: Review
Identify PL/SQL block structure
Packages, procedures and functions
Designing PL/SQL Code
Describe the predefined data types
Create subtypes based on existing types for an application
List the different guidelines for cursor design
Describe cursor variables
Overview of Collections
Overview of collections
Use Associative arrays
Navigate using associative methods
Use Nested tables
Compare nested tables and varrays
Write PL/SQL programs that use collections
Use Collections effectively
Enhancements to PL/SQL Type Binds
Manipulating Large Objects
Working with LOBs
Overview of SecureFile LOBs
Using Advanced Interface Methods
Calling External Procedures from PL/SQL
Benefits of External Procedures
Understand how an external routine is called from PL/SQL
C advanced interface methods
Java advanced interface methods
Performance and Tuning
Understand and influence the compiler
Tune PL/SQL code
Enable intra unit inlining
Identify and tune memory issues
Recognize network issues
Improving Performance with Caching
Describe result caching
Use SQL query result cache
Use PL/SQL function cache
Review PL/SQL function cache considerations
Analyzing PL/SQL Code
Finding Coding Information
Profiling and Tracing PL/SQL Code
Tracing PL/SQL Execution
Tracing PL/SQL: Steps
12:Implementing VPD with Fine-Grained Access Control
Understand how fine-grained access control works overall
Describe the features of fine-grained access control
Describe an application context
Create an application context
Set an application context
List the DBMS_RLS procedures
Implement a policy
Query the dictionary views holding information on fine-grained access
Safeguarding Your Code Against SQL Injection Attacks
SQL Injection Overview
Reducing the Attack Surface
Filtering Input with DBMS_ASSERT
Request More Information