*Friday CLOSED

Timings 10.00 am - 08.00 pm

Call : 021-3498-6664, 0312-216-9325 DHA 021-35344-600, 03333808376, KSA 0502283468

Or log in to access your purchased courses
by admin
Price:  25,000  20,000
2 Months
0 Lessons

Print Friendly, PDF & Email

COURSE DESCRIPTION

1Z0-146-Oracle-Database-11g-Advanced-PLSQL

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

  • 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 SecureFile LOBs

  • Describe SecureFile LOB features
  • Enable SecureFile LOB deduplication, compression, and encryption
  • Migrate BasicFile LOBs to the SecureFile 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

Flexible Class Options

  • Evening Classes | Workshops | Fast-Track
  • Week End Classes For Professionals  SAT | SUN
  • Online Classes – Live Virtual Class (L.V.C), Online Training

International Student Fee : 250 USD | 900 AED | 900 SAR


Related Courses

Oracle Techno Functional Consultant – Oracle Apps R12

Diploma SAP ERP Complete All-in-One Course
Oracle ERP R12 Supplychain Management
R12i Oracle E Business Suite Fundamentals
Oracle E-Business Suite R12 Applications DBA
Oracle Fusion Financials Cloud – 1Z0-408


KEY FEATURES

Flexible Classes Schedule

Online Classes for out of city / country students

Oracle Certified Faculty

Weekend Classes for Professionals

98% Pass Rate

FREE Certification Practice Exam Question

Please Fill the Inquiry Form

Inquire Now

Select Country:
Enter Phone e.g 923451234567
Branch
Online

Inquire Now

Lessons

Or log in to access your purchased courses
ABOUT US

OMNI ACADEMY is one of the most prestigious Training & Consulting firm, founded in 2010, under MHSG Consulting Group aim to help our customers in transforming their people and business - be more engage with customers through digital transformation. Helping People to Get Valuable Skills and Get Jobs.

Read More

Contact Us

Get your self enrolled for unlimited learning 1000+ Courses, Corporate Group Training, Instructor led Class-Room and ONLINE learning options. Join Now!
  • Gulshan Campus : A-242, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, (Near Rab Medial) Karachi. 021 3498 6664, WhatsApp 0312 216 9325
  • Dha Campus: 14-C, Saher Commercial Area, Phase VII, Defence Housing Authority, Karachi-75500 Pakistan. 021 35344 600, 0333 3808376
  • 021 34986664, 021 35344 600, 0333 3808376, KSA 050 2283468
  • info@omni-academy.com
WORKING HOURS

  • Monday10.00am - 8.00pm
  • Tuesday10.00am - 8.00pm
  • Wednesday10.00am - 8.00pm
  • Thursday10.00am - 8.00pm
  • FridayClosed
  • Saturday10.00am - 8.00pm
  • Sunday10.00am - 8.00pm
WhatsApp chat