Teknologisk Institut

Provisioning SQL Databases [20765]
0%
Provisioning SQL Databases [20765]

Provisioning SQL Databases [20765]

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




Provisioning SQL Databases [20765]

19.499,00 kr

+45 23 33 30 30

npk@kursuszonen.dk