If you enroll in this course without the Master Subscription plan, you receive a Free Official Exam Voucher (excluding purchases using Training Vouchers / SATV) for the 70-765 Exam. This course does not include Exam Voucher if enrolled within the Master Subscription, however, you can request to purchase the Official Exam Voucher separately.

About this course

The basic understanding and need of this course arises from the fact that every developer requires an isolated development environment in order to set up and save his progress when 2 or more developers are working on development database.

Taking this course ensures that a student will be able to provision SQL Server databases both on premise and in SQL Azure. Students will also get hands on guidance for preparation of Microsoft 70-765: Provisioning SQL Databases certification exam.

The average salary for SQL Database Administrator is $77,428 per year.

Course Objective

Successful completion of this course will enable the students to:

• Provision a Database Server

• Setup SQL Server according to the required task performance

• Provision, relocate and control databases in the cloud

• Improve the performance of SQL Server

• Run Databases and Files (shared)

Audience

This course is primarily designed for people who are in regular interaction with provisioning SQL databases. Their major tasks include setting up and maintaining databases as their daily job. This IT ops training will also add huge value to the portfolio of ones resume giving them an edge over other people.

The secondary audience for whom this course will come in most handy are those who are involved in developing applications which extract information from SQL Server databases.

Prerequisites

There are few requirements which must be met before enrolling for the course in order to ensure that the individual has the required skills needed for this course. Requirements are mentioned below:

• Fundamental basis of Microsoft Windows operating system and its core operations

• Operating information of Transact-SQL.

• Functional knowledge of relational databases.

• Previous exposure with database design

Suggested prerequisites courses

• Querying Data with Microsoft Transact-SQL (MS-20761)

• Administering Microsoft SQL Server Databases (MS-20462)