In this course, students learn to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner. Using advanced features of program design, packages, cursors, extended interface methods, large objects, and collections, students learn to write powerful PL/SQL programs. Also learn programming efficiency, use of external C and Java routines, fine-grained access and safeguarding your code against SQL Injection attacks.
Learn To:
Write code to interface with external applications and the operating system
Create PL/SQL applications that use collections
Implement a virtual private database with fine-grained access control
Write code to interface with large objects and use SecureFile LOBs
Safeguard code against SQL injection attacks
Design PL/SQL packages and program units that execute efficiently
Skills Gained
Tune PL/SQL code
Categorize and explain various types of SQL injection attacks
Apply coding standards to eliminate SQL injection vulnerabilities
Create subtypes based on existing types for an application
Create and use collections
Execute external C programs from PL/SQL
Execute Java programs from PL/SQL
Describe the process of fine-grained access control
Create and maintain LOB data types
Use the DBMS_LOB PL/SQL package to control LOBs
Describe SecureFile LOB features
Identify guidelines for cursor design
Enable SecureFile LOB deduplication, compression, and encryption
Improve memory usage by caching SQL result sets
Set up PL/SQL functions to use PL/SQL result caching
Profile PL/SQL applications
Who Can Benefit
Application Developers
Developer
PL/SQL Developer
Prerequisites
Experience with SQL and PL/SQL required
Familiarity with the Oracle Database
Oracle Database 11g: Introduction to SQL
Oracle Database 11g: Program with PL/SQL
Code:
11gDB-PL-SQL
Length:
3 days
Type:
Instructor-Led
Certified By:
Oracle
Tuition:
$1,800
This course is taught by Certified Oracle instructors. There is a difference. Learn More
This course is in the following categories. Click the categories to find similar courses and topics of interest.
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below. We can also contact you when the course is scheduled in your area.
Overview of the Development Environments
SQL Developer
SQL*Plus
Design Considerations
Describe the predefined data types
Create subtypes based on existing types for an application
List the different guidelines for cursor design
Use cursor variables
Pass cursor variables as program parameters
Compare cursor variables to static cursors
Using Collections
Overview of collections
Use Associative arrays
Use Nested tables
Use Varrays
Write PL/SQL programs that use collections
Use Collections effectively
Using Advanced Interface Methods
Calling C from PL/SQL
Calling Java from PL/SQL
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
Manipulating Large Objects
When you take a certified course with ExitCertified, you are learning from
the creators of the products you use. Our commitment to your IT
community, along with our authorization to deliver certified courses,
ensures you receive a premium training experience.
