• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
START DATE END DATE CLASS TIMINGS MODE LOCATION ACTION
10/29/2018 11/02/2018
  • VLT
Live Online
11/26/2018 11/30/2018
  • VLT
Live Online

20463: Implementing a Data Warehouse with Microsoft SQL Server 2014 Course Overview

20463: Implementing a Data Warehouse with Microsoft SQL Server 2014 course portrays how to actualize an information stockroom stage to help a BI arrangement. Understudies will figure out how to make an information distribution center with Microsoft® SQL Server® 2014, actualize ETL with SQL Server Integration Services, and approve and purge information with SQL Server Data Quality Services and SQL Server Master Data Services. 

Note: 20463: Implementing a Data Warehouse with Microsoft SQL Server 2014 course is intended for clients who are occupied with learning SQL Server 2012 or SQL Server 2014. It covers the new components in SQL Server 2014, yet in addition the vital abilities over the SQL Server information stage. 

20463: Implementing a Data Warehouse with Microsoft SQL Server 2014 Audience Profile 

20463: Implementing a Data Warehouse with Microsoft SQL Server 2014 course is planned for database experts who need to satisfy a Business Intelligence Developer part. They should concentrate on hands-on work making BI arrangements including Data Warehouse usage, ETL, and information purging. Essential duties include: 

  • Actualizing an information distribution center. 
  • Creating SSIS bundles for information extraction, change, and stacking. 
  • Upholding information respectability by utilizing Master Data Services. 
  • Purifying information by utilizing Data Quality Services. 

20463: Implementing a Data Warehouse with Microsoft SQL Server 2014 At Course Completion

In the wake of finishing this course, understudies will have the capacity to: 

  • Portray information distribution center ideas and engineering contemplations. 
  • Select a proper equipment stage for an information distribution center. 
  • Plan and execute an information distribution center. 
  • Actualize Data Flow in a SSIS Package. 
  • Actualize Control Flow in a SSIS Package. 
  • Investigate and Troubleshoot SSIS bundles. 
  • Actualize an ETL arrangement that backings incremental information extraction. 
  • Actualize an ETL arrangement that backings incremental information stacking. 
  • Actualize information purifying by utilizing Microsoft Data Quality Services. 
  • Actualize Master Data Services to uphold information honesty. 
  • Expand SSIS with custom contents and parts. 
  • Send and Configure SSIS bundles. 
  • Portray how BI arrangements can devour information from the information distribution center. 

20463: Implementing a Data Warehouse with Microsoft SQL Server 2014 Course Outline

1 - Introduction to Data Warehousing 

  • Outline of Data Warehousing 
  • Contemplations for a Data Warehouse Solution 
  • Lab : Exploring a Data Warehousing Solution 
  • Investigating Data Sources 
  • Investigating and ETL Process 
  • Investigating a Data Warehouse 

2 - Planning Data Warehouse Infrastructure 

  • Contemplations for Data Warehouse Infrastructure 
  • Arranging Data Warehouse Hardware 
  • Lab : Planning Data Warehouse Infrastructure 
  • Arranging Data Warehouse Hardware 

3 - Designing and Implementing a Data Warehouse 

  • Information Warehouse Design Overview 
  • Planning Dimension Tables 
  • Planning Fact Tables 
  • Physical Design for a Data Warehouse 
  • Lab : Implementing a Data Warehouse 
  • Actualize a Star Schema 
  • Actualize a Snowflake Schema 
  • Actualize a Time Dimension 

4 - Creating an ETL Solution with SSIS 

  • Prologue to ETL with SSIS 
  • Investigating Data Sources 
  • Actualizing Data Flow 
  • Lab : Implementing Data Flow in a SSIS Package 
  • Investigating Data Sources 
  • Exchanging Data by Using a Data Flow Task 
  • Utilizing Transformations in a Data Flow 

5 - Implementing Control Flow in a SSIS Package 

  • Prologue to Control Flow 
  • Making Dynamic Packages 
  • Utilizing Containers 
  • Overseeing Consistency 
  • Lab : Implementing Control Flow in a SSIS Package 
  • Utilizing Tasks and Precedence in a Control Flow 
  • Utilizing Variables and Parameters 
  • Utilizing Containers 
  • Lab : Using Transactions and Checkpoints 
  • Utilizing Transactions 
  • Utilizing Checkpoints 

6 - Debugging and Troubleshooting SSIS Packages 

  • Troubleshooting a SSIS Package 
  • Logging SSIS Package Events 
  • Taking care of Errors in a SSIS Package 
  • Lab : Debugging and Troubleshooting a SSIS Package 
  • Troubleshooting a SSIS Package 
  • Logging SSIS Package Execution 
  • Actualizing an Event Handler 
  • Taking care of Errors in a Data Flow 

7 - Implementing a Data Extraction Solution 

  • Arranging Data Extraction 
  • Removing Modified Data 
  • Lab : Extracting Modified Data 
  • Utilizing a Datetime Column 
  • Utilizing Change Data Capture 
  • Utilizing the CDC Control Task 
  • Utilizing Change Tracking 

8 - Loading Data into a Data Warehouse 

  • Arranging Data Loads 
  • Utilizing SSIS for Incremental Loads 
  • Utilizing Transact-SQL Loading Techniques 
  • Lab : Loading a Data Warehouse 
  • Stacking Data from CDC Output Tables 
  • Utilizing a Lookup Transformation to Insert or Update Dimension Data 
  • Actualizing a Slowly Changing Dimension 
  • Utilizing the MERGE Statement 

9 - Enforcing Data Quality 

  • Prologue to Data Quality 
  • Utilizing Data Quality Services to Cleanse Data 
  • Utilizing Data Quality Services to Cleanse Data 
  • Lab : Cleansing Data 
  • Making a DQS Knowledge Base 
  • Utilizing a DQS Project to Cleanse Data 
  • Utilizing DQS in a SSIS Package 

10 - Master Data Services 

  • Prologue to Master Data Services 
  • Actualizing a Master Data Services Model 
  • Overseeing Master Data 
  • Making a Master Data Hub 
  • Lab : Implementing Master Data Services 
  • Making a Master Data Services Model 
  • Utilizing the Master Data Services Add-in for Excel 
  • Authorizing Business Rules 
  • Stacking Data Into a Model 
  • Devouring Master Data Services Data 

11 - Extending SQL Server Integration Services 

  • Utilizing Scripts in SSIS 
  • Utilizing Custom Components in SSIS 
  • Lab : Using Custom Scripts 
  • Utilizing a Script Task 

12 - Deploying and Configuring SSIS Packages 

  • Review of SSIS Deployment 
  • Sending SSIS Projects 
  • Arranging SSIS Package Execution 
  • Lab : Deploying and Configuring SSIS Packages 
  • Making a SSIS Catalog 
  • Sending a SSIS Project 
  • Running a SSIS Package in SQL Server Management Studio 
  • Planning SSIS Packages with SQL Server Agent 

13 - Consuming Data in a Data Warehouse 

  • Prologue to Business Intelligence 
  • Undertaking Business Intelligence 
  • Self-Service BI and Big Data 
  • Lab : Using a Data Warehouse 
  • Investigating an Enterprise BI Solution 
  • Investigating a Self-Service BI Solution

20463: Implementing a Data Warehouse with Microsoft SQL Server 2014 course requires you meet the accompanying essentials: 

  • No less than 2 years' involvement of working with social databases, including: 
  • Outlining a standardized database. 
  • Making tables and connections. 
  • Questioning with Transact-SQL. 
  • Some presentation to fundamental programming builds, (for example, circling and stretching). 

A familiarity with key business needs, for example, income, productivity, and monetary bookkeeping is attractive.

Awards