Implementing a Data Warehouse with Microsoft SQL Server Training

7254 Learners

The training provides the proper knowledge to the candidate that allows them to validate data with SQL Server Data Quality Services and SQL Server Master Data Services. This course lays emphasis on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing. The training provides the skills required to Implement data cleansing by using Microsoft Data Quality Services and Implement Master Data Services to enforce data integrity.

Implementing a Data Warehouse with Microsoft SQL Server Course Objectives
  • Describe data warehouse concepts and architecture considerations.
  • Design and implement a data warehouse.
  • Select an appropriate hardware platform for a data warehouse.
  • Implement Data Flow and Control Flow in an SSIS Package.
  • Debug and Troubleshoot SSIS packages.
  • Implement an SSIS solution that supports incremental data warehouse loads and changing data.
Target audience
  • Business intelligence professionals
  • Database developers
  • SQL Server database administrators
  • System engineers
  • Database professionals who are involved in installation, configuration, and maintenance tasks
Prerequisites

To attend this training, the student should know how to write T-SQL Queries for Microsoft SQL Server .

Implementing a Data Warehouse with Microsoft SQL Server Course Certificate

To attend this training, the student should know how to write T-SQL Queries for Microsoft SQL Server .

The training provides the proper knowledge to the candidate that allows them to validate data with SQL Server Data Quality Services and SQL Server Master Data Services. This course lays emphasis on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing. The training provides the skills required to Implement data cleansing by using Microsoft Data Quality Services and Implement Master Data Services to enforce data integrity.

Implementing a Data Warehouse with Microsoft SQL Server Course Objectives
  • Describe data warehouse concepts and architecture considerations.
  • Design and implement a data warehouse.
  • Select an appropriate hardware platform for a data warehouse.
  • Implement Data Flow and Control Flow in an SSIS Package.
  • Debug and Troubleshoot SSIS packages.
  • Implement an SSIS solution that supports incremental data warehouse loads and changing data.
Target audience
  • Business intelligence professionals
  • Database developers
  • SQL Server database administrators
  • System engineers
  • Database professionals who are involved in installation, configuration, and maintenance tasks
Prerequisites

To attend this training, the student should know how to write T-SQL Queries for Microsoft SQL Server .

Implementing a Data Warehouse with Microsoft SQL Server Course Certificate

To attend this training, the student should know how to write T-SQL Queries for Microsoft SQL Server .

Introduction

  • Store information in a data warehouse
  • What you should know
  • Set up the example databases

1. Data Warehouse Foundations

  • Data warehouse core concepts
  • Transactional databases vs. data warehouses
  • Dimensions and facts
  • Star and snowflake schemas
  • Hardware and infrastructure

2. Create a Data Warehouse

  • Create a data warehouse in SQL Server
  • Design dimension tables
  • Design fact tables
  • Create an indexed view

3. Columnstore Indexes

  • Advantages of columnstore indexes
  • Memory-optimized columnstore table
  • Rebuild columnstore indexes

4. Implement an Azure SQL Data Warehouse

  • Hosting a data warehouse in the cloud
  • Create an Azure SQL Data Warehouse project
  • Develop tables in Azure SQL Data Warehouse
  • The Data Warehouse Migration Utility
  • Migrate a data warehouse to Azure
  • Pause and remove an Azure data warehouse

5. Extract, Transform, and Load (ETL)

  • What is ETL and SQL Server Integration Services (SSIS)?
  • Understand data flow
  • Establish control flow

6. Enforce Data Quality

  • SQL Server Data Quality Services (DQS)
  • Cleanse data with DQS
  • Create a custom knowledge base

7. Master Data Services

  • Introduction to Master Data Services (MDS)
  • Install MDS and IIS
  • Configure Master Data Services
  • Deploy a sample MDS model
  • Install the MDS Excel add-in
  • Update master data in Excel

8. Consume Data from the Warehouse

  • Business intelligence applications

Drop Us a Query

+91 95550 06479

Available 24x7 for your queries

Implementing a Data Warehouse with Microsoft SQL Server Corporate Training & Certification Progr

Employee training and development programs are essential to the success of businesses worldwide. With our best-in-class corporate trainings you can enhance employee productivity and increase efficiency of your organization. Created by global subject matter experts, we offer highest quality content that are tailored to match your company’s learning goals and budget.

Learn from the experts

Customized Training

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements of your workforce. You can even choose a trainer from our team of certified industry experts.

Learn from the experts

Expert Mentors

Get trained from our team of highly skilled and certified trainers, who are officially accredited professionals with relevant industry experience and adept in providing the knowledge and skills required to be successful.

Learn from the experts

360º Learning Solution

Engage your employees with our all-inclusive learning platform. Avail benefits of 24/7 access to the learning management system, industry-certified mentors, assessments & mock tests, real-time learning and more.

Learn from the experts

Learning Assessment

Check test score and performance with our skills analysis tools. Our detail scoreboard displays scores, areas of strength, detailed answer of questions and more for each employee.

Download Corporate Brochure

+91 9555006479

Available 24x7