MOC On-Demand: 20765-Provisioning SQL Databases - On-Demand Course

  The Provisioning SQL Databases - 20765 course is a 5-day course that is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.

Topics covered in the course include:

• Provision a Database Server
• Upgrade SQL Server
• Configure SQL Server
• Manage Databases and Files (shared)
• Provision, migrate and manage databases in the cloud

Target Student:This course is designed for IT Professionals who administer and maintain SQL Server databases.

Students should possess the following experience before attending the course:

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

Section 1: SQL Server 2016 Components
This section describes the various SQL Server 2016 components and versions.

Topics :
Introduction to the SQL Server Platform
Overview of SQL Server Architecture
SQL Server Services and Configuration Options

Lab :
Discussion: SQL Server versions
When we do use a separate installation of SQL Server and when would use a separate instance?
Which version of SQL Server is most suitable in your organization?

Section 2: Installing SQL Server 2016
This sections describes the process to install SQL Server 2016.

Topics :
Considerations for SQL Installing Server
TempDB Files
Installing SQL Server 2016
Automating Installation

Lab :
Installing SQL Server
Assess the available resources
Install an instance of SQL Server
Perform post installation checks
Automating Installation

Section 3: Upgrading SQL Server to SQL Server 2016
This section describes the process for upgrading to SQL Server 2016.

Topics :
Upgrade Requirements
Upgrade SQL Server Services
Migrating SQL Server Data and Applications

Lab :
Upgrading SQL Server
Create the Application Logins
Restore Database Backups
Orphaned Users and Database Compatibility Level

Section 4: Working with Databases
This section describes the preinstalled system databases, the physical structure of databases and the most common configuration options related to them.

Topics :
Introduction to Data Storage with SQL Server
Managing Storage for System Databases
Managing Storage for User Databases
Moving and Copying Database Files
Side-by-Side Upgrade: Migrating SQL Server Data and Applications
Buffer Pool Extension

Lab :
Managing Database Storage
Configuring tempdb Storage
Creating Databases
Attaching a Database
Enable Buffer Pool Extension

Section 5: Performing Database Maintenance
This section covers database maintenance plans.

Topics :
Ensuring Database Integrity
Maintaining Indexes
Automating Routine Database Maintenance

Lab :
Performing Database Maintenance
Use DBCC CHECKDB to Verify Database Integrity
Rebuild Indexes
Create a Database Maintenance Plan

Section 6: Database Storage Options
Describe SQL Server storage options.

Topics :
SQL Server storage Performance
SMB Fileshare
SQL Server Storage in Microsoft Azure
Stretch Databases

Lab :
Implementing Stretch Database
Run Stretch Database Advisor
Implement Stretch Database

Section 7: Planning to Deploy SQL Server on Microsoft Azure
This section describes how to plan to deploy SQL Server on Azure.

Topics :
SQL Server Virtual Machines in Azure
Azure Storage
Azure SQL Authentication
Deploying an Azure SQL Database

Lab :
Plan and Deploy an Azure SQL Database
Plan an Azure SQL Database, Networking, performance tiers, security
Provision an Azure SQL Database
Connect to an Azure SQL Database

Section 8: Migrating Databases to Azure SQL Database
This section describes how to migrate databases to Azure SQL Database.

Topics :
Database Migration Testing Tools
Database Migration Compatibility Issues
Migrating a SQL Server Database to Azure SQL Database

Lab :
Migrating SQL Server Databases to Azure
Perform Migration Testing
Migrate a SQL Server Database to Azure SQL Database
Test a Migrated Database

Section 9: Deploying SQL Server on a Microsoft Azure Virtual Machine
This section describes how to deploy SQL Server on Microsoft Azure VMs.

Topics :
Deploying SQL Server on an Azure VM
The Deploy Database to a Microsoft Azure VM Wizard

Lab :
Deploying SQL Server on an Azure Virtual Machine
Provision an Azure VM
Use the Deploy Database to Azure VM Wizard

Section 10: Managing databases in the Cloud
This section describes how to manage SQL Server on Azure.

Topics :
Managing Azure SQL Database Security
Configure Azure storage
Azure Automation

Lab :
Managing Databases in the Cloud
Configure Azure Security
Automate Azure Deployment