Architecting the Data Warehouse

start > courses and registration > training feature sheet

code.

DW112

length.

4 days

type.

Instructor-Led

partner.

IBM

price.

$2,600

Learn practical methods and techniques for architecting and designing the data warehouse. Learn the various architecture layers within the data warehouse, and an application framework for achieving results based on soundly defined business requirements. Learn how to apply the techniques in the context of an incremental data warehouse development process which is suitable for constructing a data warehouse from a departmental perspective that can serve a variety of analytical needs. In addition, you will also learn how the data warehouse solution can further be extended for the construction of consistent, corporate-wide data warehouses that serve traditional as well as dynamic warehouse objectives. As such, the course is suitable for you who wish to learn how to construct a data mart-based warehouse solution as well as a corporate-wide, fuly integrated data warehouse. You will apply the techniques they learn doing several exercises, which are part of a case study which is consistently developed throughout the course. This approach greatly enhances the practical value of the course, by exposing you to best practices and techinques used in companies of all sizes and scope of needs.

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

who can benefit

This is an intermediate course designed for students who have a reasonable knowledge of, and some experience with, data modeling, and with database design and construction techniques in the role of:

	Data modeler
	Database designer
	Database administrator
	Data architect
	Data warehouse project leaders with a technical interest in the matter
	All other technical professionals with an interest in designing and constructing a data warehouse environment

prerequisites

You should be familiar

	with relational database design and
	with relational database management systems in general.
	Being familiar with entity-relationship modeling as well as with DB2 on any platform will be helpful, but both are not required.

skills gained

	Have a thorough understanding of what a Data Warehouse is and how it can be enabled through applied architectures
	Be able to understand how to apply data warehouse enablement techniques in practice, in projects of non-trivial scope

ibm education advantage program eligibility:

Yes - IBM Education Pack - online account

course content details

	Course Topics

	An Introduction to Data Warehousing
	Tradtional and Evolving Data Warehouse architectures
	Data warehouse and Legacy Data Architectures
	Using the Data Warehouse - a perspective on decision support applications
	Survey of Verification Mode (OLAP) and Discovery Mode (Data Mining) analysis techniques
	Design and techniques for the warehouse populating subsystem
	Functionality and components of a data warehouse management system