Oracle Database 11G Advanced PL/SQL Course

Oracle Database 11g: Advanced PL/SQL Training

This Oracle Database 11G Advanced PL/SQL training teaches you to use advanced features of PL/SQL. Learn to write powerful PL/SQL programs, while designing and tuning PL/SQL to interface with the database and other applications as efficiently as possible.

80% of Global Fortune 500 organizations are expected to adopt DevOps by 2021 – CA.

ADP, BBC News, ebay, GE, ING, Intuit, PayPal, Splunk, Uber & other MNCs worldwide use DevOps.

Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Oracle Database11g Advanced UpComing Batches

Nov-29 - Jan-10

Weekend
SOLD OUT

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Nov-22 - Jan-03

Weekday
SOLD OUT

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Dec-11 - Jan-22

Weekend
FILLING FAST

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Dec-18 - Jan-29

Weekday
FILLING FAST

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Dec-25 - Feb-05

Weekend

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Jan-01 - Feb-12

Weekday

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now
Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Course Curriculum

Oracle Database 11g: Advanced PL/SQL

SELF PACED

This Oracle Database 11G Advanced PL/SQL training teaches you to use advanced features of PL/SQL. Learn to write powerful PL/SQL programs, while designing and tuning PL/SQL to interface with the database and other applications as efficiently as possible.

  • WEEK 5-6
  • 10 Modules
  • 6 Hours
Course Content

Topics:
  • Course Objectives.
  • Overview of the Development Environments: SQL Developer, SQL Plus.
  • Tables and Data Used for this Course.
  • Course Agenda.

Topics:
  • Review of Implicit and Explicit Cursors.
  • Identify PL/SQL Block Structure.
  • List Restrictions and Guidelines on Calling Functions from SQL Expressions.
  • Create Functions.
  • Identify the Oracle Supplied Packages.
  • Create Procedures.
  • Create Packages.
  • List Exception Syntax.

Topics:
  • Describe the Predefined Data Types.
  • List the Different Guidelines for Cursor Design.
  • Cursor Variables.
  • Create Subtypes based on Existing Types for an Application.


Topics:
  • Use VARRAYs.
  • Use Nested Tables.
  • Compare Nested Tables and VARRAYs.
  • Overview of Collections.
  • Use Associative Arrays.
  • Use Collections Effectively.
  • Write PL/SQL Programs that use Collections.


Topics:
  • Convert BasicFile LOBs to SecureFile LOB Format.
  • Use SecureFile LOBs to Store Documents.
  • Introduction to Secure File LOBs.
  • Create a Temporary LOB Programmatically with the DBMS_LOB Package.
  • Use DBMS_LOB.READ and DBMS_LOB.WRITE to Manipulate LOBs.
  • Describe a LOB Object.
  • Use BFILEs.
  • Enable Reduplication and Compression.


Topics:
  • Benefits of External Procedures.
  • Java Advanced Interface Methods.
  • Calling External Procedures from PL/SQL.
  • C Advanced Interface Methods.


Topics:
  • Enable Intra Unit Inlining.
  • Recognize Network Issues.
  • Tune PL/SQL Code.
  • Identify and Tune Memory Issues.
  • Understand and Influence the Compiler.


Topics:
  • Describe Result Caching.
  • Review PL/SQL Function Cache Considerations.
  • PL/SQL Function Cache.
  • Use SQL Query Result Cache.


Topics:
  • The USER/ALL/DBA_IDENTIFIERS Catalog View.
  • Using ALL_ARGUMENTS.
  • Using DBMS_DESCRIBE.
  • Collecting PL/Scope Data.
  • DBMS_METADATA Package.
  • Using DBMS_UTILITY.FORMAT_CALL_STACK.
  • Finding Coding Information.


Topics:
  • Tracing PL/SQL Steps.
  • Tracing PL/SQL Execution.


Topics:
  • Query the Dictionary Views Holding Information on Fine-grained Access.
  • Set an Application Context.
  • Implement a Policy.
  • Understand how Fine-grained Access Control Works Overall.
  • Describe an Application Context.
  • List the DBMS_RLS Procedures.
  • Create an Application Context.
  • Describe the Features of Fine-grained Access Control.


Topics:
  • Using Bind Arguments.
  • Testing Code for SQL Injection Flaws.
  • Reducing the Attack Surface.
  • SQL Injection Overview.
  • Designing Code Immune to SQL Injections.
  • Avoiding Dynamic SQL.
  • Filtering Input with DBMS_ASSERT.

Program Syllabus

Curriculum

You can also view the program syllabus by downloading this program Curriculum.

Course Description

Course Certification

OL Tech Edu’s Certificate Holders work at top 500s of companies like

certificate

Features

Explore step by step paths to get started on your journey to Jobs of Today and Tomorrow.

Instructor-led Sessions

30 Hours of Online Live Instructor-Led Classes.
Weekend Class : 10 sessions of 3 hours each.

Real Life Case Studies

Real-life Case Studies

Live project based on any of the selected use cases, involving implementation of the various real life solutions / services.

Assignments

Assignments

Each class will be followed by practical assignments.

24 x 7 Expert Support

24 x 7 Expert Support

We have 24x7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.

Certification

Certification

Towards the end of the course, OL Tech Edu certifies you for the course you had enrolled for based on the project you submit.

Course FAQ's

Enroll, Learn, Grow, Repeat! Get ready to achieve your learning goals with OL Tech Edu View All Courses

© 2015 - 2021 OL Tech Edu. All Rights Reserved.
Designed, Developed & Powered by MNJ SOFTWARE

The website is best experienced on the following version (or higher) of Chrome 31, Firefox 26, Safari 6 and Internet Explorer 9 browsers