Oracle Database 11g: Advanced Programming with PL/SQL

Displaying courses for United States [Change]

Overview

The student will design and fine-tune PL/SQL to interface with the database and other applications using advance PL/SQL programming.

Objectives

Upon successful completion of this course, students will be able to: -
  • summarize the fundamental concepts of PL/SQL.
  • design PL/SQL code to develop procedures that are easier to use and maintain.
  • use collections to access, retrieve, and manipulate a set of similar data types.
  • use advanced interface methods.
  • implement Fine Grained Access Control to enforce security and control access to a database.
  • manipulate large objects using PL/SQL.
  • implement SecureFile LOBs.
  • compile and tune PL/SQL programs to improve performance.
  • use caching to improve performance.
  • analyze PL/SQL code.
  • profile and trace PL/SQL code.
  • identify the methods for safeguarding PL/SQL code against SQL injection attacks

Audience

IT Professional with programming experience for Oracle and experience with PL/SQL.

Syllabus

Fundamentals of PL/SQL

  • PL/SQL Development Environments
  • Listing restrictions on calling functions from SQL expressions

Designing PL/SQL Code

  • Get Started with Cursor Design
  • Use Cursor Variables
  • Create Subtypes Based on Existing Data Types

Using Collections

  • Create Collections
  • Manipulate Collections Using Collection Methods

Advanced Interface Methods

  • Execute Procedures Overview
  • Execute External C Programs from PL/SQL
  • Execute Java Programs from PL/SQL

Implementing VPD with Fine Grained Access Control

  • Overview of Fine Grained Access Control
  • Implement FGAC

Manipulating Larger Objects

  • Use LOB Data Types
  • Use DBMS_LOB PL/SQL Package
  • Use Temporary LOBs
  • Manage LOB Data Type

Implement SecureFile LOBs

  • Migrate BasicFile LOB to the SecureFile LOB Format
  • Enable SecureFile LOB Deduplication, Compression, and Encryption

Compiling and Tuning to Improve Performance

  • Use Native and Interpreted Compilation Methods
  • Tune PL/SQL Codes
  • Enable IntraUnit Inlining

Using Cache to Improve Performance

  • Describe New Result Cache Features in Oracle 11g
  • Write Queries Using Result Cache Hint
  • Set up PL/SQL Functions to Use PL/SQL Result Caching

Analyzing PL/SQL Code

  • Run Reports on Source Code
  • Use DBMS_METADATA to Retrieve Object Definitions

Profiling and Tracing PL/SQL Codes

  • Profile PL/SQL Applications
  • Trace PL/SQL Program Execution

Identifying Methods for Safeguarding PL/SQL Code Against SQL Injection Attacks

  • Describe SQL Injection
  • List Methods to Reduce the Attack Surface
  • Discuss Methods to Filter Input with DBMS_ASSERT
  • Identify Methods for Designing Code Immune to SQL Injections
  • List Methods for Testing Code for SQL Injection Flaws

Training provider

Teaching mode:
Classroom - Instructor Led
Online - Instructor Led
Duration: 3 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Java
United States
This skill has an average salary of
US$109,108
and is mentioned in
5.01%
of job ads in this area.
Oracle Database
United States
This skill has an average salary of
US$97,224
and is mentioned in
3.79%
of job ads in this area.
Database
United States
This skill has an average salary of
US$80,737
and is mentioned in
13.24%
of job ads in this area.
SQL
United States
This skill has an average salary of
US$93,559
and is mentioned in
7.16%
of job ads in this area.