Toll Free: 1.877.290.9507 | Direct:708.689.0131

Implementing a Data Warehouse with Microsoft SQL Server 2012 (MS-10777)

Implementing a Data Warehouse with Microsoft SQL Server 2012

Microsoft SQL Server 5-Day Training

Data warehousing is a solution organizations use to centralize business data for reporting and analysis. This five-day instructor-led course focuses on teaching individuals how to create a data warehouse with SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. This course helps people prepare for exam 70-463.

Total Price: $-,---

Click to Show Course Pricing

Information about this course:

This course is offered as:

  • Classroom Instructor-led Boot Camp
  • Live Online Instructor-led Boot Camp
  • Mentored Self-Paced Online
  • Streaming-Only Self-Paced Online

Course Highlights
  • 93% Pass Rate
  • Hands-on training with latest technologies
  • Complex sims & exercises, gives you practical hands-on experience
award-winning-training
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 SSIS solution that supports incremental data warehouse loads and changing data.
  • Integrate cloud data into a data warehouse ecosystem infrastructure.
  • 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 information workers can consume data from the data warehouse.
Who Should Attend:

This course is intended for database professionals who need to fulfill 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. Primary responsibilities include:

  • Implementing a data warehouse.
  • Developing SQL Server Integration Services (SSIS) packages for data extraction, transformation, and loading (ETL).
  • Enforcing data integrity by using Master Data Services.
  • Cleansing data by using Data Quality Services.
  • What's Included:

    Only Intense School’s Boot Camp offers you the following benefits:

    • 5 full days of intense instruction with no outside distractions
    • Exam Vouchers for exams
    • Microsoft Press E-Reference Library, including all Training Kits, Exam References, and Rapid Review books
    • 2nd shot vouchers - in case you do not pass an exam
    • Pre-Class Prep Materials
    • In-person access to the top experts in the industry
    • Lunch and snacks provided on each day of class

    FREE MICROSOFT TRAINING!

    Redeem Microsoft SATV Training Vouchers HERE

    Click here to get more information about this class!

    Instantly View Course Syllabus and price

    View Course Calendar

    Unfortuantely, no public enrollment courses currently match your criteria. Contact Us Here to find out other options with this class.





    Select the type of training that best fits your schedule and learning style!

    Live, Online, Self-Paced, Classroom - contact us for details on each.

    Self-Paced

    Streaming Only

    Base option for limited budgets

    • Easy Online Access
    • Expert Microsoft Instructor
    • Exam Review
    • Highest Quality Content - 90% Pass
    • Self-Paced Training
    Self-Paced

    Mentored Online

    Most popular self-paced option.

    • Online & Offline Playback (DVD,mobile)
    • Expert Microsoft Instructor
    • Intense Proprietary Exam Prep
    • Highest Quality Content - 90% Pass
    • Hands-On Lab Exercises
    • Self-Paced Mentored Training
    • Mentor & Live Instructor Support
    • Text books, Pre-Study, and Lab books
    • Complex Sims and Exercise Files
    Classroom

    Instructor-Led

    Our top rated training experience

    • Live Classroom
    • Expert Microsoft Instructor
    • Intense Proprietary Exam Prep
    • Highest Quality Content - 90% Pass
    • Microsoft Certification Library
    • Hands-On Lab Exercises
    • Lunch, Snacks
    • Train In-Person at Training Facility
    • Exam Vouchers
    • 2nd Shot Exam Voucher
    • Pre-Shipment of Pre-Study Books
    • Text books, Pre-Study, and Lab books
    • Complex Sims and Exercise Files
    Classroom

    Live Online

    Live experience from home or work

    • Live Online Classroom
    • Expert Microsoft Instructor
    • Intense Proprietary Exam Prep
    • Highest Quality Content - 90% Pass
    • Microsoft Certification Library
    • Hands-On Lab Exercises
    • Exam Vouchers
    • 2nd Shot Exam Voucher
    • Pre-Shipment of Pre-Study Books
    • Text books, Pre-Study, and Lab books
    • Complex Sims and Exercise Files

    Course Outline

    Module 1: Introduction to Data Warehousing 
    This module provides an introduction to the key components of a data warehousing solution and the high-level considerations you must take into account when starting a data warehousing project.
    Lessons

    Lab : Exploring a Data Warehousing Solution

    After completing this module, students will be able to:

    Module 2: Data Warehouse Hardware 
    This module describes the characteristics of typical data warehouse workloads, and explains how you can use reference architectures and data warehouse appliances to ensure you build the system that is right for your organization.
    Lessons

    After completing this module, students will be able to:

    Module 3: Designing and Implementing a Data Warehouse 
    In this module, you will learn how to implement the logical and physical architecture of a data warehouse based on industry-proven design principles.
    Lessons

    Lab : Implementing a Data Warehouse Schema

    After completing this module, students will be able to:

    Module 4: Creating an ETL Solution with SSIS 
    This module discusses considerations for implementing an ETL process, and then focuses on SQL Server Integration Services (SSIS) as a platform for building ETL solutions.
    Lessons

    Lab : Implementing Data Flow in a SSIS Package

    After completing this module, students will be able to:

    Module 5: Implementing Control Flow in an SSIS Package 
    Control flow in SQL Server Integration Services packages enables you to implement complex ETL solutions that combine multiple tasks and workflow logic. This module covers how to implement control flow, and design robust ETL processes for a data warehousing solution that coordinate data flow operations with other automated tasks.
    Lessons

    Lab : Implementing Control Flow in an SSIS Package

    Lab : Using Transactions and Checkpoints

    After completing this module, students will be able to:

    Module 6: Debugging and Troubleshooting SSIS Packages 
    This module describes how you can debug SQL Server Integration Services (SSIS) packages to find the cause of errors that occur during execution. Then module then covers the logging functionality built into SSIS you can use to log events for troubleshooting purposes. Finally, the module describes common approaches for handling errors in control flow and data flow.
    Lessons

    Lab : Debugging and Troubleshooting an SSIS Package

    After completing this module, students will be able to:

    Module 7: Implementing an Incremental ETL Process 
    This module describes the techniques you can use to implement an incremental data warehouse refresh process.
    Lessons

    Lab : Extracting Modified Data

    Lab : Loading Incremental Changes

    After completing this module, students will be able to:

    Module 8: Incorporating Data from the Cloud into a Data Warehouse 
    In this module, you will learn about how you can use cloud computing in your data warehouse infrastructure and learn about the tools and services available from the Microsoft Azure Marketplace. 
    Lessons

    Lab : Using Cloud Data in a Data Warehouse Solution

    After completing this module, students will be able to:

    Module 9: Enforcing Data Quality 
    Ensuring the high quality of data is essential if the results of data analysis are to be trusted. This module explains how to use the SQL Server 2012 Data Quality Services (DQS) to provide a computer assisted process for cleansing data values and identifying and removing duplicate data entities. 
    Lessons

    Lab : Cleansing Data

    Lab : Deduplicating Data

    After completing this module, students will be able to:

    Module 10: Using Master Data Services 
    This module introduces Master Data Services and explains the benefits of using it in a data warehousing context. The module also describes the key configuration options for Master Data Services, and explains how to import and export data. Finally, the module explains how to apply rules that help to preserve data integrity, and introduces the new Master Data Services Add-in for Excel. 
    Lessons

    Lab : Implementing Master Data Services

    After completing this module, students will be able to:

    Module 11: Extending SQL Server Integration Services 
    This module describes the techniques you can use to extend SQL Server Integration Services (SSIS). The module is not designed to be a comprehensive guide to developing custom SSIS solutions, but to provide an awareness of the fundamental steps required to use custom components and scripts in an ETL process that is based on SSIS.
    Lessons

    Lab : Using Custom Components and Scripts

    After completing this module, students will be able to:

    Module 12: Deploying and Configuring SSIS Packages 
    SQL Server Integration Services provides tools that make it easy to deploy packages to another computer. The deployment tools also manage any dependencies, such as configurations and files that the package needs. In this module, you will learn how to use these tools to install packages and their dependencies on a target computer.
    Lessons

    Lab : Deploying and Configuring SSIS Packages

    After completing this module, students will be able to:

    Module 13: Consuming Data in a Data Warehouse 
    This module introduces Business Intelligence (BI), describes the components of SQL Server that you can use to create a BI solution, and the client tools that users can use to create reports and analyze data. 
    Lessons

    Lab : Using Business Intelligence Tools

    After completing this module, students will be able to:

    Instructor was very knowledgeable in all subjects of the course and tailored his lessons and labs to the student's weaknesses. Very eager to help students in any way he can.

    - Scott Masury
    MA Army National Guard

    The class more than exceeded my expectations. The material was exactly what i needed to get my certifications and more. There was not one question the professor could not answer.

    - George Embrey
    IMC

    He was very knowledgable in the course material and presented it in a very methodical way. The course materials were great and are resources we will use in the future.

    - Ralph Polk
    Brooke Army Medical Center (CTR)

    Our instructor displayed exceptional knowledge and expertise with the material he was teaching. He was very patient with the class, who did not have a lot of experience with material being covered.

    - Dale Wamsley
    Brooke Army Medical Center (CTR)

    Course was outstanding as always. All material was covered well and all questions were answered. I am thoroughly satisfied.

    - Bill Ross
    Precision Fabricating & Cleaning Inc.

    The instructor had an excellent demeanor and candor, very knowledgable about IT industry in general and many different fields in specific.

    - Jose Rengel
    none

    Prerequisites?
    Before attending this course, students must have:
    • At least 2 years’ experience of working with relational databases, including:
    • Designing a normalized database.
    • Creating tables and relationships.
    • Querying with Transact-SQL.
    • Some exposure to basic programming constructs (such as looping and branching).
    • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
    Certifications

    ...

    States