Skip to content

MCSA: SQL Server 2016 Database Administration

Classroom based 0r Attend from Anywhere|£750 inc VAT (was £1440)

London Training


Enquire to get more info on pricing
Finance options

|Pay All At Once| OR |Pay Monthly|

Take advantage of our one-year interest-free repayment plan!

Study method
4 weeks, Part-time/Full-time
MCSA: SQL 2016 Database Administration
Professional certification What's this?
Additional info
  • Tutor is available to students

76 students enquired about this course

Add to basket or enquire

Location & dates

Wilson Street
United Kingdom


London Training is a leading IT training company teamed up with the IT industry experts who have gained vast knowledge in the field of Information Technology.Boost your skills and get certified.An Authorized Training Center by Microsoft.

|Training Facilities|

  • Authorized Training Center
  • Hands-on Training
  • Tutor Led Classroom
  • Small Class Size 5-7 max
  • Central London Locations
  • Price includes Tuition Fee, VAT, and Course Material
  • Expert and Certified Trainers
  • Classes on Week Days, Evening or Weekends
  • Free Re-training
  • Modern Training Facilities
  • Inclusive Books / Materials
  • Mock Exams / Projects
  • Course Attendance Certificate

|Course Schedule|

Learn on your flexible hours. Classes in Fast Track, Week Days, Weekend, Evenings to suit your work and social life.

|Course Highlights| {Request Us For Full Brochure}

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 Databases
  • 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

  • Optimizing and Enhancing 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


MCSA: SQL 2016 Database Administration

Awarded by Microsoft

Course media



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.

|How we deliver this course|

We delivered by certified, industry expert and experienced trainers who have over 12 years of experience in Database Technologies. We provide hands-on, tutor-led and classroom-based training in Central London.

|Price Info|

  • Hands-on Tutor Led Training
  • Classroom-Based Practical Training
  • Unlimited Practice Lab Access
  • Small Size Class and Interactive Sessions
  • Lab Exercises
  • Project Work
  • Completion Certificate
  • Free Re-training
  • Cost is calculated at 70 percent Tuition Vatable and 30 percent Training Book(s) with 0 rated Vat

|Precautions Of COVID-19|

We are taking
all of the necessary precautions to keep our people healthy while supporting our customers in the best way possible.

  • Regular handwashing is one of the best ways to control the virus.
  • Please use the hand sanitiser gel in the premise or wash your hands with soap.
  • We are maintaining "Social Distancing" in the classrooms.
  • We are spraying disinfectant all over the place regularly after every session.
  • We are sanitizing the desk, mouse, keyboard, monitor and CPU every day.
  • Most importantly we are providing a small kit of protection to our students which includes sanitizer, gloves and facemask.

|Learning Facilities|

We have immaculate learning facilities with state of art technology, fully equipped with high specs latest servers, workstations and software.

|General Facilities|

We also provide Free Wifi Internet, Refreshment, Water, Tea and Coffee Facilities.

|Pay In Instalments|

You can also take advantage of our one-year interest-free repayment plan! Join the course today with confidence and pay as little as £108.00 per month for 12 months.

|Registration Process|

Speak with our Course Advisor

Who is this course for?

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.


Basic knowledge of IT

Career path


Boost your skills and get certified Database administrators, Software Developers, Project Managers etc.

Package Offers:


Giveaway Price £3000+VAT for 3 courses / Save £600

  1. MCSA: SQL Server 2016 Develop - £1200
  2. MCSA: SQL Server 2016 Admin - £1200
  3. MCSA: SQL Server 2016 BI Develop - £1200

Request Us For More Packages Info


Questions and answers


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