reed.co.uk Courses

Header

MCSA Certification Bundle With 2 Exams: SQL 2016 Business Intelligence Development

Includes 2 official Microsoft exams


Hudson

Summary

Price
£779 inc VAT
Payment options

Pay in 6 monthly installments.

Study method
Online, self-paced
Duration
100 Hours
Certification
MCSA: SQL 2016 Business Intelligence Development
Professional certification What's this?
Additional info
  • Exam(s) / assessment(s) is included in price

16 students enquired about this course

Add to basket or enquire

Enquire now

Overview

The Microsoft Certified Solutions Associate (MCSA) certification focuses on the ability to design and build technology solutions, which may include integrating multiple technology products, and span multiple versions of a single technology, whether on-premises or in the cloud.

An individual can choose to become a certified Associate in one or several Microsoft technologies. This certification bundle is ‘SQL 2016 Business Intelligence (BI) Development’ focused.

By gaining this MCSA certification you can prove your mastery of the primary set of SQL 2016 BI Development skills required to reduce IT costs and deliver more business value.

What will I learn?

  • Designing and implementing an effective data warehouse, including dimension tables, fact tables, indexes, storage, partitioning, and more
  • Establishing successful processes for extracting, transforming, and loading data (ETL) with SQL Server Integration Services (SSIS) and Transact-SQL (T-SQL).
  • Integrating solutions that encompass cloud data and big data, using Polybase Integrate, Hadoop Integrate, the Azure Blob service, and related tools.
  • Ensuring high levels of data quality with a Data Quality Services (DQS) knowledge base and a Master Data Services (MDS) model.
  • Design a multidimensional BI semantic model.
  • Design a tabular BI semantic model.
  • Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX).
  • Configure and maintain SSAS.

Certification

MCSA: SQL 2016 Business Intelligence Development
Awarded by Microsoft

Course media

Resources

  • View our training company brochure - download

Description

What’s included in this certification bundle?

This bundle contains two separate MCSA certification text books and two official Microsoft MCSA certification exams, all of which are valid for 12 months from the time of enrolment. As part of this bundle, you will get access to a MeasureUP practice test for each Microsoft certification course.

Certification courses included:

  1. Microsoft 70-767 Implementing a SQL Data Warehouse
  2. Microsoft 70-768 Developing SQL Data Models

***COMPLETE THE ENQUIRY FORM TO SEE THE COURSE SYLLABUS***

Certification exams included:

  1. Microsoft 70-768 Developing SQL Data Models
  2. Microsoft 70-768 Developing SQL Data Models


MeasureUP practice tests included:

  1. Microsoft 70-768 Developing SQL Data Models
  2. Microsoft 70-768 Developing SQL Data Models

How does this course bundle work?

This course bundle is made up of three main resources as shown below. Each certification course has as its own set of resources, i.e. 1 x text book, 1 x MeasureUP practice exam, 1 x official Microsoft exam. Each resource is designed to work in conjunction with each other to ensure the successful path to certification. You will complete one course and exam, then repeat the process for the remaining courses. Once you have passed the exams, you will receive an MCSA certification from Microsoft. Read below to learn more about the resources that make up this course.

Text Book


Each official Microsoft text book will be delivered to you by post. You will receive the first text book upon enrolling on the course and subsequent text books after completing the official exam for the course before. The text books are to be used in conjunction with the practice labs.



MeasureUP Practice Exams


After working your way through each text book and practice labs, you should be ready to start revising for your official exams. To do this, we provide you with MeasureUP practice tests. MeasureUP are the official provider to Microsoft for practice tests. These are the closest experience to the actual exam you’ll be taking. Scroll down to learn more about MeasureUP and the practice tests.

Official Microsoft Exams



Having confidently passed the practice tests, you will be ready to sit the official Microsoft exams – which we will book on your behalf. These are known as an ‘online, web-proctored exams’. This means they can be taken at home. One of the requirements of taking these exams is that you must have a web camera so a proctor can observe you during the exams. This is to ensure no cheating takes place.



How long will it take me to complete this course?

This course bundle comprises of text book material and practice test material. How soon you can complete the course is dependent on several factors such as the amount of time you can dedicate to the course each week, and how quickly you absorb information. Learners can complete a course within this bundle from anywhere between 30-60 days. Revision for each exam will take a minimum of 2 weeks. We recommend you spend at least 6 hours on the course per week to be able to finish it within 12 months or sooner. You can cut this duration in half or less by doubling the recommended study hours. You will have full access to the course material and resources for 12 months and must take your exams within this period.

Who is this course for?

Anyone looking to gain an MCSA SQL 2016 BI Development certification or advance their SQL 2016 BI Development skills.

Requirements

Your course can be done from any where in the world. If you decide to move to a different city or even country, you can continue with the course from wherever you are. All you need is a device such as a desktop computer, laptop, tablet, smart phone, and an internet connection.

Career path

  • MCSA SQL 2016 BI Development specialist
  • Business Intelligence Specialist
  • SQL 2016 Developer
  • SQL 2016 Database Analyst

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

What does study method mean?

Study method describes the format in which the course will be delivered. At reed.co.uk courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

What are CPD hours/points?

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on reed.co.uk, many of which can be completed online.

What is a ‘regulated qualification’?

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

What is an ‘endorsed’ course?

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body’s logo if they wish. Certain awarding bodies - such as ABC Awards and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.

Modals

Mobile Navigation