The Knowledge Academy Logo
The Knowledge Academy Logo
+61 1-800-150644 - 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 - Australia

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

In-house

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 156 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
+61 1-800-150644

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
Mon 20th Apr 2020
Places available
$6495
Canberra
Mon 18th May 2020
Places available
$6695
Melbourne
Mon 18th May 2020
Places available
$6695
Perth
Mon 18th May 2020
Places available
$7595
Sydney
Mon 18th May 2020
Places available
$6695
Adelaide
Mon 18th May 2020
Places available
$7595
Brisbane
Mon 18th May 2020
Places available
$7595
Mon 18th May 2020
Places available
$6495
Mon 15th Jun 2020
Places available
$6495
Mon 13th Jul 2020
Places available
$6495
Canberra
Mon 20th Jul 2020
Places available
$6695
Melbourne
Mon 20th Jul 2020
Places available
$6695
Perth
Mon 20th Jul 2020
Places available
$7595
Sydney
Mon 20th Jul 2020
Places available
$6695
Adelaide
Mon 20th Jul 2020
Places available
$7595
Brisbane
Mon 20th Jul 2020
Places available
$7595
Mon 10th Aug 2020
Places available
$6495
Mon 14th Sep 2020
Places available
$6495
Brisbane
Mon 21st Sep 2020
Places available
$7595
Canberra
Mon 21st Sep 2020
Places available
$6695
Melbourne
Mon 21st Sep 2020
Places available
$6695
Perth
Mon 21st Sep 2020
Places available
$7595
Sydney
Mon 21st Sep 2020
Places available
$6695
Adelaide
Mon 21st Sep 2020
Places available
$7595
Mon 12th Oct 2020
Places available
$6495
Mon 9th Nov 2020
Places available
$6495
Brisbane
Mon 16th Nov 2020
Places available
$7595
Canberra
Mon 16th Nov 2020
Places available
$6695
Melbourne
Mon 16th Nov 2020
Places available
$6695
Perth
Mon 16th Nov 2020
Places available
$7595
Sydney
Mon 16th Nov 2020
Places available
$6695
Adelaide
Mon 16th Nov 2020
Places available
$7595
Mon 7th Dec 2020
Places available
$6495

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 156  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 Australia starts from $950
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