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

Key details

Degree Type

Non-Award

Study Mode

Online

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.

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