ORACLE (Application Development Track)

Ministry Approved Certificate

Course Overview

Oracle 10g- Introduction to SQL and PL/SQL

Course Contents:

• Introduction
• Retrieving Data Using the SQL SELECT Statement
• Restricting and Sorting Data
• Using Single Row Functions to Customize Reports
• Reporting Aggregated Data Using the Group Functions
• Displaying Data From Multiple Tables
• Using Sub queries to Solve Queries
• Using the SET Operators
• Manipulating Data
• Using DDL Statements to Create and Manage Tables
• Creating Other Schema Objects
• Managing Objects with Data Dictionary Views
• Controlling User Access
• Generating Reports by Grouping Related Data
• Managing Data in Different Time Zones
• Searching Data Using Advanced Sub queries
• Hierarchical Data Retrieval
• Introduction to PL/SQL Objects
• Procedural Language
• PL/SQL Blocks, Anonymous Blocks and Named Blocks
• Creating PL/SQL Procedures and Functions
• Understanding Triggers
• Packages

Oracle 10g- Oracle Developer Forms 10g

Course Outline:

• Introducing Oracle Forms Developer and Forms Services
• Creating Forms Modules
• Working with Data Blocks and Frames
• Working with Input Items
• Working with Non input Items
• Creating Windows and Canvases
• Producing Triggers
• Debugging Triggers
• Adding Functionality to Items
• Run-Time Messages and Alerts
• Query Triggers
• Validation
• Navigation
• Transaction Processing
• Writing Flexible Code
• Sharing Objects and Code
• Introducing Multiple Form Applications

Oracle 10g- Oracle Developer Reports

Course Outline:

• Introduction to Oracle Reports Developer
• Designing and Running Reports
• Working in Oracle Reports Developer
• Creating a Paper Report
• Enhancing a Basic Paper Report
• Managing Report Templates
• Controlling the Paper Layout: Common Properties
• Creating and Using Report Parameters
• Embedding a Graph in a Report
• Enhancing Matrix Reports
• Coding PL/SQL Triggers