Gerelateerde onderwerpen:
Oracle | PL SQL | SQL | 11g


Oracle Database 11g: Advanced PL/SQL

Doelgroep | Voorkennis | Doel | Onderwerpen | Data & prijzen | Aanmelden
Deze PlusPartner cursus hebben we niet meer in ons assortiment maar nog wel andere cursussen, bijvoorbeeld:Meer informatie? Klik hier!

In this course, students learn to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface 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 to write powerful PL/SQL programs. Students also learn programming efficiency, use of external C and Java routines, fine-grained access and safeguarding code against SQL Injection attacks.This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement.Learn To: Write code to interface with external applications and the operating systemCreate PL/SQL applications that use collectionsImplement a virtual private database with fine-grained access controlWrite code to interface with large objects and use SecureFile LOBsSafeguard code against SQL injection attacksDesign PL/SQL packages and program units that execute efficiently

Doelgroep cursus Oracle Database 11g: Advanced PL/SQL

Application Developers

Voorkennis

Wij adviseren onderstaande voorkennis:

  • Oracle Database 11g: Introduction to SQL

Doel

  • Tune PL/SQL code

Onderwerpen cursus Oracle Database 11g: Advanced PL/SQL

De cursus Oracle Database 11g: Advanced PL/SQL behandelt de volgende onderwerpen:

    • Overview of the Development Environments
    • Design Considerations
    • Using Collections
    • Using Advanced Interface Methods
    • Implementing VPD with Fine-Grained Access Control
    • Manipulating Large Objects
    • Administering SecureFile LOBs
    • Tuning and Performance
    • Improving Performance with SQL and PL/SQL Caching
    • Analyzing PL/SQL Code
    • Profiling and Tracing PL/SQL Code
    • Safeguarding Your Code Against SQL Injection Attacks

    Klik hier voor een gedetailleerde onderwerpenlijst

Meer informatie?

Geïnteresseerd geraakt in deze opleiding
en wilt u weten welke (vergelijkbare) cursus(sen) u wel kunt volgen?


Vraag informatie aan



Gedetailleerde onderwerpenlijst cursus Oracle Database 11g: Advanced PL/SQL

Hieronder vind u een gedetailleerd overzicht met onderwerpen die in de cursus Oracle Database 11g: Advanced PL/SQL behandeld zullen worden:

    • 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

Getoonde informatie onder voorbehoud, genoemde prijzen zijn exclusief BTW.

Share |

 
Informatie 
  Contact
  Cursusoverzicht
  Cursuskalender
  Bel mij!
  Brochure aanvragen
  Aanmelden voor nieuwsbrief
  Stel een vraag
 
 
Cursuscategorieën