The Knowledge Academy Logo
The Knowledge Academy Logo
+61 1-800-150644 - Available 24/7

Send us your message.

X

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

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
  • Our MCSA training courses are fully accredited by Microsoft using latest hardware and soft

Available delivery methods for this course

Classroom Icon

Classroom

Virtual Icon

Live Virtual

Online Icon

Online

Onsite Icon

In-house

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 $795
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

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
Adelaide
Mon 26th Aug 2019
Places available
$6899
Perth
Mon 9th Sep 2019
Places available
$6899
VirtualLive Virtual
Mon 16th Sep 2019
Places available
$5995
Brisbane
Mon 16th Sep 2019
Places available
$6899
Melbourne
Mon 23rd Sep 2019
Places available
$4989
Sydney
Mon 14th Oct 2019
Places available
$4989
Perth
Mon 21st Oct 2019
Places available
$6899
VirtualLive Virtual
Mon 28th Oct 2019
Places available
$5995
Canberra
Mon 28th Oct 2019
Places available
$4989
Brisbane
Mon 4th Nov 2019
Places available
$6899
VirtualLive Virtual
Mon 18th Nov 2019
Places available
$5995
Melbourne
Mon 18th Nov 2019
Places available
$4989
Sydney
Mon 2nd Dec 2019
Places available
$4989
VirtualLive Virtual
Mon 9th Dec 2019
Places available
$5995
Perth
Mon 9th Dec 2019
Places available
$6899
Adelaide
Mon 16th Dec 2019
Places available
$6899

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