Read more
2Month/20 Hours Price:25,000
20,000
Oracle Database 11g Advanced PLSQL
In this Oracle Database 11G Advanced PL/SQL training, expert Oracle University instructors will help you explore the advanced features of PL/SQL to design and tune PL/SQL. You’ll learn how it interfaces with the database and other applications in the most efficient manner.
Oracle11g: Advanced 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
Use the DBMS_LOB PL/SQL package
Use of temporary LOBs
Administering SecureFile LOBs
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
Job Interview Preparation (Soft Skills Questions & Answers)
Tough Open-Ended Job Interview QuestionsWhat to Wear for Best Job Interview Attire
Job Interview Question- What are You Passionate About?
How to Prepare for a Job Promotion Interview
Stay connected even when you’re apart
Join our WhatsApp Channel – Get discount offers
500+ Free Certification Exam Practice Question and Answers
Your FREE eLEARNING Courses (Click Here)
Internships, Freelance and Full-Time Work opportunities
Join Internships and Referral Program (click for details)
Work as Freelancer or Full-Time Employee (click for details)
Flexible Class Options
Week End Classes For Professionals SAT | SUN
Corporate Group Trainings Available
Online Classes – Live Virtual Class (L.V.C), Online Training
0 Reviews