Quick enquiry


Select all that apply (optional):

Is this a business enquiry?


MCSA: SQL 2016 Database Development

If you're looking to demonstrate your skill in building and implementing database solutions onsite and in the Cloud, then the MCSA SQL 2016 Database Development certification is for you

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're tech career experts
Exclusive student benefits; Career Services, TOTUM, industry events and lots more
Award winning StudentCare™
25,000+ students worldwide
Partnered with biggest accreditors in the world
Alternative to traditional university education
Start a new career or advance your current one & land your dream job
Join our online Alumni community and connect with like-minded professionals

Our training is trusted by

Accredited by and partnered with

Celebratingten yearsCelebratingten yearsCelebrating
ten years

Learning People (IRE) Ltd, 8-9
Westmoreland St, Dublin 2.

Learning People, The Agora, Ellen Street, Brighton,
BN3 3LN.

Learning People, Tower 2, 11-24, 101 Grafton St, Bondi Junction, Sydney, NSW, 2022.

New Zealand
Learning People, Level 3, 151 Cambridge Terrace, Christchurch Central, 8013.

© The Learning People 2020FAQTerms & ConditionsPrivacy PolicyTerms of website use
The Learning People Ltd is authorised and regulated by the Financial Conduct Authority, register number 689955, and act as a credit broker and not a lender.Finance is provided through the Deko platform by Omni Capital Retail Finance Limited.Omni Capital Retail Finance Limited is authorised and regulated by the Financial Conduct Authority (register number 720279). Learning People company number: 07182042