This 3-days Microsoft 20765B Provisioning SQL Databases Certification Course is Part 2 of the series of two courses of MCSA 2016: SQL Database Administration, that imparts fundamental knowledge, skills and abilities to professionals to be able to provision a Microsoft SQL Server 2016 database.
The training focuses on provisioning of SQL Server, both on premises and in Azure, that covers new installation migrating from an existing install.
After completing this course, participants will be able to:
Module 1: SQL Server 2016 Components
This module introduces the SQL Server services, SQL Server platform, and SQL Server configuration options.
Lessons
Module 2: Installing SQL Server 2016
This module explains the process to install SQL Server 2016.
Lessons
Module 3: Upgrading SQL Server to SQL Server 2016
This module explains how you go about upgrading your current SQL Server installation to SQL Server 2016.
Lessons
Module 4: Deploying SQL Server on Microsoft Azure
This module discusses the options available to run SQL Server on Azure.
Lessons
Module 5: Working with Databases
This module introduces the preinstalled system databases, the physical structure of databases and the most common configuration options related to them.
Lessons
Module 6: Database Storage Options
At the end of this module, you will be able to explain the database storage options.
Lessons
Module 7: Performing Database Maintenance
This module describes database maintenance.
Lessons
The primary audience for 70-765 provisioning SQL databases course is professionals who cater to SQL Server databases.
The secondary audiences for this course are professionals who build applications that deliver content from SQL Server databases.
Participants who attend this training should have the following technical knowledge:
Name | Code | Fee |
---|---|---|
Microsoft Certified Professional (MCP) - [70-765] | 70-765 | USD 127 |
OR