See how Insoft Services is responding to COVID-19
Learn more
phone  Contact Us  
X
about us

About Us

We are the leading IT training company in EMEAR. Insoft Group provides authorised training and consultancy services for leading IP vendors....
our instructors

Award Winning Instructors

Our elite instructors, who we time and time again rely on to deliver world-class training....
our recognition

Our Recognition

Insoft Services has achieved the International Organization for Standardization’s (ISO) 9001:2008 and ISO 27001:2005 certifications....
contact us

Contact Us

We are located in several location in EMEA. We have head quarters in London....
call us

Call us at +44 (0) 20 7193 0551

email us

Email us at [email protected]

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.


Microsoft Implementing a SQL Data Warehouse

Upcoming Courses

Aug 17 - Aug 21, 2020
09:00 - 17:00 (CEST)
Online
REGISTER
Oct 5 - Oct 9, 2020
09:00 - 17:00 (CEST)
Online
REGISTER
Oct 19 - Oct 23, 2020
09:00 - 17:00 (CEST)
Online
REGISTER

  • Insoft Training

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

    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.

     

    See other Microsoft courses

    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.