{\rtf1\ansi\ansicpg1252\deff0\deftab709{\fonttbl{\f0\fnil\fcharset0 Arial;}{\f1\froman\fprq2\fcharset0 Times New Roman;}{\f2\fnil\fcharset2 Symbol;}} {\*\generator Msftedit 5.41.15.1507;}\viewkind4\uc1\pard\keepn\sb240\sa283\lang1033\b\fs32 Fundamentals of Data Warehousing\par \fs28 Course Specifications\par \pard\sa120\fs20 Course number: \b0 085715\lang41747\line\b Course length: \b0 0.5 day(s)\lang1033\par \pard\keepn\sb240\sa283\b\fs28 Course Description\par \pard\sa120\fs20 Course Objective: \b0 You will describe the fundamentals of data warehousing.\line\line\b Target Student: \b0 This course is intended for people involved in the data quality or data governance process, application development, project teams, IT managers, and project managers needing knowledge of various aspects or the basic fundamentals of data warehousing.\line\line\b Prerequisites: \b0 There are no specific prerequisites for this course other than basic familiarity with databases. \par \pard\keepn\sb240\sa283\b\fs28 Hardware Requirements\par \pard\sa120\b0\fs20 The instructor\rquote s computer should have the following hardware configured: \par \pard{\pntext\f2\'B7\tab}{\*\pn\pnlvlblt\pnf2\pnindent0{\pntxtb\'B7}}\fi-283\li707 Intel\'ae Pentium\'ae IV 300 MHz processor \par {\pntext\f2\'B7\tab}64 MB of RAM with 1.0 GB of free hard disk space \par {\pntext\f2\'B7\tab}CD-ROM drive \par {\pntext\f2\'B7\tab}Super VGA recommended (set at least to 800 x 600 screen resolution) with 256 colors \par \pard{\pntext\f2\'B7\tab}{\*\pn\pnlvlblt\pnf2\pnindent0{\pntxtb\'B7}}\fi-283\li707\sa120 Internet connection \par \pard\keepn\sb240\sa283\b\fs28 Software Requirements\par \pard\sa120\b0\fs20 Each computer requires the following software:\par \pard{\pntext\f2\'B7\tab}{\*\pn\pnlvlblt\pnf2\pnindent0{\pntxtb\'B7}}\fi-283\li707\sa120 Microsoft\'ae PowerPoint\'ae 2000 or later. \par \pard\keepn\sb240\sa283\b\fs28 Course Objectives\par \pard\sa120\b0\fs20 Upon successful completion of this course, students will be able to: \par \pard{\pntext\f2\'B7\tab}{\*\pn\pnlvlblt\pnf2\pnindent0{\pntxtb\'B7}}\fi-283\li707 identify the need for data warehouses as well as their general components, structure, and functions. \par {\pntext\f2\'B7\tab}describe enterprise data. \par {\pntext\f2\'B7\tab}describe data warehouse design and modeling. \par {\pntext\f2\'B7\tab}describe the data warehousing architecture. \par \pard{\pntext\f2\'B7\tab}{\*\pn\pnlvlblt\pnf2\pnindent0{\pntxtb\'B7}}\fi-283\li707\sa120 describe the business value of data warehousing. \par \pard\keepn\sb240\sa283\b\fs28 Course Content\par \pard\fs20 Lesson 1: Understanding a Data Warehouse\par \pard\li567 Topic 1A: \b0 Introduction to Data Warehousing \par \b Topic 1B: \b0 Types of Databases \par \pard\li567\sa283\b Topic 1C: \b0 OLTP and OLAP \par \pard\b Lesson 2: Understanding Enterprise Data\par \pard\li567 Topic 2A: \b0 Data Sources of a Data Warehouse \par \pard\li567\sa283\b Topic 2B: \b0 Characteristics of Data in a Data Warehouse \par \pard\b Lesson 3: Data Warehouse Design and Modeling\par \pard\li567 Topic 3A: \b0 Data Warehouse Design \par \pard\li567\sa283\b Topic 3B: \b0 Dimensional Model Schemas \par \pard\b Lesson 4: Understanding the Data Warehousing Architecture\par \pard\li567 Topic 4A: \b0 Extract, Transform and Load Data \par \pard\li567\sa283\b Topic 4B: \b0 Data Storage and Presentation \par \pard\b Lesson 5: Identifying the Business Value of Data Warehousing\par \pard\li567 Topic 5A: \b0 Understand Applications of Data Warehousing \par \pard\li567\sa283\b Topic 5B: \b0 Understand Data Mining \par \pard\f1\fs24\par }