Implementing A Data Warehouse With Microsoft SQL Server NetAssist
Price: AED 8,867
  • Locations: Colombo Kandy
  • Duration: 5 Days

    Course details

    This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

    At Course Completion

    After completing this course, students will be able to:

    • Describe data warehouse concepts and architecture considerations.
    • Select an appropriate hardware platform for a data warehouse.
    • Design and implement a data warehouse.
    • Implement Data Flow in an SSIS Package.
    • Implement Control Flow in an SSIS Package.
    • Debug and Troubleshoot SSIS packages.
    • Implement an ETL solution that supports incremental data extraction.
    • Implement an ETL solution that supports incremental data loading.
    • Implement data cleansing by using Microsoft Data Quality Services.
    • Implement Master Data Services to enforce data integrity.
    • Extend SSIS with custom scripts and components.
    • Deploy and Configure SSIS packages.
    • Describe how BI solutions can consume data from the data warehouse.

    Course Outline

    • Module 1: Introduction to Data Warehousing
    • Module 2: Planning Data Warehouse Infrastructure
    • Module 3: Designing and Implementing a Data Warehouse
    • Module 4: Creating an ETL Solution with SSIS
    • Module 5: Implementing Control Flow in an SSIS Package
    • Module 6: Debugging and Troubleshooting SSIS Packages
    • Module 7: Implementing a Data Extraction Solution
    • Module 8: Loading Data into a Data Warehouse
    • Module 9: Enforcing Data Quality
    • Module 10: Master Data Services
    • Module 11: Extending SQL Server Integration Services
    • Module 12: Deploying and Configuring SSIS Packages
    • Module 13: Consuming Data in a Data Warehouse
    Updated on 06 November, 2018

    About NetAssist

    Since its establishment in 1999, NetAssist has been continuously and vigorously committed to providing the highest quality of, and effective, training to IT professionals, both novice and experienced. We combine proven curriculum with practical hands-on learning and in-depth instruction to sharpen your technical skills. Our satisfied customers are our motivation and our best testimony.

    See all NetAssist courses
    Courses you can instantly connect with... Do an online course on SQL Server starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or