Skip to content

Microsoft | MCSA: SQL Server with Live Labs (New Release)

Earn your MCSA certification and gain practical experience with Live Labs.


ITonlinelearning

Summary

Price
£995 inc VAT
Finance options

Finance options available

Study method
Online
Duration
12 months · Self-paced
Certification
MCSA: SQL Server 2012/2014 IT
Professional certification What's this?
Additional info
  • Exam(s) / assessment(s) not included in price, and must be purchased separately
  • Tutor is available to students

Overview

Buy the MCSA SQL Server 2012/2014 study package before the end of this month and get the new SQL 2012 BI courses free.

Is the MCSA SQL Server 2012/2014 suited to my career?

Gaining the MCSA SQL Server 2012/2014 will enable you to demonstrate your essential skills in developing and maintaining the next wave of mission critical environments. This will help you to will qualify you for a position as a database developer or data analyst.

The MCSA SQL Server 2012/2014 course consists of 3 exam courses:

  • 70-461: Querying Microsoft SQL Server 2012/2014
  • 70-462: Administering Microsoft SQL Server 2012/2014 Databases
  • 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

Internationally Recognised

In addition to teaching you the skills you need, the MCSA SQL 2012/2014 training package will confidently prepare you for your Microsoft exams. Upon passing your exams, you will have gained an internationally recognised certification.

Need Practical Experience?

We offer Live Labs as a bolt-on option so that you can practice on real live servers, routers and switches, no matter where you are studying from. You will be given unlimited access to the Labs for 1 year and can practice freely or follow set exercises that mimic the exam courses.

Live Labs are highly effective and offer an alternative that is cheaper than setting up your own test environment. These Labs are available for Microsoft (Server 2012/2014, Server 2008, SQL 2012/2014, SQL 2008, Windows 7, Windows 8), Cisco, VMWare and CompTIA courses (where relevant).

Here to help you

Our Course Advisors are available to answer any questions you have and can provide you with a free full access trial to properly evaluate the training that you will receive.

Certification

MCSA: SQL Server 2012/2014 IT

Awarded by Microsoft

Description

The MCSA SQL 2012/2014 consists of the following 3 exam courses:

70-461: Querying Microsoft SQL Server 2012/2014

  • Create database objects
  • Work with data
  • Modify data
  • Troubleshoot and optimise

70-462: Administering Microsoft SQL Server 2012/2014 Databases

  • Install and Configure
  • Maintain instances and databases
  • Optimise and troubleshoot
  • Manage data
  • Implement security
  • Implement high availability

70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

  • Design and implement a data warehouse
  • Extract and transform data
  • ServeLoad data
  • Configure and deploy SSIS solutions
  • Build data quality solutions

Who is this course for?

The new MCSA credential focuses on the ability to design and build technology solutions and is suited for anyone where SQL forms an important part of their role.

Requirements

There are no formal requirements to studying these courses.

Career path

  • Database Administrator
  • Database Developer
  • SQL Administrator
  • IT Trainer
  • IT Manager
  • Developer
  • Database Analyst

Questions and answers

Reviews

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

FAQs

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

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 Courses, many of which can be completed online.

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.

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 Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.