Computer Applications

CAP - Computer Applications

CAP 4774

Data Warehousing

(Offered fall). Prerequisites: ISM4214 or COP2701 with a minimum grade of "C." Prerequisite or corequisite: MAN3303. This course provides an introduction to data warehousing concepts, requirements gathering, design and implementation. Students learn about operational database integration, extraction, transformation, loading of data to historical database system such as operational data store and data warehouse. Students are provided with techniques for the analysis, design, denormalization,implementation, utilization, and documentation in the development of data warehouse systems. Structure query language for database and data warehouse will be studied and used to retrieve data and manipulate the information from the implemented databases. Students are required to complete and present a project to class in the data warehousing area.

Credit hours: 3Lecture hours: 3

Gulf Coast State College does not discriminate against any person in its programs, activities, policies or procedures on the basis of race, ethnicity, color, national origin, marital status, religion, age, gender, sex, pregnancy, sexual orientation, gender identity, genetic information, disability, or veteran status. All questions or inquiries regarding compliance with laws relating to non-discrimination and all complaints regarding sexual misconduct or discrimination, may be directed to Lee Wood, Executive Director, Human Resources/Title II/504/Title IX Coordinator and Employment Equity Officer, Gulf Coast State College, 5230 W. US Highway 98, Panama City, FL 32401.