Oracle Database 11g: Advanced PL/SQL PLSQL-ADV

kurz

Základní info

Audience:

  • Application Developers
  • Developer
  • PL/SQL Developer

Prerequisites:

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

Objectives:

  • Tune PL/SQL code
  • Categorize and explain various types of SQL injection attacks
  • Apply coding standards to eliminate SQL injection vulnerabilities
  • Create subtypes based on existing types for an application
  • Create and use collections
  • Execute external C programs from PL/SQL
  • Execute Java programs from PL/SQL
  • Describe the process of fine-grained access control
  • Create and maintain LOB data types
  • Use the DBMS_LOB PL/SQL package to control LOBs
  • Describe SecureFile LOB features
  • Identify guidelines for cursor design
  • Enable SecureFile LOB deduplication, compression, and encryption
  • Improve memory usage by caching SQL result sets
  • Set up PL/SQL functions to use PL/SQL result caching
  • Profile PL/SQL applications

Topics:

Overview of the Development Environments

  • SQL Developer
  • SQL*Plus

Design Considerations

  • Describe the predefined data types
  • Create subtypes based on existing types for an application
  • List the different guidelines for cursor design
  • Use cursor variables
  • Pass cursor variables as program parameters
  • Compare cursor variables to static cursors

Using Collections

  • Overview of collections
  • Use Associative arrays
  • Use Nested tables
  • Use Varrays
  • Write PL/SQL programs that use collections
  • Use Collections effectively

Using Advanced Interface Methods

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

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

Manipulating Large Objects

  • Describe a LOB object
  • Manage internal LOBs
  • Describe BFILEs
  • Create and use the DIRECTORY object to access and use BFILEs
  • Describe the DBMS_LOB package
  • Remove LOBs
  • Create a temporary LOB programmatically with the DBMS_LOB package

Administering SecureFile LOBs

  • Introduction to SecureFile LOBs
  • Enable the environment for SecureFile LOBs
  • Use SecureFile LOBs to store documents
  • Convert BasicFile LOBs to SecureFile LOB format
  • Examine the performance of SecureFile LOBs
  • Enable deduplication and compression
  • Enable encryption

Tuning and Performance

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

Improving Performance with SQL and PL/SQL Caching

  • Describe result caching
  • Use SQL query result cache
  • PL/SQL function cache

Analyzing PL/SQL Code

  • Use the supplied packages and dictionary views to find coding information
  • Determine identifier types and usages with PL/Scope
  • Use the DBMS_METADATA package to obtain metadata from the data dictionary as XML or creation DDL that can be used to re-create the objects

Profiling and Tracing PL/SQL Code

  • Trace PL/SQL program execution
  • Profile PL/SQL applications

Safeguarding Your Code Against SQL Injection Attacks

  • Describe SQL injections
  • Reduce attack surfaces
  • Use DBMS_ASSERT
  • Design immune code
  • Test code for SQL injection flaws

Oracle Database 11g: Advanced PL/SQL PLSQL-ADV

Vybraný termín:

 Praha

Cena

Kontakt na dodavatele získáte po registraci

Tento kurz je pořádán dodavatelem, který nevyužívá placenou prezentaci na portálu Abravito.

Kontaktní údaje na dodavatele získáte po registraci.

Nebo použijte poptávkový formulář.