Toll Free: 1.877.290.9507 | Direct:708.689.0131

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

Implementing a Data Warehouse with Microsoft SQL Server

Microsoft SQL Server 5-Day Training

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.
 
Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014.  It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform. 

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 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.
Who Should Attend:
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.
  • 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 you embark on a data warehousing project.
    Lessons

    Lab : Exploring a Data Warehousing Solution After completing this module, you will be able to: Module 2: Planning Data Warehouse Infrastructure 
    This module discusses considerations for selecting hardware and distributing SQL Server facilities across servers. 
    Lessons Lab : Planning Data Warehouse Infrastructure After completing this module, you will be able to: Module 3: Designing and Implementing a Data Warehouse 
    This module describes the key considerations for the logical design of a data warehouse, and then discusses best practices for its physical implementation. 
    Lessons Lab : Implementing a Data Warehouse After completing this module, you 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 Microsoft SQL Server Integration Services (SSIS) as a platform for building ETL solutions. 
    Lessons Lab : Implementing Data Flow in an SSIS Package After completing this module, you will be able to: Module 5: Implementing Control Flow in an SSIS Package 
    This module describes how to implement ETL solutions that combine multiple tasks and workflow logic. 
    Lessons Lab : Implementing Control Flow in an SSIS Package Lab : Using Transactions and Checkpoints After completing this module, you will be able to: Module 6: Debugging and Troubleshooting SSIS Packages 
    This module describes how you can debug packages to find the cause of errors that occur during execution. It then discusses the logging functionality built into SSIS that 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, you will be able to: Module 7: Implementing a Data Extraction Solution 
    This module describes the techniques you can use to implement an incremental data warehouse refresh process. 
    Lessons Lab : Extracting Modified Data After completing this module, you will be able to: Module 8: Loading Data into a Data Warehouse 
    This module describes the techniques you can use to implement data warehouse load process. 
    Lessons Lab : Loading a Data Warehouse After completing this module, you will be able to: Module 9: Enforcing Data Quality 
    This module introduces Microsoft SQL Server Data Quality Services (DQS), and describes how you can use it to cleanse and duplicate data. 
    Lessons Lab : Cleansing Data After completing this module, you will be able to: Module 10: Master Data Services 
    Master Data Services provides a way for organizations to standardize data and improve the quality, consistency, and reliability of the data that guides key business decisions. This module introduces Master Data Services and explains the benefits of using it. 
    Lessons Lab : Implementing Master Data Services After completing this module, you will be able to: Module 11: Extending SQL Server Integration Services 
    This module describes the techniques you can use to extend 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 Scripts After completing this module, you will be able to: Module 12: Deploying and Configuring SSIS Packages 
    In this module, students will learn how to deploy packages and their dependencies to a server, and how to manage and monitor the execution of deployed packages. 
    Lessons Lab : Deploying and Configuring SSIS Packages After completing this module, you will be able to: Module 13: Consuming Data in a Data Warehouse 
    This module introduces business intelligence (BI) solutions and describes how you can use a data warehouse as the basis for enterprise and self-service BI. 
    Lessons Lab : Using a Data Warehouse After completing this module, you will be able to:

    I had an above-average instructor. Not only did he instruct, he mentored us with real-world experience. The knowledge he had of the applications was beyond comprehensible. Outstanding!

    - Weston Flowers
    Brooke Army Medical Center (CTR)

    The instructor was able to not only answer all the questions we had in class and after hours he was able explain the technologies and real world reasons behind using technology A vs B. He adapted the class as needed for all students. I have only had one other instructor at his level in my 15 year career in IT.

    - Doug Lloyd - MESA
    University of Georgia

    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

    The instructor did a great job, his guidance on the skills of passing the exams was most valuable.

    - George Ballane
    Unavailable

    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

    My instructor is an excellent instructor. knowledgeable and good in the Net+, generally in computer training and other related area. he is very good. The quality of the course materials are perfect.

    - Lucy Fakeye - Net+
    [not provided]

    Prerequisites?
    This course requires that you meet the following prerequisites:
    • 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