Module 1: SQL Server 2016 Components
This module describes the various SQL Server 2016 components and versions
- Lessons:
- 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?
Module 2: Installing SQL Server 2016
This module describes the process to install SQL Server 2016.
- Lessons:
- Considerations for SQL Installing Server
- Temp Db 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
Module 3: Upgrading SQL Server to SQL Server 2016
This module describes the process for upgrading to SQL Server 2016.
- Lessons:
- 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
Module 4: Working with Databases
This module describes the reinstalled system databases, the physical structure of databases and the most common configuration options related to them.
- Lessons:
- 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
Module 5: Performing Database Maintenance
This module covers database maintenance plans.
- Lessons:
- Ensuring Database Integrity
- Maintaining Indexes
- Automating Routine Database Maintenance
- Lab: Performing Database Maintenance
- Use DB CC CHECK DB to Verify Database Integrity
- Rebuild Indexes
- Create a Database Maintenance Plan
Module 6: Database Storage Options
Describe SQL Server storage options.
- Lessons:
- SQL Server storage Performance
- SMB File share
- SQL Server Storage in Microsoft Azure
- Stretch Databases
- Lab: Implementing Stretch Database
- Run Stretch Database Advisory
- Implement Stretch Database
Module 7: Planning to Deploy SQL Server on Microsoft Azure
This module describes how to plan to deploy SQL Server on Azure.
- Lessons:
- 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
Module 8: Migrating Databases to Azure SQL Database
This module describes how to migrate databases to Azure SQL Database.
- Lessons:
- 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
Module 9: Deploying SQL Server on a Microsoft Azure Virtual Machine
This module describes how to deploy SQL Server on Microsoft Azure VMs
- Lessons:
- 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
Module 10: Managing databases in the Cloud
This module describes how to manage SQL Server on Azure.
- Lessons:
- Managing Azure SQL Database Security
- Configure Azure storage
- Azure Automation
- Lab: Managing Databases in the Cloud
- Configure Azure Security
- Automate Azure Deployment.
