Schulungsinhalt

SQL Server 2016 Components

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

Installing SQL Server 2016

• Considerations for installing SQL Server
• TempDB Files
• Installing SQL Server 2016
• Automating Installation

Upgrading SQL Server to SQL Server 2016

• Upgrade Requirements
• Upgrade SQL Server Services
• Migrating SQL Server Data and Applications

Working with Databases

• 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

Performing Database Maintenance

• Ensuring Database Integrity
• Maintaining Indexes
• Automating Routine Database Maintenance

Database Storage Options

• SQL Server storage Performance
• SMB Fileshare
• SQL Server Storage in Azure
• Stretch Databases

Planning to Deploy SQL Server on Microsoft Azure

• SQL Server Virtual Machines in Azure
• Azure Storage
• Azure SQL Authentication
• Deploying an Azure SQL Database

Migrating Databases to Azure SQL Database

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

Deploying SQL Server on a Microsoft Azure Virtual Machine

• Deploying SQL Server on an Azure VM
• The Deploy Databse to a Microsoft Azure VM Wizard

Managing databases in the Cloud

• Managing Azure SQL Database Security
• Configure Azure storage
• Azure Automation