reed.co.uk Courses

Header

MCSA SQL Server 2016 Database Administration (Official Exams Included)

Online or Classroom based course with study materials, tutor support and final exam included


Robust IT Ltd

Summary

Price
£1,300 inc VAT
Payment options

over 3 month

Study method
Online, self-paced
Duration
150 Hours
Access to content
12 Months
Certification
MCSA: SQL 2016 Database Administration
Professional certification What's this?
Additional info
  • Tutor is available to students

24 students enquired about this course

Overview

This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.

Certification

MCSA: SQL 2016 Database Administration
Awarded by Microsoft

Description

Overview of this MCSA SQL 2016 Database Administration CourseWhat you will learn

This internationally recognised certification from IT giants Microsoft, will teach you to provision a Microsoft SQL Server 2016 database. This includes the new and migratory installation, maintenance and configuration of SQL Server 2016 databases both on-premises and in Microsoft Azure.

This certification serves as a prerequisite to the MCSE: Data Management and Analytics qualification, giving you the opportunity to further your career by becoming a Microsoft Certified Solutions Expert.

Validate your skills

During the MCSA: SQL 2016 Database Administration course, you will learn the following:

  • Upgrade SQL Server
  • Provision a database server
  • Configure data access and auditing
  • Manage and monitor SQL Server instances
  • Provision, migrate and manage databases in the cloud
  • Configure SQL Server
  • Manage databases and files
  • Manage backup and restore of databases
  • Manage high availability and disaster recovery

Course Certification DetailsMCSA SQL 2016 Database Administration Course Assessment

To gain the MCSA: SQL 2016 Database Administration qualification the following exams must be passed:

  • Exam 70-764: Administering a SQL Database Infrastructure
  • Exam 70-765: Provisioning SQL Databases

Who is this course for?

This exam is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience or MTA database fundamentals, who are seeking to validate their skills and knowledge in writing queries.

Requirements

This exam is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience or MTA database fundamentals, who are seeking to validate their skills and knowledge in writing queries.

Career path

The online SQL 2016 Database Administration course is suited to anyone looking to work in any of the following roles:

  • Database Administrator
  • Database Analyst
  • Database Engineer
  • Database Consultant

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