|
Provided by: Serebra Learning Corporation Building a Data WarehouseData Warehousing |
 |
Training
Provided by Serebra Learning Corporation
The Building a Data Warehousing WBT is the second course in the Data Warehousing curriculum. It provides students with an overview of the core technologies, concepts, architecture, and various features of data warehouses, models, and data extraction tools. People who have a fairly good knowledge of the concepts of database systems, relational database management systems, and their architecture.
|
|
||||||||||
Building a Data Warehouse
Audience
People who have a fairly good knowledge of the concepts of database systems, relational database management systems, and their architecture.
Topics
Designing the Warehouse Model
- Extracting Source Data
- Designing Enterprise Warehouse
- Modeling Temporal Data
- Quiz
Designing a Data Mart
- Basics of Dimensional Models
- Using Dimensional Models
- Quiz
Implementing the Technological Design
- Selecting a Design Technology
- Benchmark Testing
- Quiz
Objectives
Upon completion of this course, the student will be able to:
- List the steps for scrubbing data
- Map source data to subject area
- Verify data integrity
- Map subject areas to the warehouse model
- Understand how to model the operational data store
- Identify different kinds of temporal data
- Develop temporal transformations from subject areas to the warehouse model
- Construct temporal queries
- Define the dimensional model and its components
- Define the flow of products through a value chain
- Convert the dimensional model to the warehouse model
- Identify types of schema
- Implement the dimensional schema as a star schema
- Select the hardware platform
- Select the data extraction tools
- Select the database platform
- Describe the standard industry benchmarks
- Test a data warehouse
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
