Lynda - Implementing a Data Warehouse with Microsoft SQL Server 2012
Learn how to design and implement an enterprise data warehouse. Microsoft Certified Trainer Martin Guidry shows how to design fact and dimension tables using both the star and snowflake techniques, use data quality services to cleanse data, and implement an ETL process with SQL Server integration services.
Table of Contents
Introduction1. Setting Up the Environment2. Introduction to Data Warehousing3. Designing a Data Warehouse4. Data Warehouse Hardware5. Creating an Extract Transform and Load (ETL) Solution with SQL Server Integration Services (SSIS)6. Debugging and Troubleshooting SSIS Packages7. Implementing an Incremental ETL Process8. Deploying and Configuring SSIS Packages9. Enforcing Data Quality10. Consuming Data in a Data WarehouseConclusion
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.
Coktum |
