«back

ORACLE 10g FORMS & REPORTS DEVELOPER

TOTAL DURATION: 120 hours
CERTIFICATION     : Oracle10g Certified Forms Developer

Oracle Database 10g: Program with PL/SQL

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator certification.  
This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks and are introduced to stored procedures and functions. They learn about declaring variables, trapping exceptions and they also learn to declare and control cursors. In class students learn to develop, execute and manage PL\SQL stored program units like procedures, functions, packages and database triggers. Student also learns to manage object dependencies and recompilation of invalid objects. This course also describes the characteristics and ways of manipulation of large objects. Students are introduced to the utilization of some of the Oracle-supplied packages

Oracle Database 10g: Advanced PL/SQL

» Introduction to PL/SQL
» Declaring PL/SQL Identifiers
» Writing Executable Statements
» Writing Control Structures
» Working with Composite Data Types
» Using Explicit Cursors
» Handling Exceptions
» Creating Stored Procedures
» Creating Stored Functions
» Creating Packages
» Dynamic SQL and Metadata
» Managing Dependencies
» Manipulating Large Objects
» Creating Triggers
» Applications for Triggers
» Design Considerations
» Collections
» Advanced Interface Methods
» PL/SQL Server Pages
» Fine Grained Access Control
» Performance and Tuning
» Analyzing PL/SQL Code