Oracle Database 11g Advanced PLSQL Online Training Course
Oracle is a complete application development tool that supports operating systems, development approaches, and technology platforms. Oracle database 11g advance certification deals with the advanced characteristics of PL/SQL for building and tuning. Our professional trainers will teach you to link databases and other apps in every way that is efficient and effective.
Course Outline
Oracle11g: Advanced PL/SQL
- Introduction to PL/SQL
PL/SQL Programming Concepts: Review
- List restrictions on calling functions from SQL expressions
- Hand exceptions
- Manage dependencies
- Use Oracle-supplied packages
Designing PL/SQL Code
- Identify guidelines for cursor design
- Use cursor variables
- Create subtypes based on existing types
Working with Collections
- Create collections (nested table, array and associative arrays, PL SQL tables)
- Use collections methods
- Manipulate collections
- Distinguish between the different types of collections and their uses
Using Advanced Interface Methods
Execute external C programs from PL/SQL
Execute Java programs from PL/SQL
Implementing Fine-Grained Access Control for VPD
- Explain the process of fine-grained access control
- Implement and test fine-grained access control
Manipulating Large Objects
- Create and manage LOB data types
- Use the DBMS_LOB PL/SQL package
- Use of temporary LOBs
Administering Secure File LOBs
- Describe Secure File LOB features
- Enable Secure File LOB deduplication, compression, and encryption
- Migrate Basic File LOBs to the Secure File LOB format
Performance and Tuning
- Use native and interpreted compilation methods
- Tune PL/SQL code
- Enable intraunit inlining
Improving Performance with Caching
- Improve memory usage by caching SQL result sets and using the DBMS_RESULT_CACHE package
- Write queries that use the result cache hint
- Set up PL/SQL functions to use PL/SQL result caching
Analyzing PL/SQL Code
- Run reports on source code
- Determine identifier types and usages
- Use DBMS_METADATA to retrieve object definitions
Profiling and Tracing PL/SQL Code
- Trace PL/SQL program execution
- Profile PL/SQL applications
Safeguarding Your Code Against SQL Injection Attacks
- Describe SQL injections
- Reduce attack surfaces
- Use DBMS_ASSERT
- Design immune code
- Test code for SQL injection flaws
International Student Fee : 250 USD | 900 AED | 900 SAR
Flexible Class Options
- Corporate Group Training | Fast-Track
- Week End Classes For Professionals SAT | SUN
- Online Classes – Live Virtual Class (L.V.C), Online Training
