Quick enquiry


Is this a business enquiry?

Member of Uk Armed Forces?

Enquire Now

MCSA: SQL 2016 Database Development

Please note that Microsoft have retired this exam. Please speak to our consultants to understand the new Microsoft role based exams

Enquire now

Why choose the MCSA: SQL 2016 Database Development?

This certification demonstrates your skills as a database professional, for both on-premises and cloud-based databases and earning an MCSA: SQL 2016 Database Development certification which qualifies you for a position as a database developer.

OverviewWhat you'll learnWhat's included

Course Guide

The key facts about your online training

Certification: MCSA SQL 2016 Database Development

Study time: 60-70 hours

Vendor: Microsoft

Provider: Skillsoft

Student support: StudentCare™

Prerequisites:  None, though it is recommended for students to have two or more years of experience in SQL database development, engineering, and administration

Assessment:  2 x 120 minute exams, 40-60 questions each

Resources: Internet access and email

Ideal for: Database administrator, systems developer, systems engineer

Included in your modules

Essential skills for your career

Manage data with Transact-SQL
Query data with advanced Transact-SQL components
Program databases by using Transact-SQL
T-sql Querying
Querying and Manipulating Data
Filter and Modify Data In Sql Server 2016
Using Functions In Sql Server 2016
Aggregating Data In Sql Server 2016
Subqueries and Predicate
Operators and Expressions In Sql Server 2016
Database Programmability Objects and Non-relational Data
Design and implement database objects
Implement programmability objects
Manage database concurrency
Optimise database objects and SQL infrastructure
Transaction and Isolation Levels
Sql Server 2016 Database Objects
Sql Server 2016 Indexes and Views
Columnstore Indexes
Programmability Objects
Triggers and Functions
Transactions and Isolation Levels
Managing Database Concurrency
Optimise Sql Database Objects and Infrastructure

Get certified the Learning People way

Professional development courses that work around you

World's #1 eLearning portal
12 months unlimited access
Global community of peers
Award winning training used globally by leading corporate clients
Hands on interfactive practice labs
Test prep

Salary Indicator

Salary Projection

Average salary after completing

Average Salary
Junior Database Administrator
Average Salary
You can earn
Average Salary
Database Programmer
Source: Adzuna


You can earn an average of £71,650.00 a year

82% of UK startups said the tech skills gap was their biggest challenge

Become an in demand professional

Get in touch

Enhance your career

Enhance your skillset and building on your knowledge of developing SQL databases

Meet demand

Meet the ever increasing demand for big data and business intelligence solutions at the enterprise level

Get hired

Validate your skills by demonstrating your ability to manage and configure Microsoft SQL Server 2016

Why learn with us?

We'll get you career ready and help place you into the industry
Learn from home 24/7
Award winning digital education
Global community of over 40,000 students
Industry leading tuition with 1:1 personal tutor access
Unrivalled 360 Career Services and StudentCare™
Access virtual seminars and live classrooms
We only partner with the biggest accreditors in the world
Gain invaluable industry experience
Exclusive student benefits; Alumni community, TOTUM, industry events and lots more
Change career, start fresh or simply advance in your current role

Our training is trusted by

Accredited by and partnered with