Školení PL/SQL Advanced

Délka: 3 dny
Cena: 20000 Kč

Kurz PL/SQL Advanced osnova:

Identify PL/SQL block structure
Create procedures
Create functions
Create packages
Use cursors
Handle exceptions
Understand dependencies
Identify the Oracle supplied packages
List the different guidelines for cursor design
Describe cursor variables
Pass cursor variables as program parameters
Compare cursor variables to static cursors
Describe the predefined data types
Create subtypes based on existing types for an application
Describe and use nested tables
Describe and use varrays
Describe and use associative arrays
Describe and use string indexed collections
Describe and use nested collections
Write PL/SQL programs that use collections
Describe the common collection exceptions and how to code for them
Compare associative arrays to collections
Execute external C routines from PL/SQL
Understand the benefits of external routines
Publish the external C routine in the PL/SQL code
Execute a PL/SQL routine that calls the external C routine
Execute Java routines from PL/SQL
Publish the Java class method by creating the PL/SQL subprogram unit specification that references the Java class method
Execute the PL/SQL subprogram that invokes the Java class method
Define embedding PL/SQL code in Web pages (PL/SQL Server Pages)
Describe the format of a PL/SQL Server Page
Write the code and content for the PL/SQL Server Page
Load the PL/SQL Server Page into the database as a stored procedure
Run a PL/SQL Server Page via a URL
Debug PL/SQL Server Page problems
Understand how fine-grained access control works overall
Describe the features of fine-grained access control
Describe an application context
Set up a logon trigger
View the results
Query the dictionary views holding information on fine-grained access
Tune PL/SQL code
Write smaller executable sections of code
Compare SQL to PL/SQL on performance
Understand how bulk binds can improve performance
Handle exceptions with the FORALL syntax
Identify data type and constraint issues
Recognize network issues
Use the supplied packages and dictionary views to find coding information
dbms_describe supplied package
Use supplied packages to find error information
Trace PL/SQL programs using the dbms_trace supplied packageq
Read and interpret the trace information
Profile PL/SQL programs using the dbms_profiler supplied package
Read and interpret the profiler information

Termíny všech kurzů přizpůsobím Vašim individuálním požadavkům.
Pokud Vám nebude vyhovovat osnova nebo délka daného kurzu, kontaktujte mě kontakt a domluvíme se na osnově, která bude zohledňovat Vaše požadavky.