| WA1476 Oracle Database 10g: Program With PL/SQL Part II Training and Courseware |
|
| Description |
|
The Oracle PL/SQL language provides for programming logic features not contained within SQL. The grammar, syntax and benefits of using the PL/SQL language within an Oracle database environment are considered.
|
|
| Course Objectives: |
|
The objective of this course is to equip students to develop database server-side PL/SQL program units within an Oracle database. Major subject areas to be explored and secondary objectives are:
- Understanding application partitioning within a client/server or multi-tiered web-based architecture.
- Understanding the basic form and structure of program units stored within the database.
- Building and maintaining database stored program units.
- Encapsulating stored units within packages and taking advantage of accompanying advanced programming techniques such as cursor variables and cursor expressions.
- Handling intricate theoretical challenges, such as mutating tables.
- Building and maintaining DML-event and system-event database triggers.
- Discuss the storage and execution model for database programs and how one can write efficient programs to maximize performance.
- Using system-supplied packages to extend the power of your SQL statements and PL/SQL applications.
|
|
| Target Audience
: |
|
Target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are:
- Application designers and developers.
- Database administrators
|
|
| Duration: |
| |
Three days. |
|
|
|
|
