Microsoft SQL Server | Implementing a Data Warehouse

Course Introduction

Implementing a Data Warehouse with Microsoft SQL Server (M20463) course describes ways to implement a data warehouse platform for supporting BI solution to delegates. During this 5 day course, participants will learn creating a data warehouse, implement ETL using Microsoft SQL Server 2014. Additionally, validating and cleansing data with Microsoft SQL Server data quality services and SQL Server master data services will be included in the course.

Implementing a Data Warehouse with Microsoft SQL Server

Overview
Course Content

This training class describes how to implement a data warehouse platform to support a BI solution. Delegates will know how to develop 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.This training is meant for database delegates who need to create and support a data warehousing solution.

Course Content

Data warehousing overview

An introduction- Data warehousing
Data warehousing solution consideration
Explore data sources and ETL process
Explore data warehouse

Planning Data Warehouse Infrastructure

Data Warehouse infrastructure considerations
Hardware planning

Designing and Implementing a Data Warehouse

Design Overview of Data warehouse
Dimension tables designing
Design fact tables
Data warehouse physical design
Implement star schema and snowflake schema
Implement time dimension

Creating an ETL Solution with SSIS

ETL with SSIS Introduction
Data Sources exploration
Implement data flow
Data sources exploration
Transfer data by making use of Data Flow Task
Use Transformations in a Data Flow

Implementing Control Flow in an SSIS Package

Control Flow introduction
Dynamic Packages creation
Use containers
Consistency Management
Use Tasks and Precedence in Control Flow
Use Variables, Parameters and Containers
Use transactions and checkpoints

Debugging and Troubleshooting SSIS Packages

Debugging SSIS Package
Logging SSIS Package Events
Handle Errors in an SSIS Package
SSIS Package debugging
Logging SSIS Package Execution
Event Handler implementation
Handle errors in a Data Flow

Implementing a Data Extraction Solution

Data extraction planning
Modified data extraction
Using data time column and change date capture
Using CDC control task and change tracking

Loading Data into a Data Warehouse

Data tools planning
Using SSIS for incremental loads
Using Transact-SQL loading techniques
Data loading from CDC output tables
Using Lookup Transformation for Inserting or Updating Dimension Data
Implement a Slowly Changing Dimension
Using MERGE Statement

Enforcing Data Quality

Data Quality introduction
Use data quality services to cleanse Data
Create a DQS knowledge base
Making use of DQS Project to Cleanse Data
Using DQS in an SSIS Package

Master Data Services

Master Data Service’s introduction
Master Data Services Model implementation
Managing Master Data
Creating a Master Data Hub
Master Data Services Model creation
Using Master Data Services Add-in for Excel
Business Rules enforcing
Loading Data into a Model
Consuming Master Data Services Data

Extending SQL Server Integration Services

Using scripts in SSIS
Using Custom Components in SSIS

Deploying and Configuring SSIS Packages

SSIS Deployment Overview
SSIS projects deployment
SSIS catalogue creation
Running SSIS package in SQL Server Management Studio
Schedule SSIS Packages with SQL Server Agent

Consuming Data in a Data Warehouse

Business Intelligence Introduction
Exploring an Enterprise BI Solution
Exploring a Self-Service BI Solution

Note: Lab is provided for this course for participant’s hands on practice.

Prerequisites

Delegates prior taking the course must carry at least two years of experience working with relational databases which comprises:

Designing normalised database.
Create tables and its relationships.
Query using transacts SQL.
Some exposure of basic programming constructs (Such as looping, branching, etc.)
Knowledge of the main business points such as revenue, profitability and financial accounting can be beneficial.

Target Audience

Implementing a Data Warehouse with Microsoft SQL Server (M20463) is designed for database professionals who need to create as well as support data warehousing solutions.

Primary focus will be on learning the following responsibilities:

Implement data warehouse.
Using data quality service to cleanse data.
Using Master data services enforcing data integrity.
Develop SSIS package for extracting data, transformation and loading data.

Delegates Will Learn How To

Paticipants will be learning the following:

Ability to Describe data warehouse concepts and architecture.
Learning to select suitable hardware platform for the data warehouse.
Designing as well as implement data warehouse.
Implementing data flow and control flow in SSIS packages.
Debug as well as troubleshoot SSIS packages.
Implementing ETL solution which supports incremental data extraction and data loading.
Implementing master data services for promoting and implementing integrity.
Extending SSIS using custom scripts and components.
Configuring and Deploying SSIS packages.
Explaining how BI solutions can make use of data from the data warehouse.

Training Solutions at Your Convenience

Our objective has always been to address and resolve the problems of our learners in an efficient manner and improve their learning prospects. We are accustomed in providing training courses as per our learner’s convenience. We love every opportunity to use our experience to resolve difficulties confronted by learners.

Implementing a Data Warehouse with Microsoft SQL Server Training Calender

Filters

Explore Now

Choose Mode of Training

Classroom

Online Instructor-led

Online Self-Paced

Onsite

Implementing a Data Warehouse with Microsoft SQL Server

---- OR ----

Reach Us at +44 161 884 3134 or info@bestpracticetraining.com for more information.

Implementing a Data Warehouse with Microsoft SQL Server

---- OR ----

Reach Us at +44 161 884 3134 or info@bestpracticetraining.com for more information.

Implementing a Data Warehouse with Microsoft SQL Server

40 Hours (on average)

90 Days Access

40 Hours (on average)

Course Price

£2745
add-ons Price

£0
Sub-Total

£2745

Upon purchase you will receive a password via the email you used to purchase the course.

You will then be able to login to our online learning platform with your email and password.

You will have access to the platform for 90 days from the date of purchase.

ONSITE ENQUIRY?

Fill up the form below and we will get back to you!

Video Conferencing

We provide the best web conferencing platform(s) to facilitate our learners to enhance their communication with the instructor.

Digital Whiteboards

Our courses include the real-time demonstration of figures, diagrams and other interactive material through digital whiteboards.

Instant Messaging

During the Virtual Classroom session, learners can raise their queries through instant messaging and follow up on their doubts.

Participation Controls

Through participating effectively in training, individuals can easily discuss their views, mute their surroundings and virtually "raise" their hands.

Features of Our Virtual Classroom Courses

How to Choose and Attend Your Ideal Course?

FIND COURSES

We provide 400+ courses covering broader aspects of personal and professional development training needed by any individual. You can choose any course as per your need or requirement. Our courses are designed to fulfil the current organisational and job marketplace requirements.

Select the Course

Choose the course you want to attend to fulfil your desired goals.

Attend the Course

Attend the training with your prefered method at your convenience.

Get Certification

Upon finishing the course, you will get the completion certificate validating your learning.

Implementing a Data Warehouse with Microsoft SQL Server

£ 2745 £ 2695

Benefits of Attending Our Online Courses

We provide a variety of certification programmes or courses for individuals to master a skill set and pursue a full-time career in management, IT, or other domains through the online method to provide them with the convenience of learning. Our dedicated staff works tirelessly to assure the availability of courses with eminence quality that's not found anywhere with benefits like:

Learn a New Skill From Onsite Training

Adaptable Courses

We provide onsite courses modified according to our client's organisational needs.

Cost-Effective Learning

Onsite training helps you to reduce travelling and venue expenses.

Learn in Familiar Surroundings

Training at your convenient place can be ideal for learning new skills.

Team Building Opportunity

Attending onsite training with your team can help to improve your team dynamics tremendously.

Best Practice Training provides specially designed training courses in 410+ locations spanning over 30+ countries globally. All our locations have state of the art facilities for the learners. Some of the Popular Locations are: