MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Implementing a Data Warehouse with Microsoft SQL Server 2012

Course Summary

 Learn how to design and implement an enterprise data warehouse, with Microsoft SQL Server.


  • +

    Course Syllabus

    • Introduction
      • Welcome
      • What you should know
      • Using the exercise files
    • Setting Up the Environment
      • Finding and downloading SQL Server 2012 trial edition
      • Installing SQL Server 2012 trial edition
      • Finding and installing the sample data
    • Introduction to Data Warehousing
      • Overview of data warehousing
      • Understanding the differences between typical databases and data warehouses
      • Implementing a data warehouse using a SQL database engine
    • Designing a Data Warehouse
      • Logical design for a data warehouse
      • Choosing between star and snowflake schema design techniques
      • Physical design for a data warehouse
    • Data Warehouse Hardware
      • Considerations for building a data warehouse
      • Data warehouse reference architectures
      • Appliances and big data
    • Creating an Extract Transform and Load (ETL) Solution with SQL Server Integration Services (SSIS)
      • Introduction to ETL with SSIS
      • Exploring source data
      • Introduction to control flow
      • Implementing data flow
    • Debugging and Troubleshooting SSIS Packages
      • Debugging an SSIS package
      • Logging SSIS package events
      • Handling errors in an SSIS package
    • Implementing an Incremental ETL Process
      • Introduction to incremental ETL
      • Extracting modified data
      • Loading modified data
      • Working with slowly changing dimensions
    • Deploying and Configuring SSIS Packages
      • Installing and maintaining SSIS components
      • Deploying SSIS solutions
      • Using SQL Server Agent to execute an ETL package
      • Configuring advanced SSIS settings
    • Enforcing Data Quality
      • Installing Data Quality Services
      • Using Data Quality Services to cleanse data
      • Using Data Quality Services to find duplicate data
      • Utilizing Data Quality Services in an SSIS data flow
    • Consuming Data in a Data Warehouse
      • Introduction to business intelligence
      • Using Reporting Services with a data warehouse
      • Introduction to data analysis with SQL Server Analysis Services (SSAS)
    • Conclusion
      • Next steps


Course Fee:
USD 25

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 2 hours / week

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top