Oracle Advanced PL/SQL
Course
In London
Description
-
Type
Course
-
Location
London
This course is designed for Oracle database administrators and software development personnel who need to gain practical experience of the advanced features of PL/SQL such as program design, packages, cursors, large objects and collections.
Facilities
Location
Start date
Start date
Reviews
Subjects
- IT
- PL/SQL
- SQL
Course programme
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
- Oracle Predefined Data Types
- Create Subtypes Based on Existing Types for an Application
- Guidelines for Cursor Design
- Use Cursor Variables
- Pass Cursor Variables as Program Parameters
- Compare Cursor Variables to Static Cursors
- Overview of Collections
- Associative Arrays
- Nested Tables
- Varrays
- Create PL/SQL Programs that use Collections
- Use Collections Effectively
- The Benefits of External Routines
- External Routine Components
- Call an OS Supplied DLL
- Call Java from PL/SQL
- Call C from PL/SQL
- Call Java from PL/SQL
- Overview of Fine-Grained Access Control
- The Features of Fine-Grained Access Control
- Overview of an Application Context
- Create an Application Context
- Set an Application Context
- Describe the Package DBMS_RLS
- Implement a Policy
- Query the Data Dictionary for Fine-Grained Access Control
- Information
- Overview of a LOB Object
- Manage Internal LOBs
- Character Large Objects
- Binary Large Objects
- External Large Objects - BFILEs
- Create and Use the DIRECTORY Object to Access and Use BFILEs
- The DBMS_LOB Package
- Delete LOBs
- Create a Temporary LOB using the Package DBMS_LOB
- Overview of SecureFile LOBs
- Configure the Environment for SecureFile LOBs
- Store Documents using SecureFile LOBs
- Convert BasicFile LOBS to SecureFile LOBs
- Evaluate the Performance of SecureFile LOBs
- Establish Space Utilization of a LOB File
- Set up Encryption
- Enable Compression and Deduplication
- Understand the PL/SQLCompiler
- Influence the Compiler
- Tuning PL/SQL Programs
- The DBMS_UTILITY.GET_TIME Function
- Tuning SQL
- Reducing the Number of SQL Calls
- PL/SQL Tuning
- PL/SQL Native Compilation
- The Importance of the Shared Pool
- Library Cache
- The Data Dictionary Cache
- Pinning Code in the Shared Pool
- SQL and PL/SQL Caching
- PL/SQL Function Cache
- Use Data Dictionary Views to View Coding Information
- Use Supplied Packages to View Coding Information
- Use the DBMS_METADATA Package to View Metadata as XML
- Use the DBMS_METADATA Package to Create DDL that can be used to Re-create Objects
- Determine Identifier Types and Usages with PL/Scope
- Trace PL/SQL Program Execution
- Profile PL/SQL Applications
- Access the Trace Data
- DBMS_PROFILER
- Overview of SQL Injections
- Detecting Attacks
- Review of Dynamic SQL
- The Attack Surface
- Typical SQL Attacks
- Reduce Attack Surfaces
- Use the DBMS_ASSERT Package
- Design Immune Code
- Test Code for SQL Injection Flaws
Oracle Advanced PL/SQL