Managed Business & IT Training Solutions

MBIT Training Ltd

New Products

Free event - CompTIA Security+ primer

MBIT Training Ltd are pleased to offer a 'CompTIA Security+ primer'. This event features s...
£0.00 (GBP)

Implementing and Managing Windows 10 (20697-1 part of MCSA Windows 10)

This course provides students with the knowledge and skills required to install and config...
£1,950.00 (GBP)

Course: Supporting and Troubleshooting Windows 10 (10982)

This course is designed to provide students with the knowledge and skills required to supp...
£1,950.00 (GBP)

Introduction to Oracle 12c PL/SQL Programming

A Relational Database Management System (RDBMS) is a software system that allows you to cr...
£1,690.00 (GBP) £1,200.00 (GBP)

Oracle 11g Database Administration

This class will develop the key fundamental skills necessary to be an Oracle® DBA. Student...
£2,990.00 (GBP) £2,000.00 (GBP)

Microsoft Security Development Lifecycle (SDL)

The Security Development Lifecycle (SDL) is a software development process that helps deve...
£1,150.00 (GBP) £900.00 (GBP)

ITIL Foundation Certification - IT Service Management

The Information Technology Infrastructure Library (ITIL), is a set of detailed practices f...
£1,995.00 (GBP) £1,570.00 (GBP)

Course: Querying Microsoft SQL Server® 2014 (20461) part of MCSA SQL Server 2012 / 2014

This 5-day instructor led course provides students with the technical skills required to w...
£1,690.00 (GBP)

Course: Core Solutions of Skype for Business 2015 (20334 part of MCSE Communication)

This course provides students with the knowledge and skills that are required to plan, dep...
£1,790.00 (GBP)

Designing and Deploying Microsoft Exchange Server 2016 (20345-2 part of MCSE Messaging)

This course provides experienced Exchange Server administrators with the knowledge to desi...
£1,690.00 (GBP)

Administering Microsoft Exchange Server 2016 (20345-1 part of MCSE Messaging)

This 5-day instructor-led course teaches IT professionals how to administer and support Ex...
£1,690.00 (GBP)

Enabling and Managing Office 365 (20347 part of MCSA Office 365)

This is a 5-day instructor-led training (ILT) course that targets the needs of IT professi...
£1,990.00 (GBP) £1,690.00 (GBP)

Course: Developing SQL Data Models (20768 part of MCSA SQL 2016 BI)

This three-day instructor-led course is aimed at database professionals who fulfil a Busin...
£1,950.00 (GBP) £995.00 (GBP)

Course: Implementing a SQL Data Warehouse (20767 part of MCSA SQL 2016 BI)

This 5-day instructor led course describes how to implement a data warehouse platform to s...
£1,950.00 (GBP) £1,790.00 (GBP)

Course: Administering a SQL Database Infrastructure (20764 part of MCSA SQL 2016 DA)

This five-day instructor-led course provides students who administer and maintain SQL Serv...
£1,950.00 (GBP) £1,790.00 (GBP)

Course: Provisioning SQL Databases (20765 part of MCSA SQL 2016 DA)

This five day course is designed to teach students how to provision SQL Server databases b...
£1,950.00 (GBP)

Course: Developing SQL Databases (20762 part of MCSA SQL 2016)

This four-day instructor-led course provides students with the knowledge and skills to dev...
£1,950.00 (GBP) £1,290.00 (GBP)

Course: Querying Microsoft SQL Server (20761 part of MCSA SQL 2016)

The main purpose of this 3 day instructor led course is to give students a good understan...
£1,950.00 (GBP) £995.00 (GBP)

Identity with Windows Server 2016 (20742 part of MCSA Windows Server 2016)

This five-day instructor-led course teaches IT Pros how to deploy and configure Active Dir...
£1,790.00 (GBP)

Networking with Windows Server 2016 (20741 part of MCSA Windows Server 2016)

This 5-day classroom-based course provides the fundamental networking skills required to d...
£1,790.00 (GBP)

Installation, Storage, and Compute with Windows Server 2016 (20740 part of MCSA Windows Server 2016)

This five-day course is designed primarily for IT professionals who have some experience w...
£1,790.00 (GBP)

MCSA: Windows Server 2012

MCSA: Windows Server 2012 certification qualifies you for a position as a network or compu...
£3,275.00 (GBP) £2,695.00 (GBP)

Course: Automating Administration with Windows PowerShell (10961)

In this five day course you will learn to execute and monitor scripts more efficiently thr...
£1,550.00 (GBP)

Course: Automating Administration with Windows PowerShell 2.0 (10325)

This course 'Automating Administration with Windows PowerShell 2.0' provides students with...
£1,550.00 (GBP)

Course: Implementing a Data Warehouse with Microsoft SQL Server (20463)

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create 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.
SKU: 20463
GTIN: 20463
Manufacturer: Microsoft
*

Please select your required training start date:

*

Please select your desired location

£1,850.00 (GBP)

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create 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.

Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014, but also the important capabilities across the SQL Server data platform.
Audience Profile:
This course is intended for database professionals who need to create and support a data warehousing solution.

At Course Completion:

After completing this course, students will be able to:

  • Describe data warehouse concepts and architecture considerations.
  • Select an appropriate hardware platform for a data warehouse.
  • Design and implement a data warehouse.
  • Implement Data Flow in an SSIS Package.
  • Implement Control Flow in an SSIS Package.
  • Debug and Troubleshoot SSIS packages.
  • Implement an ETL solution that supports incremental data extraction.
  • Implement an ETL solution that supports incremental data loading.
  • Implement data cleansing by using Microsoft Data Quality Services.
  • Implement Master Data Services to enforce data integrity.
  • Extend SSIS with custom scripts and components.
  • Deploy and Configure SSIS packages.
  • Describe how BI solutions can consume data from the data warehouse.

(cited from Microsoft Learning website)