Provisioning SQL Databases (M20765)
Days: 3 day
Price: $2195
Course Details
This course provides you with the knowledge and skills to provision a Microsoft SQL Server 2016 database. You will cover SQL Server 2016 provision both on-premise and in Azure, and you?ll cover installing from new and migrating from an existing install.
This course incorporates material from the Official Microsoft Learning Product 20765: Provisioning SQL Databases.
Course Agenda
Course Outline:
1. SQL Server 2016 Components
- Introduction to the SQL Server Platform
- Overview of SQL Server Architecture
- SQL Server Services and Configuration Options
2. Installing SQL Server 2016
- Considerations for Installing SQL Server
- TempDB Files
- Installing SQL Server 2016
- Automating Installation
3. Upgrading SQL Server to SQL Server 2016
- Upgrade Requirements
- Upgrade SQL Server Services
- Migrating SQL Server Data and Applications
4. Deploying SQL Server on Microsoft Azure
- SQL Server Virtual Machines in Azure
- Deploying an Azure SQL Database
- Migrating an On-Premise Database to an Azure SQL Database
5. Working with Databases
- Overview of SQL Server Databases
- Creating Databases
- Database Files and Filegroups
- Moving Database Files
- Buffer Pool Extension
6. Database Storage Options
- SQL Server Storage Performance
- SMB Fileshare
- SQL Server Storage in Azure
- Stretch Databases
7. Performing Database Maintenance
- Ensuring Database Integrity
- Maintaining Indexes
- Automating Routine Database Maintenance
Details |
Options |
---|