M-20765: Provisioning SQL Databases (MOC)
ZurückSchulungsinhalt
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
Voraussetzungen
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases.
- Some experience with database design
Zielgruppe
Datenbankentwickler
Kursdauer
5 Tag(e)
Veranstaltungsort
Hannover
Preis
2390,00 EUR zzgl. 19% Mwst.