Oracle Database 11g: Advanced PL / SQL

You are going to learn:

In this course, students learn how to use an advanced PL / SQL in order to design and put an PL / SQL to interact with the database and other applications in the most efficient manner. Using advanced features of program design, packages, cursors, extended interface methods, large objects, and collections, students learn a powerful Software Write PL / SQL. Students also learn the programming efficiency, use of external C and Java routines, fine-grained access access and safeguarding code against SQL injection attacks. This course m account the requirement of paragraph 11g Workshop for the Certification Administrator Oracle Database. Only INCLASS led by instructor UN or online formats as directed by the UN instructor of this course will meet the Certification Hands On Requirements. Self-study courses on CD-Rom and Knowledge Center of Practical no meet the requirement.

Learn

Write code to interface with external applications and the operating system Create collections applications using PL / SQL Implement a virtual private database access control air-grained Write code to interface with large objects and use SecureFile LOB How Safeguard code against SQL injection attacks Design PL / SQL and dependencies program running efficiently

Audience

• Applications Developers
• Developer
• PL / SQL Developer

Prerequisites:

Suggested Prerequisites:

• Experience with SQL and PL / SQL required
• Familiarity with Oracle database
• Oracle Database 11g: Introduction to SQL
• Oracle Database 11g: Program with PL / SQL

Course Objectives:

• Tune PL / SQL code
• categorize and explain the different types of SQL injection attacks
• Apply coding standards to eliminate SQL injection vulnerabilities
• Create sub Based on the existing type of application &
• Create and USO Collections
• Run External Programs C PL / SQL
• Run Java programs from PL / SQL
• Describe the process of fine-grained access control
• Create and maintain LOB data type
• Use the package DBMS_LOB PL / SQL LOB Handle
• Describe the characteristics SecureFile LOB
• Identify guidelines for cursor design
• Enable SecureFile LOB deduplication, compression and encryption
• Improve caching SQL result sets
• Configure Functions PL / SQL Using PL paragraph output cache / SQL
• Profile Applications PL / SQL

Course Content:

Overview of Development Environments

• SQL Developer
• SQL * Plus

Design Considerations

• Describe the predefined data type
• Create sub Based on the existing type of application &
• Various enumerate Guidelines for designing cursor
• Use the cursor variables
• Move the cursor variables How the Program Settings
• Compare cursor variables of static cursors

Using Collections

• Information Collections
• Using associative arrays
• Use nested tables
• Varrays use
• Write programs PL / SQL collections use
• Use Collections effectively

Using Advanced Interface Methods

• Calling C from PL / SQL
• Call December Java PL / SQL

The implementation of VPD control Access grained

• To understand how access control works fine-grained access generally
• Describe the functions grained access control
• Describe the UN context Application
• Create Application UN context
• Establish UN context Application
• list the procedures DBMS_RLS
• Implement a policy
• Consult the dictionary views holding information about the access grained access

Large object manipulation

• Describe the UN Object LOB
• Manage Internal LOB
• describe BFILEs
• Creating and Using the Object Directory Access and BFILEs Using
• Describe the DBMS_LOB package
• Remove the LOB
• Create a temporary LOB UN programmatically package DBMS_LOB

Administrators SecureFile LOB

• Introduction to SecureFile LOB
• Enabling Environment for SecureFile LOB
• Use SecureFile LOB paragraph Storing Documents
• Convert format BasicFile SecureFile LOB LOB
• · examine the performance of SecureFile LOB
• Enable deduplication and compression
• Enable encryption

uls and performance tuning

• Understand and influence the compiler
• Tune PL / SQL code
• Enable: intra unit inlining now
• Identify and tune memory issues

Improving Performance with SQL and PL / SQL Caching

• Describe cache results
• Cache Query Results Using SQL
• cache function f PL / SQL

Analysis of PL / SQL code

• The United States supplied packages and dictionary views of paragraph Find out encoding
• Determine the type and usage identifiers with PL / Scope
• Use the package DBMS_METADATA Get metadata dictionary data as XML or creation DDL that can be used to re-create how the objects

Profiling and Tracing PL / SQL code

• Draw the Programme Implementation PL / SQL
• Profile Applications PL / SQL

Safeguarding attacks of SQL injection contraindicated

• Describe SQL injections
• Reduce areas of attack
• DBMS_ASSERT use
• Design code Immune
• Test code for SQL injection errors