20765: Provisioning SQL Databases – Official Microsoft Course

Teacher

aktina

Introduction:

This instructor-led course provides students with the knowledge and skills to be successful in the provision of a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.

Audience:

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.
The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

At Course Completion:

After completing this course, students will be able to:

Provision a Database Server
Upgrade SQL Server
Configure SQL Server
Manage Databases and Files (shared)

Prerequisites:

This course requires that you meet the following prerequisites:

Basic knowledge of the Microsoft Windows operating system and its core functionality
Working knowledge of Transact-SQL
Working knowledge of relational databases
Some experience with database design

These prerequisites can be achieved by attending course 20761A – Querying Data with Transact-SQL

Professional Exam(s)

Exam 70-765: Provisioning SQL Databases

Certification(s):

MCSA: SQL 2016 Database Administration

MODULES 7
- Lecture1.1
  
  SQL Server 2016 Components
- Lecture1.2
  
  Installing SQL Server 2016
- Lecture1.3
  
  Upgrading SQL Server to SQL Server 2016
- Lecture1.4
  
  Deploying SQL Server on Microsoft Azure
- Lecture1.5
  
  Working with Databases
- Lecture1.6
  
  Database Storage Options
- Lecture1.7
  
  Performing Database Maintenance

City

Nicosia

Dates and Times

1. Monday Jan 21 8:00 - 15:10
2. Wednesday Jan 23 8:00 - 15:10
3. Friday Jan 25 8:00 - 15:10
4. Monday Jan 28 8:00 - 15:10
5. Wednesday Jan 30 8:00 - 15:10
6. Friday Feb 1 8:00 - 15:10

Duration (Hours)

Location

20 Louki Akrita street, 2064 Strovolos
(behind Kykko secondary schools)

City

Limassol

Dates and Times

1. Monday Feb 4 8:30 - 15:40
2. Wednesday Feb 6 8:30 - 15:40
3. Friday Feb 8 8:30 - 15:40
4. Monday Feb 11 8:30 - 15:40
5. Wednesday Feb 13 8:30 - 15:40
6. Friday Feb 15 8:30 - 15:40

Duration (Hours)

Location

22 Griva Digeni Avenue, 3106 Agios Nikolaos
(200 m. from the roundabout, near Agios Nikolaos church)

For participants eligible for subsidy by the Human Resource Development Authority:

	Participation *	Course Manual	Exam
	Official Course 20765	Official - digital	70-765
Amount	€525,00	€205,00	€100,00
VAT *	€228,95	€38,95	-

* denotes a course subsidised by the Human Resource Development Authority. VAT is applied on the amount before subsidy

This course is also offered at a high discount as part of a bundle of 3 certification courses – click here

For participants not eligible for subsidy by the Human Resource Development Authority:

	Participation	Course Manual	Exam
	Official Course 20765	Official - digital	70-765
Amount	€600,00	€205,00	€100,00
VAT	€114,00	€38,95	-

This course is also offered at a high discount as part of a bundle of 3 certification courses – click here

Take advantage of our special offer by taking this course as part of a bundle of 3 courses leading to the following prestigious MCSA certification:

For participants eligible for subsidy by the Human Resource Development Authority:

	Participation *	Course Manuals	Exams
	Courses 20764 & 20765	Official 20764 & 20765 **	70-764 & 70-765
Amount	€340,00	€323,00	incl.
VAT *	€323,50	€72,58	incl.