Beskrivelse
Lær at anvende, installere og konfigurere SQL Server databaser, herunder anvendelse af både interne og SQL Azure løsninger. Kurset omhandler både nyinstallationer og migrering fra eksisterende installationer. Kurset er for dig der administrerer, konfigurerer og vedligeholder en SQL Database.
Deltagerprofil
Kurset er for dig, der administrerer og vedligeholder en Microsoft SQL Database eller udvikler indhold baseret på en SQL Server.
Du forventes at have grundlæggende kendskab til Transact-SQL og relationelle databaser og evt. lidt erfaring med databasedesign eller viden svarende til kurset Querying Data with Transact-SQL [20761].
Indhold
Module 1: SQL Server Components
Introduction to the SQL Server Platform
Overview of SQL Server Architecture
SQL Server Services and Configuration Options
Module 2: Installing SQL Server
Considerations for installing SQL Server
TempDB Files
Installing SQL Server
Automating Installation
Module 3: Upgrading SQL Server to SQL Server 2017
Upgrade Requirements
Upgrade SQL Server Services
Migrating SQL Server Data and Applications
Module 4: 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
Module 5: Performing Database Maintenance
Ensuring Database Integrity
Maintaining Indexes
Automating Routine Database Maintenance
Module 6: Database Storage Options
SQL Server storage Performance
SMB Fileshare
SQL Server Storage in Microsoft Azure
Stretch Databases
Module 7: Planning to Deploy SQL Server on Microsoft Azure
SQL Server Virtual Machines in Azure
Azure Storage
Azure SQL Authentication
Deploying an Azure SQL Database
Module 8: Migrating Databases to Azure SQL Database
Database Migration Testing Tools
Database Migration Compatibility Issues
Migrating a SQL Server Database to Azure SQL Database
Module 9: Deploying SQL Server on a Microsoft Azure Virtual Machine
Deploying SQL Server on an Azure VM
The Deploy Database to a Microsoft Azure VM Wizard
Module 10: Module 10: Managing databases in the Cloud
Managing Azure SQL Database Security
Configure Azure storage
Azure Automation
Microsoft Software Assurance Vouchere Kurset kan betales med 5 SA Vouchere.
Underviser Undervisningen varetages af en erfaren underviser fra Teknologisk Instituts netværk bestående af branchens dygtigste undervisere.
Deltagerprofil Kurset er for dig, der administrerer og vedligeholder en Microsoft SQL Database eller udvikler indhold baseret på en SQL Server.
Du forventes at have grundlæggende kendskab til Transact-SQL og relationelle databaser og evt. lidt erfaring med databasedesign eller viden svarende til kurset Querying Data with Transact-SQL [20761].
Lær at anvende, installere og konfigurere SQL Server databaser, herunder anvendelse af både interne og SQL Azure løsninger. Kurset omhandler både nyinstallationer og migrering fra eksisterende installationer. Kurset er for dig der administrerer, konfigurerer og vedligeholder en SQL Database.
Microsoft Software Assurance Vouchere Kurset kan betales med 5 SA Vouchere.
Indhold Module 1: SQL Server Components
Introduction to the SQL Server Platform
Overview of SQL Server Architecture
SQL Server Services and Configuration Options
Module 2: Installing SQL Server
Considerations for installing SQL Server
TempDB Files
Installing SQL Server
Automating Installation
Module 3: Upgrading SQL Server to SQL Server 2017
Upgrade Requirements
Upgrade SQL Server Services
Migrating SQL Server Data and Applications
Module 4: 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
Module 5: Performing Database Maintenance
Ensuring Database Integrity
Maintaining Indexes
Automating Routine Database Maintenance
Module 6: Database Storage Options
SQL Server storage Performance
SMB Fileshare
SQL Server Storage in Microsoft Azure
Stretch Databases
Module 7: Planning to Deploy SQL Server on Microsoft Azure
SQL Server Virtual Machines in Azure
Azure Storage
Azure SQL Authentication
Deploying an Azure SQL Database
Module 8: Migrating Databases to Azure SQL Database
Database Migration Testing Tools
Database Migration Compatibility Issues
Migrating a SQL Server Database to Azure SQL Database
Module 9: Deploying SQL Server on a Microsoft Azure Virtual Machine
Deploying SQL Server on an Azure VM
The Deploy Database to a Microsoft Azure VM Wizard
Module 10: Module 10: Managing databases in the Cloud
Managing Azure SQL Database Security
Configure Azure storage
Azure Automation