Database Technologies

Microsoft SQL Server

MICROSOFT CERTIFIED SOLUTIONS ASSOCIATE (MCSA) DATABASE ADMINISTRATION - SQL-2016


Administering a SQL Database Infrastructure 70-764 (40 HOURS)

  • Configure Data Access & Auditing
  • Manage Backup and Restore of Databases
  • Manage & Monitor SQL Server Instances
  • Manage High Availability & Disaster Recovery

Provisioning SQL Databases - 70-765 (40 HOURS)

  • Implement SQL in Azure
  • Manage Databases and Instances
  • Deploy & Migrate Applications

MICROSOFT CERTIFIED SOLUTIONS ASSOCIATE (MCSA) SQL-2016 DATABASE DEVELOPMENT

Querying Data with Transact-SQL - 70-761 40 HOURS

  • Manage Data with Transact SQL
  • Query Data with Advanced Transact - SQL Components
  • Program Databases by Using Transact-SQL

Developing SQL Database – 70-762 40 HOURS

  • Design & Implement Database Objects
  • Implement Programmability Objects
  • Manage Database Concurrency
  • Optimize Database Objects & SQL Infrastructure

MICROSOFT CERTIFIED SOLUTIONS EXPERT (MCSE) DATA MANAGEMENT & ANALYTICS



Prerequisites: MCSA SQL 2016 Database Administration or MCSA SQL 2016 Database Development

Pass one of the following exams to get this certification.


Developing Microsoft SQL Server Databases 70-464 40 HOURS

  • Implement Database Objects
  • Implement Programming Objects
  • Design Database Objects
  • Optimize & Troubleshoot Queries

Designing Database Solutions for Microsoft SQL Server 70-465 40 HOURS

  • Design a Database Structure
  • Design Databases & Database Object
  • Design Database Security
  • Design Troubleshooting & Optimization Solution

Implementing Data Models & Reports with Microsoft SQL Server 70-466 40 HOURS

  • Build an Analysis Services Multidimensional Database
  • Manage, Maintain, & Troubleshoot a SQL Server Analysis Services (SSAS) Database
  • Build a Tabular Data Model
  • Build a Report with SQL Server Reporting Services (SSRS)

Alliance Partner