Data warehousing courses are found in management information systems and information science programs at 4-year colleges and universities. These programs are available at the bachelor's and master's levels, and students interested specifically in data warehouse management can choose to focus in that area.
Relevant courses in a management information systems or information science program include those in introductory data warehousing, advanced database management, database design and introductory programming. Students usually learn a common programming language before they study databases and data warehousing. Management information systems and information science programs also often teach students about computer networking, project management, website design, information security and systems analysis. Schools sometimes offer internships or require a thesis as well.
Here are a few common concepts taught in data warehousing courses:
- Methods of modeling
- Systems of data
- Using computers for measurements and calculations
List of Courses
Data Warehousing Introductory Course
This course covers the design, development, use and management of data warehouses. Specific elements include learning to create a dimensional model, developing requirements and generating maintenance and population plans. Also covered is the manipulation of warehouse data for maintenance, updating and data extraction. Internet deployment of the data warehouse may also be taught.
Advanced Database Management Course
This course addresses management of data warehouses and database technology from the perspective of a manager. Students complete exercises using the tools needed to manage a multi-user relational database system. Curriculum also covers treating various data structures such as trees, networks and linked lists within the system. Emphasis is on the administrative tasks associated with managing a database in a business environment. A programming background, while not a prerequisite, can be helpful.
Database Design Course
Students in this course learn advanced concepts in database design. Following presentation of a comparative review of data modeling methodologies, students learn about ternary and higher-order relationships, modeling subtypes and supertypes and integrity constraints. Students also learn how to explain databases to other people. The curriculum seeks to provide students with a comprehensive understanding of the principles of data modeling and data model conversion into systems.
Programming Introductory Course
Intended for students with little or no programming experience, this course introduces the basic principles of computer programming and design. Students learn about algorithms, language syntax, logic structures, math functions and arrays. The curriculum often uses the high-level programming language of C, C++ or Python. Other areas include a description of software and hardware concepts, storage and computer architecture and functioning.