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

Remember: All of our classroom courses are available as live instructor-led training which you can attend from home.

Remember: All of our classroom courses are available as live instructor-led training which you can attend from home.

Send us your message.

X

Send us your message.

X

Our sales and enquiry team will get back to you as soon as possible

Please enter Name Please enter valid Email Please enter valid Phone number Please enter course

The information you provide shall be processed by The Knowledge Academy – a professional training company. Your data shall be used by a member of staff to contact you regarding your enquiry.

Please click here for privacy policy.

We cannot process your enquiry without contacting you, please tick to confirm you consent to us contacting you about your enquiry

Send us your message.

X

Our sales and enquiry team will get back to you as soon as possible

Please enter Name Please enter valid Email Please enter valid Phone number

The information you provide shall be processed by The Knowledge Academy – a professional training company. Your data shall be used by a member of staff to contact you regarding your enquiry.

Please click here for privacy policy.

We cannot process your enquiry without contacting you, please tick to confirm you consent to us contacting you about your enquiry

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

Key points about this course


Duration: 5 Days*

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

Virtual Icon

Online Instructor-Led

Online Icon

Online Self-Paced

Onsite Icon

Onsite

Classroom Icon

Classroom

Limited Budget?

We understand that people may have limited budgets.

  • To help and support our clients we will provide limited number of 250 daily discount codes.
  • Hurry first come, first served!
  • If you miss out, enquire to get yourself on the waiting list for the next day!

animated-arrow-image-0310 Enquire for daily discount code 47 Remaining (Live Counter)

Why Home Virtual is great

With an incredibly easy to use interface, our chosen platform has been designed to make learning online simple and enjoyable. It’s amazing video & audio quality means you won’t miss a thing.

icon

Works on all devices

Attend on whichever device works best for you.
icon

Recording & transcripts

Revisit what you’ve learnt at any time.
icon

See your trainer’s screen

Your instructor can share their screen at any time to demonstrate what they’re teaching.
icon

Share documents

You can share documents with the trainer and your trainer can share with you.
icon

Virtual whiteboard

Trainers can draw on and share their whiteboard with the class at any time.
static

Key points about this course


Duration: 5 Days*

Accredited: Yes

Support: 24/7

View dates & prices

Find out more

Please enter Name
Please enter valid Email
Please enter valid phone
The information you provide shall be processed by The Knowledge Academy – a professional training company. Your data shall be used by a member of staff to contact you regarding your enquiry. View privacy policy

We cannot process your enquiry without contacting you, please tick to confirm you consent to us contacting you about your enquiry

Or call us now
01344 203999

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 All Online Instructor-Led courses are delivered in real-time
Trainers Icon Easy 1 click access
Simple Icon Works on all devices
Glasgow
Mon 20th Apr 2020
Places available
£3995
Dublin
Mon 20th Apr 2020
Places available
€3995
Brighton
Mon 20th Apr 2020
Places available
£3995
Birmingham
Mon 20th Apr 2020
Places available
£2995
Leeds
Mon 20th Apr 2020
Places available
£3995
Southampton
Mon 20th Apr 2020
Places available
£3995
Maidstone
Mon 20th Apr 2020
Places available
£3995
Nottingham
Mon 27th Apr 2020
Places available
£3995
Bristol
Mon 27th Apr 2020
Places available
£3995
Mon 27th Apr 2020
Places available
£2295
London
Mon 27th Apr 2020
Places available
£2995
Edinburgh
Mon 27th Apr 2020
Places available
£3995
Belfast
Mon 27th Apr 2020
Places available
£3995
Milton Keynes
Mon 27th Apr 2020
Places available
£3995
Manchester
Mon 27th Apr 2020
Places available
£2995
Liverpool
Mon 27th Apr 2020
Places available
£3995
Sheffield
Mon 11th May 2020
Places available
£3995
Birmingham
Mon 11th May 2020
Places available
£2995
Leeds
Mon 11th May 2020
Places available
£3995
Cambridge
Mon 11th May 2020
Places available
£3995
Newcastle
Mon 11th May 2020
Places available
£3995
Glasgow
Mon 11th May 2020
Places available
£3995
London
Mon 18th May 2020
Places available
£2995
Edinburgh
Mon 18th May 2020
Places available
£3995
Reading
Mon 18th May 2020
Places available
£3995
Cardiff
Mon 18th May 2020
Places available
£3995
Norwich
Mon 18th May 2020
Places available
£3995
Manchester
Mon 18th May 2020
Places available
£2995
Aberdeen
Mon 18th May 2020
Places available
£3995
Bristol
Mon 18th May 2020
Places available
£3995
Mon 18th May 2020
Places available
£2295
Birmingham
Mon 1st Jun 2020
Places available
£2995
Maidstone
Mon 1st Jun 2020
Places available
£3995
Edinburgh
Mon 1st Jun 2020
Places available
£3995
Southampton
Mon 8th Jun 2020
Places available
£3995
Liverpool
Mon 8th Jun 2020
Places available
£3995
Mon 8th Jun 2020
Places available
£2295
London
Mon 8th Jun 2020
Places available
£2995
Dublin
Mon 15th Jun 2020
Places available
€3995
Manchester
Mon 15th Jun 2020
Places available
£2995
Milton Keynes
Mon 15th Jun 2020
Places available
£3995
Leeds
Mon 22nd Jun 2020
Places available
£3995
Belfast
Mon 22nd Jun 2020
Places available
£3995
Nottingham
Mon 22nd Jun 2020
Places available
£3995
Brighton
Mon 29th Jun 2020
Places available
£3995
Bristol
Mon 29th Jun 2020
Places available
£3995
Glasgow
Mon 29th Jun 2020
Places available
£3995
Sheffield
Mon 6th Jul 2020
Places available
£3995
Newcastle
Mon 6th Jul 2020
Places available
£3995
Edinburgh
Mon 6th Jul 2020
Places available
£3995
Birmingham
Mon 6th Jul 2020
Places available
£2995
Reading
Mon 13th Jul 2020
Places available
£3995
Norwich
Mon 13th Jul 2020
Places available
£3995
Leeds
Mon 13th Jul 2020
Places available
£3995
Glasgow
Mon 20th Jul 2020
Places available
£3995
Manchester
Mon 20th Jul 2020
Places available
£2995
Cardiff
Mon 20th Jul 2020
Places available
£3995
Mon 20th Jul 2020
Places available
£2295
Cambridge
Mon 27th Jul 2020
Places available
£3995
Bristol
Mon 27th Jul 2020
Places available
£3995
Aberdeen
Mon 27th Jul 2020
Places available
£3995
London
Mon 27th Jul 2020
Places available
£2995
Belfast
Mon 3rd Aug 2020
Places available
£3995
Nottingham
Mon 3rd Aug 2020
Places available
£3995
Birmingham
Mon 3rd Aug 2020
Places available
£2995
Glasgow
Mon 3rd Aug 2020
Places available
£3995
Milton Keynes
Mon 10th Aug 2020
Places available
£3995
Liverpool
Mon 10th Aug 2020
Places available
£3995
Maidstone
Mon 10th Aug 2020
Places available
£3995
Leeds
Mon 10th Aug 2020
Places available
£3995
Southampton
Mon 17th Aug 2020
Places available
£3995
Mon 17th Aug 2020
Places available
£2295
Edinburgh
Mon 17th Aug 2020
Places available
£3995
Dublin
Mon 17th Aug 2020
Places available
€3995
Manchester
Mon 17th Aug 2020
Places available
£2995
Bristol
Mon 24th Aug 2020
Places available
£3995
London
Mon 24th Aug 2020
Places available
£2995
Brighton
Mon 24th Aug 2020
Places available
£3995
Norwich
Mon 7th Sep 2020
Places available
£3995
Newcastle
Mon 7th Sep 2020
Places available
£3995
Bristol
Mon 7th Sep 2020
Places available
£3995
Edinburgh
Mon 14th Sep 2020
Places available
£3995
Glasgow
Mon 14th Sep 2020
Places available
£3995
Manchester
Mon 14th Sep 2020
Places available
£2995
Mon 14th Sep 2020
Places available
£2295
Birmingham
Mon 21st Sep 2020
Places available
£2995
Leeds
Mon 21st Sep 2020
Places available
£3995
Sheffield
Mon 21st Sep 2020
Places available
£3995
Cardiff
Mon 21st Sep 2020
Places available
£3995
London
Mon 28th Sep 2020
Places available
£2995
Cambridge
Mon 28th Sep 2020
Places available
£3995
Aberdeen
Mon 28th Sep 2020
Places available
£3995
Reading
Mon 28th Sep 2020
Places available
£3995
Maidstone
Mon 5th Oct 2020
Places available
£3995
Glasgow
Mon 5th Oct 2020
Places available
£3995
Manchester
Mon 5th Oct 2020
Places available
£2995
Southampton
Mon 5th Oct 2020
Places available
£3995
Liverpool
Mon 12th Oct 2020
Places available
£3995
Leeds
Mon 12th Oct 2020
Places available
£3995
Nottingham
Mon 12th Oct 2020
Places available
£3995
Mon 12th Oct 2020
Places available
£2295
Dublin
Mon 19th Oct 2020
Places available
€3995
Bristol
Mon 19th Oct 2020
Places available
£3995
Edinburgh
Mon 19th Oct 2020
Places available
£3995
London
Mon 19th Oct 2020
Places available
£2995
Birmingham
Mon 26th Oct 2020
Places available
£2995
Brighton
Mon 26th Oct 2020
Places available
£3995
Belfast
Mon 26th Oct 2020
Places available
£3995
Milton Keynes
Mon 26th Oct 2020
Places available
£3995
Edinburgh
Mon 2nd Nov 2020
Places available
£3995
Cardiff
Mon 2nd Nov 2020
Places available
£3995
Bristol
Mon 9th Nov 2020
Places available
£3995
Norwich
Mon 9th Nov 2020
Places available
£3995
Leeds
Mon 9th Nov 2020
Places available
£3995
Sheffield
Mon 16th Nov 2020
Places available
£3995
London
Mon 16th Nov 2020
Places available
£2995
Reading
Mon 16th Nov 2020
Places available
£3995
Glasgow
Mon 23rd Nov 2020
Places available
£3995
Manchester
Mon 23rd Nov 2020
Places available
£2995
Mon 23rd Nov 2020
Places available
£2295
Cambridge
Mon 23rd Nov 2020
Places available
£3995
Birmingham
Mon 30th Nov 2020
Places available
£2995
Aberdeen
Mon 30th Nov 2020
Places available
£3995
Newcastle
Mon 30th Nov 2020
Places available
£3995
Nottingham
Mon 7th Dec 2020
Places available
£3995
Edinburgh
Mon 7th Dec 2020
Places available
£3995
London
Mon 7th Dec 2020
Places available
£2995
Belfast
Mon 7th Dec 2020
Places available
£3995
Milton Keynes
Mon 7th Dec 2020
Places available
£3995
Liverpool
Mon 7th Dec 2020
Places available
£3995
Manchester
Mon 7th Dec 2020
Places available
£2995
Bristol
Mon 7th Dec 2020
Places available
£3995
Mon 14th Dec 2020
Places available
£2295
Dublin
Mon 14th Dec 2020
Places available
€3995
Brighton
Mon 14th Dec 2020
Places available
£3995
Birmingham
Mon 14th Dec 2020
Places available
£2995
Leeds
Mon 14th Dec 2020
Places available
£3995
Southampton
Mon 14th Dec 2020
Places available
£3995
Glasgow
Mon 14th Dec 2020
Places available
£3995
Maidstone
Mon 14th Dec 2020
Places available
£3995

Complete the steps below to receive a quote or more information

How will you be funding your training?

Self funding

Company funding

Not sure

Limited Budget?

We understand that people may have limited budgets.

  • To help and support our clients we will provide limited number of 250 daily discount codes.
  • Hurry, they’re are first come, first served!
  • If you miss out, enquire to get yourself on the waiting list for the next day!

  Enquire for daily discount code 47  Remaining (Live Counter)

Key points about this course


Duration: 5 Days*

Accredited: Yes

Support: 24/7


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 £500
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.

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

hsbc-logo
mercedes-logo