CCOG for CIS 277T Fall 2024
- Course Number:
- CIS 277T
- Course Title:
- Web Business Intelligence Application 欧洲杯决赛竞猜app_欧洲杯足球网-投注|官网ment
- 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 欧洲杯决赛竞猜app_欧洲杯足球网-投注|官网ment 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:
- 欧洲杯决赛竞猜app_欧洲杯足球网-投注|官网 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
- 欧洲杯决赛竞猜app_欧洲杯足球网-投注|官网 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 欧洲杯决赛竞猜app_欧洲杯足球网-投注|官网ment Suite and build the following:
- 欧洲杯决赛竞猜app_欧洲杯足球网-投注|官网 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