20463: Implementing a Data Warehouse with Microsoft SQL Server 2014

  • Overview

    This module will teach students how to execute a data warehouse platform to support a BI solution. Candidates will learn how to create a data warehouse with MS SQL Server, execute ETL with SQL Server Integration Services, validate data with SQL Server Data Quality Services and SQL Server Master Data Services.

    Course Objectives

     

    • Plan Data Warehouse Hardware
    • Implement a Snowflake Schema
    • Transfer Data by Using a Data Flow Task
    • Implement control flow with tasks and precedence constraints
    • Use SSIS for Incremental Loads
    • Implement a Master Data Services model
    • Use Master Data Services tools to manage master data
    • Create an SSIS Catalog
    • Describe how a data warehouse can be used in enterprise BI scenarios

    Course Details / Exam(s)

    Schedule for 20463: Implementing a Data Warehouse with Microsoft SQL Server 2014
    Course# Course Contents Exam #

    Regular Track
    (days)

    20463D Implementing a Data Warehouse with Microsoft SQL Server 2014 70-463 5
    Total 5
    Prerequisites
    • At least 2 years of experience of working with relational databases
    Recommended Courses and Certification:
    Give an edge to your career with technical certifications and training courses. Students can join the classes for 20463: Implementing a Data Warehouse with Microsoft SQL Server 2014 at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.
  • Students Reviews
    Mohammad Hassan Mahamud Koenig IT Training Student

    The SQL Server Performance Tuning and Optimization training I received at Koenig Delhi was very informative and practical. The course was quite relevant to my job and will help me in most aspects of...

    Read MoreMohammad Hassan MahamudBangladesh
    Hassan  Alawi Koenig IT Training Student

    My name is Hassan and I'm from Copenhagen in Denmark. I have no IT education on paper since I'm self-taught into IT. So I decided it is time to be certified, to get my knowledge on paper. I found...

    Read MoreHassan AlawiDenmark
    Juvencio  Manhique Koenig IT Training Student

    The experience I had with Koenig Solutions in Dubai was very good and rewarding, since the beginning till the very end. Instructor was able to guide his students very well, through his knowledge of...

    Read MoreJuvencio ManhiqueUnited Arab Emirates
    Bert  Ham Koenig IT Training Student

    I would like to thank you and your team for a very good course, I am very pleased with the results (MCSA 2012 graduation) and the acquired knowledge. The MCSA training was very good and the trainer...

    Read MoreBert HamNetherlands
     Robert Bakyayita    Koenig IT Training Student

    I came for training on Implementing Data Models and Reports with Microsoft SQL Server 2012. I have 7 years of experience in Information Technology across African Continent of which the current is...

    Read More Robert Bakyayita Uganda
    View All Testimonials
  • Schedule & Course Fees
    1


    5
    5
    Classes will be conducted from 09:00 am - 05:00 pm at Your Local Time
    Price includes Official Curriculum.
    For any Query or Custom Plan info@koenig-solutions.com +1 877 226 2244
  • Enquire Now
    * Required Fields
    •