Oracle Database 10g Advanced PL/SQL

Day 1

  • Lesson 1 : PL/SQL Programming Concepts Review
  • Lesson 2 : Design Considerations
  • Lesson 3 : Collections
  • Lesson 4 : Advanced Interface Methods

Day 2

  • Lesson 5 : PL/SQL Server Pages
  • Lesson 6 : Fine-Grained Access Control
  • Lesson 7 : Performance and Tuning
  • Lesson 8 : Analyzing PL/SQL Code

Lesson 1 : PL/SQL Programming Concepts Review

  • Identify PL/SQL block structure
  • Describe PL/SQL basics
  • List restrictions and guidelines on calling functions from SQL expressions
  • Identify how explicit cursors are processed
  • Handle exceptions
  • Use the raise_application_error procedure
  • Manage dependencies

Lesson 2 : Design Considerations

  • Identify guidelines for cursor design
  • Use cursor variables
  • Create subtypes based on existing types for an application

Lesson 3 : Collections

  • Describe an object type
  • Create an object type specification
  • Implement the constructor method on objects
  • Create collections
    • Nested table collections, varray collections
    • Associative arrays, string indexed collections
  • Use collections methods
  • Manipulate collections
  • Distinguish between the different types of collections and when to use them

Lesson 4 : Advanced Interface Methods

  • Execute external C programs from PL/SQL
  • Execute Java programs from PL/SQL

Lesson 5 : PL/SQL Server Pages

  • Embed PL/SQL code in Web pages (PL/SQL server pages)
  • Explain 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

Lesson 6 : Fine-Grained Access Control

  • Describe the process of fine-grained access control
  • Implement and test fine-grained access control

Lesson 7 : Performance and Tuning

  • Tune PL/SQL code
  • Identify and tune memory issues
  • Recognize network issues
  • Perform native and interpreted compilation

Lesson 8 : Analyzing PL/SQL Code

  • Find information about your PL/SQL code
  • Trace PL/SQL program execution
  • Profile PL/SQL applications

In-house price for 2 days

  • 36,000 baht(THB) : Economic Class : 1 - 5 people
  • 48,000 baht(THB) : Small Class : 6 - 10 people
  • 64,000 baht(THB) : Medium Class : 11 - 20 people
  • 80,000 baht(THB) : Large Class : 21 - 30 people
  • All prices exclude VAT 7 %

Printable Version ดาวน์โหลดหน้านี้ >>