->
Lynda - Implementing a Data Warehouse with Microsoft SQL Server 2012
Categories: Tutorials
Lynda - Implementing a Data Warehouse with Microsoft SQL Server 2012 - 156150
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

  • Introduction
  • 1. Setting Up the Environment
  • 2. Introduction to Data Warehousing
  • 3. Designing a Data Warehouse
  • 4. Data Warehouse Hardware
  • 5. Creating an Extract Transform and Load (ETL) Solution with SQL Server Integration Services (SSIS)
  • 6. Debugging and Troubleshooting SSIS Packages
  • 7. Implementing an Incremental ETL Process
  • 8. Deploying and Configuring SSIS Packages
  • 9. Enforcing Data Quality
  • 10. Consuming Data in a Data Warehouse
  • Conclusion

    • Lynda - Implementing a Data Warehouse with Microsoft SQL Server 2012


     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   |  

    Information
    Members of Guests cannot leave comments.


    Categories Sitemap



    rss