95-797 Data Warehousing

• 6 units
• Prerequisites: 95-703 Database Management

This course will introduce you to the major activities involved in a data warehousing project. We'll begin by learning what data warehousing is and how it differs from other database systems. We'll move into creating a database model that is specifically optimized for data warehousing. From there, we'll look at what is involved in moving data from a source database into a warehouse. We'll then learn about the different tools an end user can use to access the data in a warehouse and spend one class as a hands-on lab with one such tool. We'll discuss organizational and management issues to be considered when approaching a data warehouse project and we'll look at the common applications in which warehousing is being used today. Finally, we'll take a specific look at the kinds of support the Oracle DBMS provides for data warehousing.