Oracle Database: Advanced PL/SQL | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

Oracle Database: Advanced PL/SQL

Location

Format What’s this?
Starting From
RM 4500.00
  1. 3 Day with 08 hours per day
  1. Tue 25 Oct 09:00 - Thu 27 Oct 17:00
  1. HRDF SBL Claimable
  2. Certificate of Attendance available
  1. 3 Days
  1. All of our private classes are customized to your organization's needs.
  2. Click on the button below to send us your details and you will be contacted shortly.
Request more information

Inquiry for: Myself    My Company

By providing your contact details, you agree to our Privacy Policy

 

 

 

Thank You

Our learning consultant will get back to you in 1 business day

Oracle Database: Advanced PL/SQL

WHAT YOU WILL LEARN

This Oracle Database 12c: Advanced PL/SQL training teaches you how to use the advanced features of PL/SQL to design and tune PL/SQL to interface with the database and other applications. Expert Oracle University instructors will help you explore advanced features of program design, packages, cursors, extended interface methods and collections.

Learn To:

  • Write powerful PL/SQL programs.
  • Explore programming efficiency.
  • Use external C and Java routines.
  • Apply PL/SQL designing best practices.
  • Create PL/SQL applications that use collections.
  • Implement a virtual private database with fine-grained access control.
  • Write code to interface with external C and Java applications.
  • Write code to interface with large objects and use SecureFile LOBs.
  • Write and tune PL/SQL code effectively to maximize performance.

BENEFITS

Discover how to write PL/SQL routines that analyze the PL/SQL applications and caching techniques that can improve performance. By investing in this course, you'll be introduced to the Virtual Private Database(VPD) to implement security policies and explore techniques and tools to strengthen your applications against SQL injection attacks. Expand programming resources by creating PL/SQL programs that interface with C and Java code.

AUDIENCE

  • Application Developers
  • Database Administrators


METHODOLOGY

This program will be conducted with interactive lectures, PowerPoint presentations, discussions and practical exercises

PREREQUISITES

  • Basic Knowledge of SQL, PL/SQL
  • Familiarity with programming languages
  • Oracle Database: Develop PL/SQL Program Units NEW
  • Oracle Database: SQL Workshop I NEW

COURSE OBJECTIVES

Upon completion of this program, participants should be able to:

  • 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

Expand All

Modules

Module 1 – Introduction
  • Course Objectives
  • Course Agenda
  • Describe the development environments
  • Identify the tables, data, and tools used in this course

Module 2 - PL/SQL Programming Concepts
  • Identify PL/SQL block structure
  • Packages, procedures and functions
  • Cursors
  • Handle exceptions
  • Dependencies
Module 3 - Designing PL/SQL Code
  • Describe the predefined data types
  • Create subtypes based on existing types for an application
  • List the different guidelines for cursor design
  • Describe cursor variables
  • White List

Module 4 - Overview of Collections
  • Overview of collections
  • Use Associative arrays
  • Navigate using associative methods
  • Use Nested tables
  • Use Varrays
  • Compare nested tables and varrays
Module 5 - Using Collections
  • Write PL/SQL programs that use collections
  • Use Collections Effectively
  • Module 6 - Manipulating Large Objects
  • Working with LOBs
  • Overview of SecureFile LOBs
Module 6 - Using Advanced Interface Methods
  • Calling External Procedures from PL/SQL
  • Benefits of External Procedures
  • Understand how an external routine is called from PL/SQL
  • C advanced interface methods
  • Java advanced interface methods

Module 7 - Performance and Tuning
  • Benefits of External Procedures
  • Understand how an external routine is called from PL/SQL
  • C advanced interface methods
  • Java advanced interface methods
Module 8 - Improving Performance with Caching
  • Describe result caching
  • Use SQL query result cache
  • Use PL/SQL function cache
  • Review PL/SQL function cache considerations
Module 9 - Analyzing PL/SQL Code
  • Finding Coding Information
  • PL/Scope Concepts
  • DBMS_METADATA Package
  • PL/SQL Enhancements
Module 10 - Profiling and Tracing PL/SQL Code
  • Tracing PL/SQL Execution
  • Tracing PL/SQL: Steps

Module 11: Implementing VPD with Fine-Grained Access Control
  • Understand how fine-grained access control works overall
  • Describe the features of fine-grained access control
  • Describe an application context
  • Create an application context
  • Set an application context
  • List the DBMS_RLS procedures
  • Implement a policy
  • Query the dictionary views holding information on fine-grained access
Module 12 - Safeguarding Your Code Against
  • SQL Injection Attacks
  • SQL Injection Overview
  • Reducing the Attack Surface
  • Filtering Input with DBMS_ASSERT

Oracle Certified Trainer

Oracle Certified Trainer

Read More

Genesis Douglas Row

Genesis Douglas Row

Mr. Genesis Douglas Row has been working in the IT industry since 1996 and has contributed more than 17 years to the industry. Along the years, he has picked up skills in sales, marketing, business management, presales and product management that has made him an all-rounded skilled and experienced IT personnel in the industry.He has a strong technical background in Oracle Database Management, Solaris System Administration and Web Publishing. He has also proven to be a very talented and passionate trainer in delivering easy-to-understand, straight-to-the-point training sessions. He utilizes effective training techniques for maximum knowledge transfer, information retention and customer satisfaction. Read More

Course Reviews

No Remarks

0

0 Ratings