M-20765: Provisioning SQL Databases (MOC)

Zurück

This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.

Schulungsinhalt

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

Kommende Termine

24.02.2020, 09:00 Uhr - 28.02.2020, 16:30 Uhr
Preis: 2390,00 EUR zzgl. 19% Mwst. (2844,10 EUR Brutto)
22.06.2020, 09:00 Uhr - 26.06.2020, 16:30 Uhr
Preis: 2390,00 EUR zzgl. 19% Mwst. (2844,10 EUR Brutto)
21.09.2020, 09:00 Uhr - 25.09.2020, 16:30 Uhr
Preis: 2390,00 EUR zzgl. 19% Mwst. (2844,10 EUR Brutto)
PDF Download