Module 1: SQL Server Components
- Introduction to the SQL Server Platform
- Overview of SQL Server Architecture
- SQL Server Services and Configuration Options
Module 2: Installing SQL Server
- Considerations for SQL Installing Server
- TempDB Files
- Installing SQL Server
- Automating Installation
Lab: Installing SQL Server
Module 3: Upgrading SQL Server to SQL Server 2017
- Upgrade Requirements
- Upgrade SQL Server Services
- Side by Side Upgrade: Migrating SQL Server Data and Applications
Lab: Upgrading SQL Server
Module 4: 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
- Buffer Pool Extension
Lab: Managing Database Storage
Module 5: Performing Database Maintenance
- Ensuring Database Integrity
- Maintaining Indexes
- Automating Routine Database Maintenance
Lab: Performing Database Maintenance
Module 6: Database Storage Options
- SQL Server storage Performance
- SMB Fileshare
- SQL Server Storage in Microsoft Azure
- Stretch Databases
Lab: Implementing Stretch Database
Module 7: Planning to Deploy SQL Server on Microsoft Azure
- SQL Server Virtual Machines in Azure
- Azure Storage
- Azure SQL Authentication
- Deploying an Azure SQL Database
Lab: Plan and Deploy an Azure SQL Database
Module 8: Migrating Databases to Azure SQL Database
- Database Migration Testing Tools
- Database Migration Compatibility Issues
- Migrating a SQL Server Database to Azure SQL Database
Lab: Migrating SQL Server Databases to Azure
Module 9: Deploying SQL Server on a Microsoft Azure Virtual Machine
- 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
Module 10: Managing databases in the Cloud
- Managing Azure SQL Database Security
- Configure Azure storage
- Azure Automation
Lab: Managing Databases in the Cloud