Data Warehousing Courses and Classes Overview

Those pursuing a career in data warehousing need a thorough understanding of database design and management, as well as proficiency in computer programming. Data warehousing courses are normally taken as part of a full degree program.

View Popular Schools

Essential Information

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
  • Hardware/software
  • Storage

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.

Next: View Schools

Popular Schools

The listings below may include sponsored content but are popular choices among our users.

Find your perfect school

What is your highest level of education?