Data Warehousing Course

Total Items: 2 Total Time: 5.00 hour(s)  

Summary:

This training provides an overview of the use and administration of data warehouses.

It covers the components of data warehouses and explains data models and optimization.

It also examines the different roles in a data warehouse, and covers how to effectively design, implement, and manage a data warehouse.      

Learning Segment 1: Concepts    

Summary:

This learning segment provides an overview of data warehousing concepts, including their use, components, and structures.  

Objectives:

• Explain the function and use of data warehouses
• Identify the systems data warehouses use to store data
• Show how the components of data warehouses work together
• Compare data models and structures  

Topics:

• Introduction to Data Warehousing
• Managing Data with Data Warehousing
• Data Warehouse Components
• Data Models and Structures   

Learning Segment 2: Management    

Summary:

This learning segment provides an introduction to designing, building, and maintaining a data warehouse.  

Objectives:

• Identify warehouse requirements
• Plan and create a data warehouse
• Maintain a data warehouse
• Choose warehouse features based on requirements
• Provide the proper hardware and software support for a data warehouse
• Match business requirements to warehouse features  

Topics:

• Identifying Requirements
• Designing and Implementing the Warehouse
• Designing and Implementing the Warehouse
• Matching Warehouses to Requirements
• Supporting Warehouse Needs
• Business Management of Data Warehouses

Features:

• Exercises allow learners to practice in the actual application being studied.
• A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
• Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary.
• In addition, it lets them find other occurrences of the term in the same course.
• Search text enables learners to rapidly search all text within a course to easily retrieve information required.
• Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
• A skill assessment generates a customized learning path based on the results of a pre-test.
• A glossary provides a reference for definitions of unfamiliar terms.
• Bookmarking tracks the learner's progress in a course.  

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.