|
Provided by: Serebra Learning Corporation Building a Data WarehouseData Warehousing |
 |
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.
|
|
||||||||
Training
Provided by Serebra Learning Corporation
- M asked: I am looking for a CBT course over Data Warehouse design and architecture. How much is this course and can I get it on CD?
- asked: Could you provide me the pricing detail of the course.
- asked: May I have free tutorial on this topic?
- M asked: I have done Masters in Information engineering but want to specialize on data warehousing. I would appreciate if I could receive information on the courses that helps to get specialized in data warehousing.
- P asked: I want to learn this tutorial but how to access and pay for this?
- T asked: I am looking for a CBT class that will help educate me on the concept of building dimension models for finance. Specifically, General Ledger and/or Mortgage loans. oes this class assist and what methodology is taught? Is it Snow Flakiing or Star Schema or a combination of both?
- T asked: I am looking for a CBT class that will help educate me on the concept of building dimension models for finance. Specifically, General Ledger and/or Mortgage loans. oes this class assist and what methodology is taught? Is it Snow Flakiing or Star Schema or a combination of both?
- T asked: I am looking for a CBT class that will help educate me on the concept of building dimension models for finance. Specifically, General Ledger and/or Mortgage loans. Does this class assist and what methodology is taught? Is it Snow Flakiing or Star Schema or a combination of both?
Building a Data Warehouse
AudienceObjectives
People who have a fairly good knowledge of the concepts of database systems, relational database management systems, and their architecture.
TopicsDesigning 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
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...
