V.le P.A. Pirelli 6, Milano - academy@digi.it - 0269438264

Corsi Microsoft

Cerca un corso

Provisioning SQL Databases

Codice corso: 20765C
Durata corso: 5gg

Introduzione

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

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

Obiettivi del corso

After completing this course, students will be able to:

Provision a Database Server

Upgrade SQL Server

Configure SQL Server

Manage Databases and Files (shared)

Provision, migrate and manage databases in the cloud

Prerequisiti

This course requires that you meet the following prerequisites:

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

Struttura del Corso

MODULE 1: SQL Server Components

This module describes the various SQL Server components and versions.

Lessons

After completing this module, you will be able to:

Describe SQL Server components and versions

Describe SQL Server architecture and resource usage

Describe SQL Server services and how you manage the configuration of those services

MODULE 2: Installing SQL Server

This modules describes the process to install SQL Server 2016

Lessons

After completing this module, you will be able to:

Describe the considerations when installing SQL Server

Describe TempDB files

Install SQL Server

Automate a SQL Server installation

Lab : Installing SQL Server

MODULE 3: Upgrading SQL Server to SQL Server 2017

This module describes the process for upgrading to SQL Server 2017

Lessons

After completing this module, you will be able to:

Describe the upgrade requirements for SQL Server

Upgrade SQL Server Services

Migrate SQL Server Data and Applications

Create the Application Logins

Restore the backups of the TSQL Database

Orphaned Users and Database Compatibility Level

Lab : Upgrading SQL Server

MODULE 4: Working with Databases

This module describes the preinstalled system databases, the physical structure of databases and the most common configuration options related to them.

Lessons

After completing this module, you will be able to:

Describe Data Storage with SQL Server

Manage Storage for System Databases

Manage Storage for User Databases

Move and Copy Database Files

Describe and use Buffer Pool Extensions

Lab : Managing Database Storage

MODULE 5: Performing Database Maintenance

This module covers database maintenance plans

Lessons

After completing this module, you will be able to:

Ensure Database Integrity

Use DBCC CHECKDB to Verify Database Integrity

Maintain Indexes

Rebuild Indexes

Create a Database Maintenance Plan

Automate Routine Database Maintenance

Lab : Performing Database Maintenance

MODULE 6: Database Storage Options

Describe SQL Server storage options.

Lessons

After completing this module, you will be able to:

Describe SQL Server Storage Performance

Describe SMB Fileshare

Explain SQL Server Storage in Microsoft Azure

Run Stretch Database Advisor

Implement Stretch Database

Lab : Implementing Stretch Database

MODULE 7: Planning to Deploy SQL Server on Microsoft Azure

This module describes how to plan to deploy SQL Server on Azure

Lessons

After completing this module, you will be able to:

Describe SQL Server Virtual Machines in Azure

Describe Azure Storage

Explain Azure SQL Authentication, auditing and compliance

Deploy an Azure SQL Database

Lab : Plan and Deploy an Azure SQL Database

MODULE 8: Migrating Databases to Azure SQL Database

This module describes how to migrate databases to Azure SQL Database

Lessons

After completing this module, students will be able to:

Describe various database Migration Testing Tools

Explain database Migration Compatibility Issues

Migrate a SQL Server Database to Azure SQL Database

Perform Migration Testing

Migrate a SQL Server Database to Azure SQL Database

Test a Migrated Database

Lab : Migrating SQL Server Databases to Azure

MODULE 9: Deploying SQL Server on a Microsoft Azure Virtual Machine

This module describes how to deploy SQL Server on Microsoft Azure VMs.

Lessons

After completing this module, students will be able to:

Deploy SQL Server on an Azure VM

Use The Deploy Database to a Microsoft Azure VM Wizard

Configure SQL Server Connections

Lab : Deploying SQL Server on an Azure Virtual Machine

MODULE 10: Managing databases in the Cloud

This module describes how to manage SQL Server on Azure

Lessons

After completing this module, students will be able to:

Manage Azure SQL Database Security

Configure Azure storage

Implement Azure Automation

Additional Reading

Add data masking

Use Azure automation to stop Virtual Machines

Lab : Managing Databases in the Cloud

P.IVA 06249920965
C.C.I.A.A. REA: MI - 1880014
Cap. Soc. € 12.000,00

Contatti

V.le P.A. Pirelli 6,20126 Milano
Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo.
Tel.: +39 02 694 382 64
Fax.: +39 02 694 382 35

© Copyright 2020 DI.GI. Academy
Privacy Policy | Cookie Policy