See how Insoft Services is responding to COVID-19

Microsoft Implementing a SQL Data Warehouse

X

Contact Us

We would love to hear from you. Please complete this form to pre-book or request further information about our delivery options.

Subscribe

I'd like to receive emails with the latest updates and promotions from Insoft.

Data Protection & Privacy

I hereby allow Insoft Ltd. to contact me on this topic. Further, I authorise Insoft Ltd. processing, using collecting and storing my personal data for the purpose of these activities. All your data will be protected and secured as outlined in our privacy policy.


Upcoming Courses

Aug 17 - Aug 21, 2020
09:00 - 17:00 (CEST)
Online

Oct 5 - Oct 9, 2020
09:00 - 17:00 (CEST)
Online

Oct 19 - Oct 23, 2020
09:00 - 17:00 (CEST)
Online

  • Microsoft Implementing a SQL Data Warehouse
    5 days  (Instructor Led Online)  |  Analytics and Data Management Courses

    Course Details

    The Microsoft Implementing a SQL Data Warehouse course is a five-day instructor-led training where you will learn to provision a Microsoft SQL Server database. The course covers SQL Server provision both on-premise and in Azure, and covers installing from new and migrating from an existing install. In this course, you will also learn how to describe the key elements of a data warehousing solution, implement a logical design for a data warehouse, describe the considerations for implement an ETL solution, and more.

    Outline

    After completing this course, students will be able to:

    • Describe the key elements of a data warehousing solution
    • Describe the main hardware considerations for building a data warehouse
    • Implement a logical design for a data warehouse
    • Implement a physical design for a data warehouse
    • Create column store indexes
    • Implementing an Azure SQL Data Warehouse
    • Describe the key features of SSIS
    • Implement a data flow by using SSIS
    • Implement control flow by using tasks and precedence constraints
    • Create dynamic packages that include variables and parameters
    • Debug SSIS packages
    • Describe the considerations for implement an ETL solution
    • Implement Data Quality Services
    • Implement a Master Data Services model
    • Describe how you can use custom components to extend SSIS
    • Deploy SSIS projects
    • Describe BI and common BI scenarios

    Target Audience

    The primary audience for this course is database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.

    Prerequisites

    In addition to the professional experience, students who attend this training should already have the following technical knowledge:

    • Basic knowledge of the Microsoft Windows operating system and its core functionality.
    • Working knowledge of relational databases.
    • Some experience with database design.