Back

N° 20463 : Implementing a Data Warehouse with Microsoft SQL Server

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.

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.

This course is intended for database professionals who need to create and support a data warehousing solution. Primary responsibilities include:

    Implementing a data warehouse.
    Developing SSIS packages for data extraction, transformation, and loading.
    Enforcing data integrity by using Master Data Services.
    Cleansing data by using Data Quality Services.

You might also be interested in:

N° 20465 : Designing Database Solutions for Microsoft SQL Server 2012

This course describes how to design and monitor high performance, highly available data solutions with SQL Server 2012. This course focuses on creating plans and designs for database structure, storage, objects, and servers. Students will have the opportunity to practices hands-on skills and design tasks in a virtual lab environment and will learn about topics such as data compression, high availability, data migration, security, and scalability.

This course maps to skills and knowledge measured by Microsoft Exam 70-465, and in conjunction with on-the-job experience, can help prepare your for the exam.

QlikView Designer

The course is a mixture of demonstrations and hands-on exercises which include user interface layout, design fundamentals, how to create a QlikView application with sheets as well as best practices in design...

QlikView Developer

Knowledge of the data model, creation of the proper data connections and scripting fundamentals are critical to creating QlikView documents that provide your organization with powerful business discovery tools. QlikView Developer provides you with an opportunity to learn by doing through a series of lectures and hands-on exercises focused on developing QlikView documents...