*Friday CLOSED

Timings 10.00 am - 08.00 pm

Call : 021-3455-6664, 0312-216-9325 DHA 021-35344-600, 03333808376, ISB 03333808376

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

Oracle DBA 11g Course

Oracle Database 11g Advanced PLSQL

In this Oracle Database 11G Advanced PL/SQL training, expert Oracle certified 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.[/vc_column_text]

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

Find Oracle DBA Jobs and Salaries (click on URL)


Oracle Job Interview Preparation



Flexible Class Options

  • Week End Classes For Professionals  SAT | SUN
  • Corporate Group Trainings Available
  • Online Classes – Live Virtual Class (L.V.C), Online Training

Recommended Courses (Advanced Certification Tracks)

Oracle Database 11g Admin-I DBA Training Course
Oracle Database 11g Admin-II DBA Training Course
Oracle Database 11g SQL Fundamentals
Oracle Database 11g Advanced PLSQL

Oracle BI 11g : OBIEE – Build Repository 
Oracle BI 11g : OBIEE – Create Analyses and Dashboards
Oracle Forms Developer Course – Build Internet Applications


[/vc_column][/vc_row]

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 & CONSULTING 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!
  • Head Office: A-2/3 Westland Trade Centre, Shahra-e-Faisal PECHS Karachi 75350 Pakistan Call 0213-455-6664 WhatsApp 0334-318-2845, 0336-7222-191, +92 312 2169325
  • Gulshan Branch: A-242, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, Karachi-75300, Call/WhatsApp 0213-498-6664, 0331-3929-217, 0334-1757-521, 0312-2169325
  • ONLINE INQUIRY: Call/WhatsApp +92 312 2169325, 0334-318-2845, Lahore 0333-3808376, Islamabad 0331-3929217, Saudi Arabia 050 2283468
  • DHA Branch: 14-C, Saher Commercial Area, Phase VII, Defence Housing Authority, Karachi-75500 Pakistan. 0213-5344600, 0337-7222-191, 0333-3808-376
  • info@omni-academy.com
  • FREE Support | WhatsApp/Chat/Call : +92 312 2169325
WORKING HOURS

  • Monday10.00am - 7.00pm
  • Tuesday10.00am - 7.00pm
  • Wednesday10.00am - 7.00pm
  • Thursday10.00am - 7.00pm
  • FridayClosed
  • Saturday10.00am - 7.00pm
  • Sunday10.00am - 7.00pm
WhatsApp Us