Implementing a Data Warehouse with Microsoft® SQL Server® 2014

Become a data warehousing specialist with Microsoft SQL Server 2014. Design and implement a data warehouse. Implement an ETL solution for incremental data extraction and data loading. Acquire knowledge on Master Data Services to enforce data integrity. Get insights to SSIS Packages and implementing data flow and control flow in SSIS Packages. Debug, troubleshoot, deploy and configure SSIS packages. Get the complete knowledge on Designing a normalized database, creating tables and relationships and querying with Transact-SQL.

  • On demand online self-paced Instructor-led classes by Industry Experts
  • Build a data warehouse with Microsoft® SQL Server® 2014
  • Guidance to Practice, Study and Gain confidence to clear the Microsoft SharePoint Server 2013 Certification Exam
  • Call Me

    Self-Paced

    batch loading...

    Course Features

    Related Courses

    About Implementing a Data Warehouse with Microsoft® SQL Server® 2014

    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.

    Course Objectives
    • 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.
    Curriculum
    Module 1:

    Introduction to Data Warehousing

    Module 2:

    Data Warehouse Hardware Considerations

    Module 3:

    Designing and Implementing a Data Warehouse

    Module 4:

    Creating an ETL Solution with SSIS

    Module 5:

    Implementing Control Flow in an SSIS Package

    Module 6:

    Debugging and Troubleshooting SSIS Packages

    Module 7:

    Implementing an Incremental ETL Process

    Module 8:

    Enforcing Data Quality

    Module 9:

    Using Master Data Services

    Module 10:

    Extending SQL Server Integration Services

    Module 11:

    Deploying and Configuring SSIS Packages

    Module 12:

    Consuming Data in a Data Warehouse

    Instructor

    All Microsoft On-demand content is designed and created by Microsoft Certified Trainers and Microsoft Subject Matter Experts. The trainers teaching the content in videos are the officials who have been working on the same technology that is being taught in the course.

    Certification

    After completing the course sucessfully you will be able to download and save the certificate or print it.

    Pre-requisites

    This course requires that you meet the following prerequisites:

    • At least 2 years’ experience of working with relational databases
    • 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.
    FAQs

    Why should I choose MOC on-demand?

    To ensure that learners have the adequate skills to use Microsoft technologies MOC on-demand Courses have been introduced by Microsoft. These courses have been made available to serve the needs of learners who prefer to study at their own pace, at their convinient time and from their preferred location globally.

    What do MOC On-demand courses include?

    • MOC On-demand Courses are organised in Modules which include:
    • Demos: A video walk-through of a process or task discussed in that lesson.
    • Practices: A self-paced practice where they can apply what was covered in the lesson, with supporting prompts to guide them as needed.
    • Labs: These detailed exercises use practice files and offer a more hands-on experience with the lesson material. Note: Not all courses include labs.
    • Knowledge Checks: A brief quiz testing what was learned in the lesson.
    • Assessments: To test knowledge attained from the course.

    How do I get the product?

    After purchasing a MOC on-demand course on training.com, you will receive a mail with an access code, link to the Microsoft training site and detailed instructions to login, redeem the Access Code and start with your course.

    What is important for students to know before redeeming a voucher code?

    • You need to create a Microsoft account if you have not already, for example, Live.com, Hotmail.com and Outlook.com.
    • An access code can only be redeemed once.
    • A code must be redeemed by the expiration date provided by their Microsoft Learning Partner.
    • Once activated, course materials are available for a period of 90 days
    • All the details are included in the Microsoft Official Course On-Demand Terms and Conditions: http://go.microsoft.com.

    Who should join this course?

    This course is intended for 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. 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.

    How are the MOC courses structured?

    Microsoft official courses on-demand are arranged in modules that include few minutes videos. At the end of each module one or two questions will be posed to test your comprehension. There will be an assessment of at least 25 questions at the end of the course.

    How long does a MOC on-demand course generally take to complete?

    It requires approximately 30 to 45 hours to complete a course.

    What are the course packages available to purchase?

    There are 2 sets of courses - Basic Set and Package Set

    Basic Set:
    • 90-day access to the official Microsoft On-Demand Training Videos
    • 90-day access to Live Microsoft Labs Online (MLO) for hands-on practice
    • 90-day access to Course Exercises
    • Reading and Knowledge checks throughout the course
    • Package Set:
    • Basic Set features
    • Digital edition of the Microsoft Official Curriculum (dMOC) kit for reference.

    Course Features

    batch loading...

    Related Courses

    AI and Deep Learning with TensorFlow
    AWS Certification and Training Program
    Active Directory® Services with Windows Server®
    Administering Microsoft Exchange Server 2016
    Administering Microsoft® SQL Server® 2014 Databases
    Administering System Center Configuration Manager and Intune
    Administering Windows Server® 2012
    Administering the Web Server IIS Role of Windows Server
    Administration Essentials for New Admins- Salesforce
    Advanced Automated Administration with Windows PowerShell®
    Advanced Data Mining projects with R
    Advanced Pay Per Click
    Advanced Program in Data Sciences
    Advanced Social Media Marketing
    Advanced Solutions of Microsoft Exchange Server 2013
    Advanced Solutions of Microsoft® SharePoint® Server 2013
    Analyzing Data with Power BI
    Analyzing and Visualizing Data with Excel
    Analyzing and Visualizing Data with Power BI
    Android Game Development for Beginners
    Angular 5
    Application Development with Swift 2
    Automated UI Testing in Java
    Automating Administration with Windows PowerShell®
    Big Data Analytics with R
    Big Data Applications using Hadoop
    Building Android Games with OpenGL ES
    Building Applications with Ext JS
    Building Applications with Force.com
    Building a Data Mart with Pentaho Data Integration
    Building iOS 10 Applications with Swift
    Builiding web application with spring MVC
    Business Analytics using R from KPMG
    Business Analytics using R from KPMG – Advanced
    Business Analytics using R from KPMG – Expert
    Certified Digital Marketing Professional
    Cloud and Datacenter Monitoring with System Center Operations Manager
    Complete Web and Social Media Analytics
    Configuring Advanced Windows Server® 2012 Services
    Core Solutions of Microsoft® Exchange Server 2013
    Core Solutions of Microsoft® SharePoint® Server 2013
    Core Solutions of Skype for Business 2015
    Data Quality 9.x: Developer, Level 1
    Data Science Orientation
    Data Science with R
    Data Science with Spark
    Deploying Windows Desktops and Enterprise Applications
    Designing and Deploying Microsoft Exchange Server 2016
    Designing and Implementing a Server Infrastructure
    DevOps Certification Training
    Developing Microsoft Azure Solutions
    Developing Microsoft SharePoint® Server 2013
    Developing Microsoft SharePoint® Server 2013 Core Solutions
    Developing SQL Databases
    Enabling and Managing Microsoft Office 365
    Executive Program in Applied Finance
    Executive Program in Digital and Social Media Marketing Strategy
    Fundamentals of a Windows Server® Infrastructure
    GNIIT Foundation
    Getting Started with R for Data Science
    Getting started with Apache Solr Search Server
    IBM Cognos Connection and Workspace Advanced
    IT Service Management with System Center Service Manager
    Implementing Microsoft Azure Infrastructure Solutions
    Implementing Microsoft Azure Solutions-70-533
    Implementing a Data Warehouse with Microsoft® SQL Server® 2014
    Informatica PowerCenter 9.x Level 1
    Installing and Configuring Windows 10
    Installing and Configuring Windows Server® 2012
    Introducing Rails 5 Learning Web Development the Ruby Way
    Introduction to ITIL
    Introduction to SQL Databases
    Introduction to Web Development with Microsoft Visual Studio 2010
    Java Enterprise Apps with DevOps
    Joomla Certification Training Program
    Julia for Data Science
    Learning Android N Application Development
    Learning Data Mining with R
    Learning Joomla 3 Extension Development
    Learning MongoDB
    Learning R for Data Visualization
    Learning Spring Boot
    Learning Swift 2
    Linux shell scripting solution
    Machine Learning with Python
    Marketing Analytics Data Tools and Techniques
    Mastering Magento
    Open Source Web App Development using MEAN Stack
    PMI® Agile Certified Practitioner Training
    Pentaho Reporting
    Performance Tuning and Optimizing SQL Databases
    Planning and Deploying System Center 2012 Configuration Manager
    Post Graduate Certificate in General Management (PGCGM)
    Programming Using Python
    Programming in C Sharp
    Programming in HTML5 with JavaScript and CSS3
    Programming with Python for Data Sciences.
    Project Management Professional (PMP®) Training
    Querying Data with Transact SQL
    Querying Microsoft SQL Server® 2014
    R Data Mining Projects
    R for Data Science Solutions
    Reactive Java 9
    SAS Certification Training Program
    Secrets of Viral Video Marketing
    Selenium with Java
    Six Sigma Certification Training Program
    Spring Security
    Supply Chain Management(SCM) Training Program
    Supporting and Troubleshooting Windows 10
    Teradata Certification Training
    Test Driven Android
    UNIX Shell Scripting Training
    Upgrading Your Skills to MCSA Windows Server 2016
    Upgrading Your Skills to MCSA Windows Server® 2012
    Web Apps Development using Node.js along with Express.js and MongoDB
    Web Apps Development with HTML5, CSS3, jQuery & Bootstrap
    Web Development with Node.JS and MongoDB
    iOS App Development Certification Training
    jquery UI Development