academy-it-microsoft-office-vendor-training

55369A – Provisioning Databases on SQL Server

$4,100.00

About this course

This five-day instructor-led course is intended for IT professionals who are interested in expanding their knowledge base and technical skills about SQL Server. In this course, students learn how to provision SQL Server databases both on-premises and in Azure. The course covers new installations and migrations from existing installations.

Course Outline

 

Clear

Description

Audience Profile

This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills.

At Course Completion

After completing this course, students will be able to:

  • Describe the components of SQL Server
  • Provision a database server that runs SQL Server
  • Upgrade a database server
  • Configure a new database on SQL Server
  • Maintain a database hosted on SQL Server
  • Configure storage for a database
  • Plan to deploy SQL Server on Microsoft Azure
  • Move a database from SQL Server on premises to Microsoft Azure
  • Provision SQL Server on an Azure virtual machine

Prerequisites

  • Basic understanding of relational databases
  • Basic Windows knowledge

Course Outline