Description
The Advanced PL/SQL Programming WBT is the third course in this curriculum. This course will enable users to create functions, packages, database objects, collections, and triggers. Additionally, it will enable users to create transactions, apply locks, and use dynamic SQL.
Audience
This course is designed for Application Developers who want to create database components using Oracle 8.
Prerequisites
Knowledge of database concepts.
Objective
Upon completion of this course, the student will be able to:
Create PL/SQL packages
Manage PL/SQL packages
Identify various Oracle server-supplied packages
Use stored functions in PL/SQL packages
Manage database objects
Manipulate database objects
Manipulate PL/SQL variables using collections
Implement varrays
Integrate database using PL/SQL triggers
Apply database triggers
Manipulate data using cursors
Declare a cursor variable
Integrate transactions with database
Restrict database access by applying locks
Control user access
Define dynamic SQL
Use DBMS_SQL to execute non-query DDL and DML statements
Use the DBMS_SQL package to execute queries
Identify the different types of exceptions
Handle user-defined exceptions
List PL/SQL debugging techniques
Minimize the occurrence of bugs using special programming methodologies
Topics Include
Working with Oracle8 Packages
- Introducing PL/SQL Packages
- Applying Advanced Package Concepts
- Quiz
Working with Objects and Collections
- Configuring Objects and Methods
- Grouping Objects using Collections
- Working with Database Triggers and Cursors
- Developing Database Triggers
- Manipulating Data with Cursors
- Quiz
Maintaining Data Concurrency and Consistency
- Adding Transactions and Locks
- Quiz
Using Dynamic SQL
- Removing Errors and Bugs from PL/SQL Programs
- Handling Exceptions
- Debugging PL/SQL
- Quiz
Duration
6 hrs
Minimum Requirements
Netscape or Internet Explorer (versions 4.0 or higher). Browsers should be capable of accepting cookies; SVGA Hi-color mode 800x600 resolution display. Macromedia Shockwave 6.02 or higher.
Media
Web Based Training
|
