Provisioning SQL Databases (MS20765)

This 5 day instructor led training course teaches students how to provision SQL databases both on premise and in SQL Azure.

Cena

625€
5 dana / 35 sati

Lokacija

Beograd

Virtuelna učionica

On-Demand

Datum

Kontaktirajte nas

Prijava

Plan obuke: 

Module 1: SQL Server Components

This module describes the various SQL Server components and versions.

  • Introduction to the SQL Server Platform
  • Overview of SQL Server Architecture
  • SQL Server Services and Configuration Options

Module 2: Installing SQL Server

This modules describes the process to install SQL Server 2016.

  • Considerations for SQL Installing Server
  • TempDB Files
  • Installing SQL Server
  • Automating Installation

Module 3: Upgrading SQL Server to SQL Server 2017

This module describes the process for upgrading to SQL Server 2017.

  • Upgrade Requirements
  • Upgrade SQL Server Services
  • Side by Side Upgrade: Migrating SQL Server Data and Applications

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.

  • Introduction to Data Storage with SQL Server
  • Managing Storage for System Databases
  • Managing Storage for User Databases
  • Moving and Copying Database Files
  • Buffer Pool Extension

Module 5: Performing Database Maintenance

This module covers database maintenance plans.

  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance

Module 6: Database Storage Options

Describe SQL Server 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

This module describes how to plan to deploy SQL Server on 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

This module describes how to migrate 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

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

  • Deploying SQL Server on an Azure VM
  • The Deploy Database to a Microsoft Azure VM Wizard

Module 10: Managing databases in the Cloud

  • This module describes how to manage SQL Server on Azure.
  • Managing Azure SQL Database Security
  • Configure Azure storage
  • Azure Automation
Benefiti: 
  • Video snimak predavanja u periodu od 365 dana posle kraja Vaše obuke

  • Pristup laboratorijama putem Interneta 180 dana od kraja Vaše obuke

  • Materijal u elektronskom obliku koji se automatski ažurira

  • Zvaničan Microsoft sertifikat o pohađanju kursa

  • Besplatno pohađanje iste obuke na potvrđenim terminima u sledećih 365 dana

  • Moguće je iskoristiti Microsoft trening vaučere za plaćanje ove obuke
Poželjno predznanje: 

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