*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

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

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

Related Courses

Oracle Database 11g Data Guard Release 2

Oracle DBA 11g Performance Tunning Course

KEY FEATURES

Flexible Classes Schedule

Online Classes for out of city / country students

AMAZING Discount OFFER

Weekend Classes for Professionals

Internship Opportunity

*Installment Fee Payment available for deserving students

Inquire Now

Inquiry
First Name
Last Name*
Email*
Company
Phone*
Comments

Lessons

Or log in to access your purchased courses
ABOUT US

OMNI ACADEMY is one of the most prestigious Training, Consulting & Digital Marketing firm, founded in 2010, under MHSG Consulting Group aim to help our customers in promoting brands, build preference, more engage with customers and increase sales through digital transformation. We are helping People to Get Valuable Skills and Get Jobs.

Read More

Contact Us

Get your self enrolled for unlimited learning 500+ 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.
  • Dha Campus: 14-C, Saher Commercial Area, Phase VII, Defence Housing Authority, Karachi-75500 Pakistan. 02135344600 , +966 54 789 9214
  • 021 3498 6664(OMNI), 033 77 222 191, 0312 2169 325
  • 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