MCSA: SQL Server Certification

SQL server has been one of the standards in the IT industry when it comes to working with relational databases for decades. When it comes to comprehensive data platform, SQL server is the basis for Microsoft. It provides innovative function for mission-critical applications, using in-memory tech, faster insights from any data to any user in recognizable tools such as Excel, and a resilient platform for building, deploying, and managing solutions that span on-premises and cloud.

Below are the paths for certification for both SQL Server 2016 and SQL Server 2012/2014 (details charts in the tabs below):

 

Key Features

SQL Server 2016 boast of a vast bound forward for the data platform with faster transactions and queries, advanced analytics, and new hybrid cloud scenarios.  There are 3 MCSA Certificates available for Microsoft SQL Server 2016

MCSA: SQL 2016 Database Administration

The MCSA SQL 2016 Database Administration certification validates your skills with database installation, maintenance, configuration, and provisioning tasks, and will qualify you for a position as a database administrator or infrastructure specialist. Below are the two exams and the coinciding training for the exams.

Click on each Training course for more information or to view a nationwide schedule of training options.

MCSA : SQL 2016 DATABASE ADMINISTRATION

  • Exams that Must be Passed
  • 70-764 Administering a SQL Database Infrastructure
  • 70-765 Provisioning SQL Databases
  • Individual Training Courses
  • Administering a SQL Database Infrastructure (20764B)
  • Provisioning SQL Databases (20765B)

MCSA: SQL 2016 Database Development

This validates your skills in building and implementing databases across organizations, and will qualify you for a position as a database developer. Below are the two exams and the coinciding training for the exams.

Click on each Training course for more information or to view a nationwide schedule of training options.

MCSA : SQL 2016 DATABASE DEVELOPMENT

  • Exams that Must be Passed
  • 70-761 Querying Data with Transact-SQL
  • 70-762 Developing SQL Databases
  • Individual Training Courses
  • Querying Data with Transact-SQL (20761B)
  • Developing SQL Databases (20762B)

MCSA: SQL 2016 Business Intelligence Development

Validates your extract, transform, and load (ETL) and data warehouse skills, along with those for implementing BI solutions using multidimensional and tabular data models and online analytical processing (OLAP) cubes. This certification will qualify you for a position as a BI developer. Below are the two exams and the coinciding training for the exams.

Click on each Training course for more information or to view a nationwide schedule of training options.

 

MCSA : SQL 2016 BUSINESS INTELLIGENCE DEVELOPMENT

  • Exams that Must be Passed
  • 70-767 Implementing a SQL Data Warehouse
  • 70-768 Developing SQL Data Models
  • Individual Training Courses
  • Implementing a SQL Data Warehouse (20767B)
  • Developing SQL Data Models (20768B)

There is only 1 MCSA certificate available for SQL Server 2012/2014. This certification demonstrates your skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments.

Below is a path of the training path necessary for the above MCSA SQL Server 2012/2014: Click on any of the courses below to find out more about the training.

MCSA : SQL Server 2012/2014

  • Exams that Must be Passed
  • 70-461: Querying Microsoft SQL Server 2012/2014
  • 70-462: Administering Microsoft SQL Server 2012/2014 Databases
  • 70-463 Implementing a Data Warehouse with Microsoft SQL Server

questions? contact us