The Knowledge Academy Logo
The Knowledge Academy Logo
01344 203999 - Available 24/7

Send us your message.

X

Implementing A Data Warehouse With Microsoft SQL Server 2014 (M20463) - United Kingdom

Key points about this course


Duration: 5 Days*

Exam: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

Accredited: Yes

Support: 24/7

Dates & Prices Enquire
  • Microsoft MCSA training provided by the Largest Training Company Globally
  • GUARANTEED LOWEST PRICE IN THE INDUSTRY
  • Book Online or Call 01344 203 999 to speak to a Microsoft Training advisor

Available delivery methods for this course

Classroom Icon

Classroom

Virtual Icon

Live Virtual

Online Icon

Online

Onsite Icon

Onsite

Course Information

Implementing a Data Warehouse with Microsoft SQL Server Overview

This 5 day Implementing a Data Warehouse with Microsoft SQL Server training course provides delegates with the ability to implement data warehouse structures in order to support Business Intelligence solutions. Individuals will become familiar with the Microsoft SQL Server 2014 for the purposing of data warehouse construction, and will learn how to apply ETL with the SQL Server. As well as this, delegates will use SQL Server Data Quality Services and SQL Server Master Data Services to cleanse and verify information.

 

This training course is suitable for those who wish to learn about SQL Server 2012 or SQL Server 2014. The new features of the 2014 SQL Server are explored, as are the fundamental proficiencies of the overall SQL Server system. 

 

 

Implementing a Data Warehouse with Microsoft SQL Server Outline

Module 1: Introduction to Data Warehousing

  • Overview of Data Warehousing

  • Considerations for a Data Warehouse Solution

Lab: Exploring a Data Warehousing Solution

 

Module 2: Data Warehouse Hardware Considerations

  • Selecting hardware

  • Considerations for building a Data Warehouse

  • Data Warehouse Reference Architectures and Appliances

Lab: Planning Data Warehouse Infrastructure

 

Module 3: Designing and Implementing a Data Warehouse

  • Logical Design for a Data Warehouse

  • Physical design for a Data Warehouse

Lab: Implementing a Data Warehouse Schema

 

Module 4: Creating an ETL Solution with SSIS

  • Introduction to ETL with SSIS

  • Exploring Data Sources

  • Implementing Data Flow

Lab: Implementing Data Flow in an SSIS Package

 

Module 5: Implementing Control Flow in an SSIS Package

  • Introduction to Control Flow

  • Creating Dynamic Packages

  • Using Containers

  • Managing Consistency

Lab: Implementing Control Flow in an SSIS Package

Lab: Using Transactions and Checkpoints

 

Module 6: Debugging and Troubleshooting SSIS Packages

  • Debugging an SSIS Package

  • Logging SSIS Package Events

  • Handling Errors in an SSIS Package

Lab: Debugging and Troubleshooting an SSIS Package

 

Module 7: Implementing an Incremental ETL Process

  • Introduction to Incremental ETL

  • Extracting Modified Data

  • Loading Modified Data

Lab: Extracting Modified Data

Lab: Loading Incremental Changes

 

Module 8: Enforcing Data Quality

  • Introduction to Microsoft SQL Server Data Quality Services (DQS)

  • Using Data Quality Services to Cleanse Data

  • Using Data Quality Services to Match Data

Lab: Cleansing Data

Lab: De-duplicating data

 

Module 9: Using Master Data Services

  • Master Data Services Concepts

  • Implementing a Master Data Services Model

  • Managing Master Data

  • Creating a Master Data Hub

Lab: Implementing Master Data Services

 

Module 10: Extending SQL Server Integration Services

  • Using Scripts in SSIS

  • Using Custom Components in SSIS

Lab: Using Custom Components and Scripts

 

Module 11: Deploying and Configuring SSIS Packages

  • Overview of SSIS Deployment

  • Deploying SSIS Projects

  • Planning and Monitoring SSIS Package Execution

Lab: Deploying and Configuring SSIS Packages

 

Module 12: Consuming Data in a Data Warehouse

  • Introduction to Business Intelligence

  • Introduction to Reporting

  • An Introduction to Data Analysis

Lab: Using Business Intelligence Tools

Who should attend?

This training course is designed for database professionals who are looking to accomplish the role of a Business Intelligence Developer. Attendees should be familiar with generating Business Intelligence solutions such as Data Warehouse implementation and data cleansing. They should be accustomed with the advancement of SSIS packages for information extraction, conversion, and loading, and the administering of data integrity through the use of Master Data Services.

 

Prerequisites

Delegates must possess at least 2 years of relational database experience, specifically in:

  • Designing normalized databases

  • Constructing tables and relationships

  • Querying with Transact-SQL

  • Fundamental programming constructs

 

Understanding of business elements like profitability, revenue, and accounting would be useful, although this is not compulsory.

Yes, there is an exam for this training course, entitled Implementing a Data Warehouse with Microsoft SQL Server 2012/2014. The code for this exam is 70-463, and it is not included with the training course.
Implementing a Data Warehouse with Microsoft SQL Server is a 5 day training course.
This training course starts at 9am and finishes at 5pm each day. You should arrive at the venue by 8:45am.
Yes, we are accredited for this Microsoft training course.
The price for Implementing a Data Warehouse with Microsoft SQL Server 2014 (M20463) certification in the United Kingdom starts from £449
The Knowledge Academy is the Leading global training provider in the world for Implementing a Data Warehouse with Microsoft SQL Server 2014 (M20463).

Implementing a Data Warehouse with Microsoft SQL Server Examination

The Implementing a Data Warehouse with Microsoft SQL Server 2012/2014 70-463 exam is not included with this training course. Delegates will be able to sit this examination, which will cover the following topics:

  • Designing and Implementing a Data Warehouse

  • Extracting and Transforming Data

  • Loading Data

  • Configuring and Deploying SSIS Solutions

  • Building Data Quality Solutions

 

Delegates will need to sign a non-disclosure exam agreement, which confirms that they agree not to share information regarding the exam format with any other person.

Key points about this course


Duration: 5 Days*

Exam: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

Accredited: Yes

Support: 24/7

Dates & Prices Enquire

Upcoming classes

Implementing A Data Warehouse With Microsoft SQL Server 2014 (M20463) Dates & Prices

Select your preferred delivery method

Choose a Region

Choose a Location

Choose a Month

Office Icon Attend your course from the office or home
Trainers Icon Interactive support from experienced trainers
Simple Icon Simple to setup and easy to use on any device
Nottingham
Mon 21st Oct 2019
Places available
£4995
Manchester
Mon 21st Oct 2019
Places available
£2295
Cardiff
Mon 28th Oct 2019
Places available
£4995
Edinburgh
Mon 28th Oct 2019
Places available
£2995
Cambridge
Mon 4th Nov 2019
Places available
£4995
Reading
Mon 4th Nov 2019
Places available
£4995
Maidstone
Mon 4th Nov 2019
Places available
£4995
Milton Keynes
Mon 11th Nov 2019
Places available
£2995
Aberdeen
Mon 11th Nov 2019
Places available
£4995
Brighton
Mon 11th Nov 2019
Places available
£4995
Bristol
Mon 18th Nov 2019
Places available
£2295
Liverpool
Mon 18th Nov 2019
Places available
£4995
Dublin
Mon 18th Nov 2019
Places available
€3995
Mon 25th Nov 2019
Places available
£2295
Birmingham
Mon 25th Nov 2019
Places available
£2295
Belfast
Mon 25th Nov 2019
Places available
£4995
Newcastle
Mon 25th Nov 2019
Places available
£4995
Norwich
Mon 2nd Dec 2019
Places available
£4995
Leeds
Mon 2nd Dec 2019
Places available
£2295
Southampton
Mon 2nd Dec 2019
Places available
£4995
London
Mon 9th Dec 2019
Places available
£2295
Edinburgh
Mon 9th Dec 2019
Places available
£2995
Sheffield
Mon 9th Dec 2019
Places available
£4995
Glasgow
Mon 16th Dec 2019
Places available
£2995
Mon 16th Dec 2019
Places available
£2295
Nottingham
Mon 16th Dec 2019
Places available
£4995
Manchester
Mon 16th Dec 2019
Places available
£2295
Mon 6th Jan 2020
Places available
£2295
Leeds
Mon 20th Jan 2020
Places available
£4195
London
Mon 20th Jan 2020
Places available
£3695
Edinburgh
Mon 20th Jan 2020
Places available
£4195
Maidstone
Mon 20th Jan 2020
Places available
£4195
Bristol
Mon 20th Jan 2020
Places available
£4195
Liverpool
Mon 20th Jan 2020
Places available
£4195
Dublin
Mon 20th Jan 2020
Places available
€4195
Sheffield
Mon 20th Jan 2020
Places available
£4195
Glasgow
Mon 20th Jan 2020
Places available
£4195
Brighton
Mon 20th Jan 2020
Places available
£4195
Reading
Mon 20th Jan 2020
Places available
£4195
Manchester
Mon 20th Jan 2020
Places available
£3695
Nottingham
Mon 20th Jan 2020
Places available
£4195
Cambridge
Mon 20th Jan 2020
Places available
£4195
Aberdeen
Mon 20th Jan 2020
Places available
£4195
Cardiff
Mon 20th Jan 2020
Places available
£4195
Southampton
Mon 20th Jan 2020
Places available
£4195
Birmingham
Mon 20th Jan 2020
Places available
£3695
Newcastle
Mon 20th Jan 2020
Places available
£4195
Milton Keynes
Mon 20th Jan 2020
Places available
£4195
Norwich
Mon 20th Jan 2020
Places available
£4195
Belfast
Mon 20th Jan 2020
Places available
£4195
Mon 3rd Feb 2020
Places available
£2295
Mon 2nd Mar 2020
Places available
£2295
Dublin
Mon 16th Mar 2020
Places available
€4195
Sheffield
Mon 16th Mar 2020
Places available
£4195
Glasgow
Mon 16th Mar 2020
Places available
£4195
Brighton
Mon 16th Mar 2020
Places available
£4195
Reading
Mon 16th Mar 2020
Places available
£4195
Manchester
Mon 16th Mar 2020
Places available
£3695
Nottingham
Mon 16th Mar 2020
Places available
£4195
Cambridge
Mon 16th Mar 2020
Places available
£4195
Aberdeen
Mon 16th Mar 2020
Places available
£4195
Cardiff
Mon 16th Mar 2020
Places available
£4195
Southampton
Mon 16th Mar 2020
Places available
£4195
Birmingham
Mon 16th Mar 2020
Places available
£3695
Milton Keynes
Mon 16th Mar 2020
Places available
£4195
Newcastle
Mon 16th Mar 2020
Places available
£4195
Norwich
Mon 16th Mar 2020
Places available
£4195
Belfast
Mon 16th Mar 2020
Places available
£4195
Leeds
Mon 16th Mar 2020
Places available
£4195
London
Mon 16th Mar 2020
Places available
£3695
Edinburgh
Mon 16th Mar 2020
Places available
£4195
Maidstone
Mon 16th Mar 2020
Places available
£4195
Bristol
Mon 16th Mar 2020
Places available
£4195
Liverpool
Mon 16th Mar 2020
Places available
£4195
Mon 27th Apr 2020
Places available
£2295
Aberdeen
Mon 18th May 2020
Places available
£4195
Cardiff
Mon 18th May 2020
Places available
£4195
Southampton
Mon 18th May 2020
Places available
£4195
Birmingham
Mon 18th May 2020
Places available
£3695
Milton Keynes
Mon 18th May 2020
Places available
£4195
Newcastle
Mon 18th May 2020
Places available
£4195
Norwich
Mon 18th May 2020
Places available
£4195
Belfast
Mon 18th May 2020
Places available
£4195
Leeds
Mon 18th May 2020
Places available
£4195
Edinburgh
Mon 18th May 2020
Places available
£4195
London
Mon 18th May 2020
Places available
£3695
Mon 18th May 2020
Places available
£2295
Maidstone
Mon 18th May 2020
Places available
£4195
Bristol
Mon 18th May 2020
Places available
£4195
Liverpool
Mon 18th May 2020
Places available
£4195
Dublin
Mon 18th May 2020
Places available
€4195
Sheffield
Mon 18th May 2020
Places available
£4195
Glasgow
Mon 18th May 2020
Places available
£4195
Brighton
Mon 18th May 2020
Places available
£4195
Reading
Mon 18th May 2020
Places available
£4195
Manchester
Mon 18th May 2020
Places available
£3695
Nottingham
Mon 18th May 2020
Places available
£4195
Cambridge
Mon 18th May 2020
Places available
£4195
Mon 8th Jun 2020
Places available
£2295
Belfast
Mon 20th Jul 2020
Places available
£4195
Leeds
Mon 20th Jul 2020
Places available
£4195
Edinburgh
Mon 20th Jul 2020
Places available
£4195
London
Mon 20th Jul 2020
Places available
£3695
Maidstone
Mon 20th Jul 2020
Places available
£4195
Bristol
Mon 20th Jul 2020
Places available
£4195
Liverpool
Mon 20th Jul 2020
Places available
£4195
Dublin
Mon 20th Jul 2020
Places available
€4195
Sheffield
Mon 20th Jul 2020
Places available
£4195
Glasgow
Mon 20th Jul 2020
Places available
£4195
Brighton
Mon 20th Jul 2020
Places available
£4195
Reading
Mon 20th Jul 2020
Places available
£4195
Manchester
Mon 20th Jul 2020
Places available
£3695
Nottingham
Mon 20th Jul 2020
Places available
£4195
Cambridge
Mon 20th Jul 2020
Places available
£4195
Aberdeen
Mon 20th Jul 2020
Places available
£4195
Cardiff
Mon 20th Jul 2020
Places available
£4195
Southampton
Mon 20th Jul 2020
Places available
£4195
Birmingham
Mon 20th Jul 2020
Places available
£3695
Milton Keynes
Mon 20th Jul 2020
Places available
£4195
Newcastle
Mon 20th Jul 2020
Places available
£4195
Mon 20th Jul 2020
Places available
£2295
Norwich
Mon 20th Jul 2020
Places available
£4195
Mon 17th Aug 2020
Places available
£2295
Mon 14th Sep 2020
Places available
£2295
Bristol
Mon 21st Sep 2020
Places available
£4195
Dublin
Mon 21st Sep 2020
Places available
€4195
Sheffield
Mon 21st Sep 2020
Places available
£4195
Glasgow
Mon 21st Sep 2020
Places available
£4195
Brighton
Mon 21st Sep 2020
Places available
£4195
Reading
Mon 21st Sep 2020
Places available
£4195
Manchester
Mon 21st Sep 2020
Places available
£3695
Nottingham
Mon 21st Sep 2020
Places available
£4195
Cambridge
Mon 21st Sep 2020
Places available
£4195
Aberdeen
Mon 21st Sep 2020
Places available
£4195
Cardiff
Mon 21st Sep 2020
Places available
£4195
Southampton
Mon 21st Sep 2020
Places available
£4195
Birmingham
Mon 21st Sep 2020
Places available
£3695
Milton Keynes
Mon 21st Sep 2020
Places available
£4195
Newcastle
Mon 21st Sep 2020
Places available
£4195
Norwich
Mon 21st Sep 2020
Places available
£4195
Belfast
Mon 21st Sep 2020
Places available
£4195
Leeds
Mon 21st Sep 2020
Places available
£4195
Edinburgh
Mon 21st Sep 2020
Places available
£4195
London
Mon 21st Sep 2020
Places available
£3695
Maidstone
Mon 21st Sep 2020
Places available
£4195
Liverpool
Mon 21st Sep 2020
Places available
£4195
Mon 12th Oct 2020
Places available
£2295
Manchester
Mon 16th Nov 2020
Places available
£3695
Nottingham
Mon 16th Nov 2020
Places available
£4195
Brighton
Mon 16th Nov 2020
Places available
£4195
Cambridge
Mon 16th Nov 2020
Places available
£4195
Aberdeen
Mon 16th Nov 2020
Places available
£4195
Cardiff
Mon 16th Nov 2020
Places available
£4195
Southampton
Mon 16th Nov 2020
Places available
£4195
Birmingham
Mon 16th Nov 2020
Places available
£3695
Milton Keynes
Mon 16th Nov 2020
Places available
£4195
Newcastle
Mon 16th Nov 2020
Places available
£4195
Norwich
Mon 16th Nov 2020
Places available
£4195
Belfast
Mon 16th Nov 2020
Places available
£4195
Leeds
Mon 16th Nov 2020
Places available
£4195
Edinburgh
Mon 16th Nov 2020
Places available
£4195
London
Mon 16th Nov 2020
Places available
£3695
Maidstone
Mon 16th Nov 2020
Places available
£4195
Liverpool
Mon 16th Nov 2020
Places available
£4195
Bristol
Mon 16th Nov 2020
Places available
£4195
Dublin
Mon 16th Nov 2020
Places available
€4195
Sheffield
Mon 16th Nov 2020
Places available
£4195
Glasgow
Mon 16th Nov 2020
Places available
£4195
Reading
Mon 16th Nov 2020
Places available
£4195
Mon 23rd Nov 2020
Places available
£2295
Mon 14th Dec 2020
Places available
£2295

Complete the steps below to receive a quote or more information

How will you be funding your training?

Self funding

Company funding

Not sure

Key points about this course


Duration: 5 Days*

Exam: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

Accredited: Yes

Support: 24/7


Why choose TKA logo


Gold Tag

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

Trusted Icon

Trusted & Approved

Microsoft Silver Learning Partner

Delivery Icon

Various delivery methods

Flexible delivery methods are available depending on your learning style.

Resource Icon

Resources

Resources are included for a comprehensive learning experience.

Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

Google Logo
Samsung Logo
Shell Logo

"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."

Diane Gray, Shell