Study Mode: Part Time
Course Level: N/A
Data warehousing is a solution organizations use to centralize business data for reporting and analysis. This course focuses on teaching individuals how to create a data warehouse with SQL Server 2012/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. This course helps people prepare for exam 70-463.
This course is intended for database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing. Primary responsibilities include:
Implementing a data warehouse.
Developing SQL Server Integration Services (SSIS) packages for data extraction, transformation, and loading (ETL).
Enforcing data integrity by using Master Data Services.
Cleansing data by using Data Quality Services.
After completing this course, you 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 SSIS solution that supports incremental data warehouse loads and changing data.
- Integrate cloud data into a data warehouse ecosystem infrastructure.
- 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 information workers can consume data from the data warehouse.
- Troubleshoot SQL Server databases.
Please refer to the Microsoft exam preparation guide for details of objectives covered.
This 'Specialist' level course is part of the SQL Server 2012/2014 'Database Certification Track' from the Professional IT Training series delivered by the Microsoft IT Academy at Solihull College, Blossomfield campus.
Providing IT professional's access to the latest Microsoft certification courses with high quality, flexible learning systems.
The 'Professional IT Training' courses facilitate effective self-directed learning, with flexible start dates to meet your individual needs. This course is delivered in our Microsoft IT Academy workshop alongside students studying similar SQL database or BI courses.
This course includes hands-on practice labs in our Academy lab facility that assist students in becoming proficient in the skills needed to support the Microsoft technology.
The student resources include relevant comprehensive printed Microsoft Study Guide, Live Labs and e- learning materials.
Microsoft Imagine enables students to download Microsoft operating systems and applications to create and develop their own practice lab environments, for your academic use only. Conditions and systems requirements apply.
Tailored individual learning plans, with support and guidance from our experienced tutors.
This course is available to study in the evening, over 18 sessions. Learners may re-enrol on course to extend their period of study.
Vocational study not leading to a recognised academic qualification.
Students may elect to take the relevant Microsoft MCP exam to gain the Microsoft Certified Professional in Implementing a Data Warehouse with Microsoft SQL Server 2012 / 2014
Microsoft Certified Solutions Associate (MCSA): SQL Server
Microsoft Certified Solutions Expert (MCSE): Data Platform
Microsoft Certified Solutions Expert (MCSE): Business Intelligence
Certification requirements are is subject to change at any time without prior notice and at the sole discretion of Microsoft. Please refer to Microsoft certification site for current details.
The course includes assessments throughout the course with both practical and quiz exercises. Course certificates of completion are provided.
There is no formal examination required; however the Microsoft MCP 70-463 exam may be taken at an external Pearson VUE test centres. See Microsoft certification site for exam details and conditions.
Places are offered by interview, subject to meeting the entry requirements.
Learners must be over 19.
Before attending this course, learners must have completed the following courses, gained certification or have similar knowledge:
MCSA: 461 Querying Microsoft SQL Server 2012/2014
The number of job postings in the computing industry is growing so rapidly that there aren't enough qualified workers available to fill the positions.
Certifications give you a professional edge by providing globally recognised industry endorsed evidence of skills mastery, demonstrating your abilities and willingness to embrace new technologies.
How much will this course cost?
Tuition fee £ 550 ; Materials fee £ 50 ; Total £ 600
Is there anything else I will have to pay for in order to do this course?
Study material fees (£50) are payable on enrolment.
This course is not eligible for fee concession.
Learners may re-enrol on course to extend their period of study, tuition fee payable.
This course is intended for database professionals who need to fulfil a Business Intelligence Developer role.
Further Microsoft IT certification courses are available on the 'Database Certification Track' including implementing data warehousing, data models and reports and BI courses.
Course Fee (p.a)