Course PL/SQL Advanced

Duration (days): 3
Price (CZK): 20000

PL/SQL Advanced topics:

• 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
• 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
• 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
• 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

All course schedules I will make suitable according your individual requirements.
If course topics are not suitable for you then contact me contact and we will come to topics meet your individual bussiness needs