Data Integrity and Security

Data Warehousing v2.0

Access to data is an important requirement for almost every organization. Organized into two major units, this course describes data support available for data mining, to include data warehousing, data marts, and online analytic processing. All of the relevant tools are covered.

The first part of the course defines and discusses these systems. The capabilities of each system are reviewed in terms of their functional purposes. Subunits and features of the major systems are explored, incorporating their purpose, processes and benefits. Web sites for additional information are provided, along with software products available for the various applications.

The second part of the course demonstrates each of the three systems with a prototypical example. Comparisons are provided, along with exhibits that illustrate the optimal use of each. In the concluding sections, meta data is discussed and data quality concepts are presented.

"Important: This course was previously titled as "Data Warehousing v.2" Please be aware that the content or course code has not changed."

Learning Objectives:

After completing this course, the course participant should be able to:

  • Define and explain the major support systems for data mining.
  • Recognize the key benefits of data warehousing.
  • Identify the key components and processes within a data warehouse.
  • Explain how data marts and OLAP are used.
  • Distinguish data warehouses from data marts and OLAP applications.
  • Articulate the need for meta data, along with the content of business and technical meta data.
  • Understand the importance of data quality, along with the techniques to improve data integrity.

Prerequisites/Advanced Preparation:


Speaker / Author:

David L. Olson
Dr. David L. Olson worked as an engineer for 12 years before earning an MBA and PhD in business, majoring in management science. He has taught at Texas A&M University since 1981 in management science, operations management, and management information systems. He has authored or co-authored five books related to research and teaching in these fields, and has participated in over 40 refereed research articles in these fields.


Price (USD)

Standard: $49.90


Course Code : 991199

Release Date : 07/14/2011
Expire Date : 02/14/2022
Credits :
CPE 2.00
QAS 2.00

Course Level : Basic
Course Type : New Standards
Length : 1hr 40min
Passing Grade : 70%
Theme : Data Integrity and Security

Format Type : eLearning
Field Of Study : Information Technology

Returning Subscribers

- OR -