Oracle Database 11g: Advanced PL/SQL

Private ptm-Akademie GmbH
In Bremen, Dresden und Jena

1.770 
zzgl. MwSt.
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
0911/... Mehr ansehen
Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen

Wichtige informationen

Beschreibung

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. Also learn programming efficiency, ..
Gerichtet an: Entwickler. PL/SQL-Entwickler

Wichtige informationen
Veranstaltungsort(e)

Wo und wann

Beginn Lage
auf Anfrage
Bremen
Bremen, Deutschland
auf Anfrage
Dresden
Sachsen, Deutschland
auf Anfrage
Jena
Löbdergraben 28, 07743, Thüringen, Deutschland
Plan ansehen

Häufig gestellte Fragen

· Voraussetzungen


Professioneller Einstieg in Oracle Database 11g SQL

Oracle Database 11g: Program with PL/SQL

Empfohlene Vorkenntnisse:

Experience with SQL and PL/SQL required

Familiarity with the Oracle Database

Themenkreis

Beschreibung

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. Also learn programming efficiency, use of external C and Java routines, fine-grained access and safeguarding your code against SQL Injection attacks.

Zielgruppe

Entwickler

PL/SQL-Entwickler

Voraussetzungen

Professioneller Einstieg in Oracle Database 11g SQL

Oracle Database 11g: Program with PL/SQL

Empfohlene Vorkenntnisse:

Experience with SQL and PL/SQL required

Familiarity with the Oracle Database

Kursinhalte

    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



Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen