MCSA SQL 2016 (Updated)

MCSA SQL 2016: Business Intelligence | Certificate on completion | Student discount card eligible | Accredited course



Save 95%
£49 inc VAT (was £999.99)
Offer ends 31 May 2020
Study method
Online, self-paced
120 Hours
Access to content
12 Months
MCSA: SQL 2016 Business Intelligence Development
Professional certification What's this?
Additional info
  • Tutor is available to students
  • TOTUM card is available to purchase separately What's this?

6 students purchased this course

Add to basket or enquire


What is the MCSA: SQL?

The Microsoft Certified Solutions Associate (MCSA) SQL is a prestigious, world recognised professional certification. It duly validates to potential hiring managers your essential skills and abilities in database development, data security administration, disaster prevention, backup recovery and building and implementing databases across organisations for both on site and cloud based databases.

To obtain the MCSA: SQL Business Intelligence certification, students are required to pass the two below MCP exams:

Microsoft 70-767: Implementing a Data Warehouse using SQL
Microsoft 70-768: Developing SQL Data Models

About the MCSA

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 technology specialisations. This certification bundle is ‘SQL 2016 Business intelligence geared.

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


MCSA: SQL 2016 Business Intelligence Development
Awarded by Microsoft

Course media


E-courses4you have designed the new MCSA SQL 2016 program to prepare you for today’s job roles in IT database development technologies. The program has two certifications that cover a broad range of fundamentals for IT careers, with two training courses designed to help you prepare. Newly retooled for the latest technologies and job roles, the MCSA SQL 2016 training course will give you the foundation you need to take your career in any direction. The MCSA SQL 2016 certification covers a breadth of topics, including:

Design a tubular BI sematic model

Design a query using multidemensional expressions (MDX) and data analysis expressions

Configure and maintain a SQL server analysis server

What jobs will I be qualified for?

Upon completing the collection you will be able to pursue a career in:

  • Database developer
  • Database analyst
  • Database administrator
  • IT Consultant

The average earnings for a MCSA SQL 2016 Certified indiviual is £48,500 per annum (source: ITjobswatch, UK Only).

How do I study?

You study online around your own schedule with our easy to use interactive student interface which is designed to make the learning experience as enjoyable as possible. Our content is delivered via a mixture of easy to follow video's, question and answer sections and interactive test prep. When in your account you will work from your own personalised learning platform, that will log and track your course progress.

Why choose us?

  • Study job spefic industry recognised courses
  • Student support
  • Job finder service
  • Progress reports
  • Exam booking support
  • Over 90% first time passrate
  • All UK students receive a TOTUM (NUS) student discount card
  • 14 day no quibble money back guarantee

Career Support

Every student has access to our soft skills training pack that includes career support courses such as Interviewing Techniques and C.V building. These courses will give you the skills you need to head into the job market and boost your employability.

On completion of your training course, you will have the skills and confidence to jump straight into a role that suits you.

Our careers advisors have their ears to the ground and are on hand to offer you industry and job specific advice on any career path you decide to follow and ask about our job search service we offer to our students.

Who is this course for?

Our MCSA SQL 2016 is for driven individuals that have a passion to learn and would like to gain knowledge of a wide range of areas of Business Intelligence.


No previous experience is required however if you have you have experience working with SQL Server as a Database Administrator or working knowledge of Microsoft Windows, Transact-SQL, and relational databases it is advisable.

Career path

Once you have completed your MCSA SQL 2016 you will have a globally acknowledged certification from Microsoft, and be able to unlock job opportunities all over the world Potential roles include;

Database Developer

Database Analyst

Infrastructure Engineer

Data Programmer

Data Security

Database Administrator

Support Technician

Data Centres Specialist

Questions and answers

No questions or answers found containing ''.

mitz asked:

At the end of the course what certificate will I get?


Hi Mitz, If you complete the course ware at or above 70% you will get an EC4U completion certificate which is included in the price. If you want to sit the external official MCP exam with Microsoft its around £130 and can be booked directly with the testing center. Thanks James.

This was helpful. Thank you for your feedback.


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


What does study method mean?

Study method describes the format in which the course will be delivered. At 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, 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.


Mobile Navigation