MCSA: SQL Server 2016 Database Administration

London Training Group Ltd
Course summary
4 Weeks or Fast Track 4 Days
1,200 GBP excl. VAT
Professional Training

Course description

MCSA: SQL Server 2016 Database Administration

Get trained in Microsoft Certified Solutions Associate (MCSA) Certification - SQL Server 2016 and gain the essential skills needed in all aspects of the Microsoft's premier database system – suitable for all sizes of businesses. MCSA SQL Server 2016 will enable you to establish your technical skills required to build a sustainable career in IT. Be equipped with the skills that would facilitate you to demonstrate the ability to provide innovative solutions across multiple technologies to your clients. By achieving MCSA SQL 2016 certification you will quite simply be an expert in database technology and can provide solutions for complex business environments.

Microsoft SQL Server has become the most popular, secure, reliable and robust database platform in the IT industry currently. On achieving SQL Server 2016 certification, you will maximise your chances of becoming more employable and more marketable in the current competitive IT job market. SQL Server 2016 can perform 1 million commands in just 1 second which makes it the fastest, reliable and robust solution for small to large enterprises. SQL Server 2016 also provides higher productivity for DBAs, System Admins and Application Developers. It is also capable to avoid mission critical outages or data loss and the Excellent BI and reporting tools, large scale data warehousing capabilities, make SQL Server 2016 stands out in the market.

Suitability - Who should attend?

This course is suitable for all levels. 

Outcome / Qualification etc.

During this course, participants will gain the following:

  • Diploma
  • Corporate Training
  • Hands-On Practical Training
  • Exam Preparation

Training Course Content

This course covers the following topics:

MCSA SQL Exam 70-764: Administering a SQL Database Infrastructure 2016

  • Microsoft SQL Server 2016 and Tools
  • SQL Azure
  • T-SQL Querying
  • SELECT Queries
  • Configuring Database Security - Logins, Users, and Roles
  • Server Roles and Database Roles
  • Authorizing Users to Access Resources
  • Protecting Data with Encryption and Auditing
  • Database Recovery Models and Backup Strategies
  • Managing Backup of Databases
  • Managing Restore of Databses
  • Monitoring Database Activity
  • Monitoring Queries
  • Managing Indexes
  • Monitoring SQL Server Instances
  • Automating SQL Server Management
  • Configuring Security for SQL Server Agent
  • Monitoring SQL Server with Alerts and Notifications
  • Overview of Managing SQL Server by using PowerShell
  • Tracing Access to SQL Server with Extended events
  • Monitoring SQL Server
  • Troubleshooting SQL Server
  • Importing and Exporting Data

Exam 70-765 : Provisioning SQL Databases

  • Opitimizing and Enchancing the Performance
  • Components of SQL Server 2016
  • Installation of SQL Server 2016
  • Managing Instances
  • Managing Databases
  • Microsoft Azure
  • High Availability, Disaster Recovery, and Always-On


The cost of this course is £1200 +VAT.

Discounts may apply. See above for more information. 

About provider

London Training Group

London Training Group Ltd

IT has become an indispensable feature in all spheres of human lives and this has compared businesses to re-orient their human resources through training of staff and employing IT experts to ensure efficient and successful adoption/usage of appropriate IT applications...

Read more and show all courses with this provider

Request info

Fill out your details to find out more about MCSA: SQL Server 2016 Database Administration.

  Contact the provider

  Get more information

  Register your interest

Country *

Contact info

London Training Group Ltd

4th Floor, 29 Wilson Street, Liver Pool Street
EC2M 2SJ London

 Show phone number


Average rating 5

Based on 1 reviews.

Request information

Find out more about this MCSA: SQL Server 2016 Database Administration course - simply fill out your details:

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here