Descrizione del corso
This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.
Programma
- SQL Server 2016
- Introduction to the SQL Server Platform
- Overview of SQL Server Architecture
- SQL Server Services and Configuration Options
- Installing SQL Server 2016T
- 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
- 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
- Working with Databases
- Overview of SQL Server Databases
- Creating Databases
- Database Files and Filegroups
- Moving Database Files
- Buffer Pool Extension
- Database Storage Options
- SQL Server storage Performance
- SMB Fileshare
- SQL Server Storage in Azure
- Stretch Databases
- Performing Database Maintenance
- Ensuring Database Integrità
- Maintaining Indexes
- Automating Routine Database Maintenance
