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-17 - Dec-29

Weekend
SOLD OUT

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

350.00     Enroll Now

Nov-10 - Dec-22

Weekday
SOLD OUT

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

350.00     Enroll Now

Nov-23 - Jan-04

Weekend
FILLING FAST

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

350.00     Enroll Now

Nov-30 - Jan-11

Weekday
FILLING FAST

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

350.00     Enroll Now

Dec-07 - Jan-18

Weekend

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

350.00     Enroll Now

Dec-14 - Jan-25

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

DOWNLOAD BROCHURE

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.

Curriculum

Course Description

About The Course
What is Oracle Database 11g: Advanced PL/SQL Certification Training about? 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.
Extend the functionality of the SQL language with PL/SQL language to write application code. This will help your organization realize the full benefit of utilizing Oracle best practices.
You'll also be introduced to Virtual Private Database (VPD) to implement security policies. Learn techniques and tools to strengthen applications against SQL injection attacks. Explore programming efficiency, use of external C and Java routines, PL/SQL server pages and fine-grained access.
Objectives Of Our Online PySpark Training Course
What are the objectives of Oracle Database 11g: Advanced PL/SQL Certification Training ?
  • Design PL/SQL packages and program units that execute efficiently.
  • Write code to interface with external applications and the operating system.
  • Create PL/SQL applications that use collections.
  • Write and tune PL/SQL code effectively to maximize performance.
  • Implement a virtual private database with fine-grained access control.
  • Write code to interface with large objects and use SecureFile LOBs.
Go For Online Spark Training
Who is Oracle Database 11g: Advanced PL/SQL Certification Training for?
  • Application Developers.
  • Database Administrators.
  • PL/SQL Developer.
Learning With Our PySpark Certification Training
What are the prerequisites for Oracle Database 11g: Advanced PL/SQL Certification Training? Suggested Prerequisite:- PL/SQL Programming Experience and Knowledge of SQL .

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
Top Courses
Stands by you all the way to ensure that you achieve your learning goals.

Top Courses

Partner Courses

Certifications

HELP & SUPPORT

Connect With Us

Get In Touch     Address: 5th Floor(Tower B), A-40, Ithum Tower Sector - 62, Noida Uttar Pradesh   Phone: +91-9654136060   Email: info@oltechedu.com  

© 2015 - 2024 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