Portland Community College | Portland, Oregon Portland Community College

Course Content and Outcomes Guides (CCOG)

CCOG for CIS 277T Spring 2024

View archive version »
Course Number:
CIS 277T
Course Title:
Web Business Intelligence Application Development
Credit Hours:
4
Lecture Hours:
30
Lecture/Lab Hours:
0
Lab Hours:
30

Course Description

Introduces fundamentals of Oracle Application Express 4.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 successfully completing this course the student will be able to do the following:

  • Develop a database-centric Web application using Oracle Application Express
  • Discuss the concepts for development and design of Business Intelligence reporting
  • Discuss and code advanced ANSI 99 standard SQL statements
  • Create a web application User Interface for DML using Oracle Application Express
  • Create web Business Intelligence reports using Oracle Application Express
  • Load and unload data using Oracle Application Express utilities
    • CSV files
    • XML files
  • Develop and test SQL logic using Oracle Application Express SQL Workshop

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, projects, and class assignments students will be assessed to determine whether they are able to:

  • Build a Web Application for Business Intelligence reporting and data manipulation using Oracle Application Express and the Oracle Database
  • Navigate Oracle Application Express Web Development Suite and build the following:
    • Develop a secure Web Application
    • Design a Master Detail Web form
    • Design a single Table Form Design
    • Design a Web dynamic data driven report
      • Multi-table Web report design and development
      • Analytical graphical report design and development
      • Analytical SQL Function reporting
    • Reporting using advanced SQL development
      • SQL Case statements
      • SQL WITH clause
      • Group By Clause using CUBE and ROLLUP
    • Advanced DML
      • Conditional Updates
      • Merge Clause
    • Materialized view development
    • Security implementation for Web Applications