'CISD' -- CIS Database Courses
 
   
 

 
CISD 32 Course Image

CISD 32 - Oracle Forms and Reports                 (3 units)
This course covers the design, creation and implementation of interactive single forms with multiple canvases.  The student will learn how to create multiple forms and reports using PL/SQL triggers, the Object Navigator, and Oracle's Form & Report Builders.

Reports and interactive forms will use single and multiple tables in a realistic business setting.

The student receives extensive hands-on instruction on a Windows-based personal computer.
 
(54 hours lecture;  54 hours lab;  Degree appropriate)
Advisory Prerequisite:   CISD 31 - Database Management - Oracle

Course Measurable Objectives:

  1. Analyze business problems and design appropriate Oracle interactive forms and reports.
  2. Analyze business forms and design appropriate Oracle forms and report functions and commands.
  3. Write Oracle PL/SQL trigger functions for client and database servers.
  4. Develop, write, test, debug and implement a complete Oracle Forms and Report application with PL/SQL triggers on the client and server database.
  5. Organize, classify and write Oracle application documentation.

Course Level Student Learning Outcomes:


Students completing CISD 32 - Oracle Forms and Reports will be able to:
  1. explain the differences between a Data Block form and a Control Block form.
  2. determine when to issue an Alert as opposed to a Custom Message to the user.
Send questions or comments about this Web site to the  Business Division's  Web Content Manager .
Use of this Web server is subject to the Mt. San Antonio College   Terms of Use  and  Privacy Policy .