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/SQLserver 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-grainedaccess 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 %
related links
home · about VT · contact us
Oracle Training | Home |
Oracle Service | About us |
FAQ & Tips | Our clients |
Contact us |