Course Content and Outcome Guide for CIS 277T

Course Number:
CIS 277T
Course Title:
Web Business Intelligence Dev
Credit Hours:
Lecture Hours:
Lecture/Lab Hours:
Lab Hours:
Special Fee:

Course Description

Introduces fundamentals of Oracle Application Express 3.0, Web Application Development and Business Intelligence reporting using the newest ANSI 99 standard's features for SQL and DML. Covers fundamentals of Web Business Intelligence reporting and Web User Interface development. Recommend: CIS 276 or equivalent database experience. Audit available.

Intended Outcomes for the course

After completing this course the student will be able to do the following:
1. Develop a database-centric Web application using Oracle Application Express 3.0
2. Use and manage shared components in a application to fast track future development of additional applications.
3. Manage users and groups in a application to enforce security, including: managing access control by authorizing access to application items and pages, implementing security procedures by developing an authentication model for the Application users, loading and unloading data from and to an Oracle Database, exporting application components.

Course Activities and Design

The course consists of lectures, group discussion, and lab assignments. Lab assignments include both individual lab assignments and group lab assignments.

Outcome Assessment Strategies

Through exams and lab assignments students will be assessed to determine if they are able to:

  • Navigate development software application
  • Access and use the 3 iDS Forms help systems.
    • Tool internal help
    • Queue Cards help
    • Online manuals
  • Design forms applications
  • Build customer interface applications
    • Customer Form
    • Master Detail Order form
  • Code applications
    • Alerts
    • Messages
    • Triggers
    • List of Values
    • Canvas management
    • Window management
  • Code event driven processes
  • Apply re-usability concepts
    • PL/SQL Libraries
    • Procedure and Function implementations from the database
    • Oracle iDS Forms Object Libraries creation and implementation
    • Oracle iDS Forms Object Orientation features
  • Use iDS Build in Packages
  • Use transaction implementation processes
  • Apply application navigation control processes
  • Integrate Oracle Forms 6i and Oracle Reports 6i objects
  • Assemble user interfaces into a completed application. (Final Project)
    • Forms calling Forms
    • Forms calling Reports
    • Forms calling 3rd party applications
  • Complete Oracle iDS Reports installation
  • Navigate the Reports 6i development environment
    • 1 Development software
    • 2 Runtime software
  • Access and use the 3 iDS Reports help systems.
    • Tool internal help
    • Queue Cards help
    • Online manuals
  • Apply Reports design considerations
    • Retrieving and Sharing Data
    • Matrix report development
    • Tabular report development
    • Form letter reports
    • Mailing label development
  • Apply Report builder concepts
    • Report executables
    • Object Categories
    • File types and storage concepts
  • Use the various reports wizards
  • Use the Query Builder module
  • Enhance reports in the Report Live Pre-viewer module
  • Develop and implement Report Templates
  • Describe Reports storage methods
    • Storage requirements
    • Documenting reports
    • File portability
    • Conversion of report definitions
  • Enhance reports using the Data Model module
    • Maintaining Database columns
    • Creating a column
    • Creating summary columns
    • Creating formula columns
    • Creating placeholder column
    • Populating a placeholder column
  • Enhance reports using the Layout Model module
    • Designing Multi-panel reports
    • Recognizing layout objects
    • Understanding Layout Module layers
    • Creating layout objects
    • Adding additional layouts to a report
  • Develop parameterized reports
    • Creating parameters
    • Referencing parameters in a report query
    • Creating a List of Values
    • Referencing System parameters
    • Building parameter forms
  • Code PL/SQL Triggers in Reports 6i
  • Find and use Oracle Reports 6i built in packages
  • Customize the Reports Runtime module
  • Maximize performance on Reports.