Provisioning SQL Databases #20765
- Learnfast is a Microsoft Silver Learning Partner. This is an authorised Microsoft Official Course (MOC).
Module 1: SQL Server 2016/2017/2019 Components
Describe the SQL Server platform, SQL Server services, and SQL Server configuration options.
-
Introduction to the SQL Server Platform
-
Overview of SQL Server Architecture
-
SQL Server Services and Configuration Options
Module 2: Installing SQL Server 2016/2017/2019
This module describes the process to install SQL Server 2016/2017/2019.
-
Considerations for installing SQL Server
-
TempDB Files
-
Installing SQL Server 2016/2017/2019
-
Automating Installation
Module 3: Upgrading SQL Server to SQL Server 2016/2017/2019
This module describes how you go about upgrading your current SQL Server installation to SQL Server 2016.
-
Upgrade Requirements
-
Upgrade SQL Server Services
-
Migrating SQL Server Data and Applications
Module 4: Deploying SQL Server on Microsoft Azure
This module describes the options available to run SQL Server on Azure.
-
SQL Server Virtual Machines in Azure
-
Deploying an Azure SQL Database
-
Migrating an On-Premise Database to an Azure SQL Database
Module 5: Working with Databases
This module describes the preinstalled system databases, the physical structure of databases and the most common configuration options related to them.
-
Overview of SQL Server Databases
-
Creating Databases
-
Database Files and Filegroups
-
Moving Database Files
-
Buffer Pool Extension
Module 6: Database Storage Options
At the end of this module you will be able to describe the database storage options.
-
SQL Server storage Performance
-
SMB Fileshare
-
SQL Server Storage in Azure
-
Stretch Databases
Module 7: Performing Database Maintenance
This module covers database maintenance.
-
Ensuring Database Integrity
-
Maintaining Indexes
-
Automating Routine Database Maintenance